The content you're reading is getting on in years
This post is on the older side and its content may be out of date.
Be sure to visit our blogs homepage for our latest news, updates and information.
using System; |
using System.Data.OleDb; |
using System.Data; |
public partial class Files_RadGridExcelDataSource : System.Web.UI.UserControl |
{ |
protected void Page_Load(object sender, EventArgs e) |
{ |
} |
protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) |
{ |
// Create a new Adapter |
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(); |
// retrieve the Select command for the Spreadsheet |
objDataAdapter.SelectCommand = ExcelConnection(); |
// Create a DataSet |
DataSet objDataSet = new DataSet(); |
// Populate the DataSet with the spreadsheet worksheet data |
objDataAdapter.Fill(objDataSet); |
// Bind the data to the RadGrid |
RadGrid1.DataSource = objDataSet.Tables[0].DefaultView; |
} |
protected OleDbCommand ExcelConnection() |
{ |
// Connect to the Excel Spreadsheet |
string xConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + |
"Data Source=" + Server.MapPath(@"~\Files\Test.xls") + ";" + |
"Extended Properties=Excel 8.0;"; |
// create your excel connection object using the connection string |
OleDbConnection conn = new OleDbConnection(xConnStr); |
conn.Open(); |
// use a SQL Select command to retrieve the data from the Excel Spreadsheet |
// the "table name" is the name of the worksheet within the spreadsheet |
// in this case, the worksheet name is "Customers" and is coded as: [Customers$] |
OleDbCommand objCommand = new OleDbCommand("SELECT * FROM [Customers$]", conn); |
return objCommand; |
} |
} |
Special thanks to Nannette Thacker and her detailed code samples. A VB.NET sample is also available on her site. For more info on uploading user controls, please read this article.
View all posts from The Progress Team on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.
Learn MoreSubscribe to get all the news, info and tutorials you need to build better business apps and sites
Progress collects the Personal Information set out in our Privacy Policy and the Supplemental Privacy notice for residents of California and other US States and uses it for the purposes stated in that policy.
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.