Showing posts with label Display data in GridView from Excel Sheet. Show all posts
Showing posts with label Display data in GridView from Excel Sheet. Show all posts

Wednesday, May 6, 2009

Display data in GridView from Excel Sheet

OleDbConnection DBConnection = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=...;" + "Extended
Properties=\"Excel 8.0;HDR=Yes\"");
DBConnection.Open();
string SQLString = "SELECT * FROM [Sheet1$]";
OleDbCommand DBCommand = new OleDbCommand(SQLString, DBConnection);
IDataReader DBReader = DBCommand.ExecuteReader();
GridView1.DataSource = DBReader;
GridView1.DataBind();
DBReader.Close();
DBConnection.Close();
 
Locations of visitors to this page