Hi,
See the solution, which will read excel data and bind to the datagrid
DataSet objDataSet = new DataSet();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ Server.MapPath(".") + "\\wk16.xls;" + "Extended Properties='Excel 8.0;'";
OledbDataAdapter objDataAdapter = new OledbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
objDataAdapter.Fill(objDataSet);
DataGrid1.DataSource = objDataSet.Tables[0].DefaultView;
DataGrid1.DataBind();
Thanks!!!