OleDbConnection conn = new OleDbConnection("Provider= Microsoft.ACE.OLEDB.12.0;Data Source=D:/Raj Collection For ASP Examples/Raj Practise Examples/Excel InsertData/Test3.xls; Extended Properties=\"Excel 12.0;HDR=YES;\"");
conn.Open();
string s = "Select * from [Sheet1$]";
OleDbCommand cmd = new OleDbCommand(s, conn);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
conn.Close();
No comments:
Post a Comment