Last post Mar 14, 2011 06:36 AM by kapilbharat
Mar 11, 2011 05:28 AM|kapilbharat|LINK
How data can be exported from TelrikRadGrid To excel.
point to be noted.
1. No hyperlink or button column should be exported from the RadGrid
2.Any controls such as pager or footer should not be exported
3.Export primary key also so that it will be used for updating the data when importing from excel to RadGrid.
please reply soon.
Mar 11, 2011 01:24 PM|asheejtk|LINK
At present this featute is not available, refer below thread for detail,
Mar 12, 2011 01:03 AM|Rajneesh Verma|LINK
See with demo codes:
Mar 14, 2011 06:19 AM|kapilbharat|LINK
Brother it is possible.
you can find some useful links on net.
Mar 14, 2011 06:36 AM|kapilbharat|LINK
i got it brother, thanks.
Could you tell me Importing from Excel to RadGrid.
i am trying this code
DataTable dt = new DataTable();
string Excel = Server.MapPath("App_Data/MyDataFile.xls");
string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Excel + ";Extended Properties=HTML Import;";
using (OleDbConnection conn = new OleDbConnection(connect))
using (OleDbCommand cmd = new OleDbCommand())
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM [MyDataFile$]";
cmd.CommandType = CommandType.Text;
but having this error.
The Microsoft Jet database engine could not find the object 'MyDataFile$'. Make sure the object exists and that you spell its name and the path name correctly.
Could you gide me over this issue.