how to view the excel sheet data in Grid before save in database

Question

hi frds how to view the excel sheet data before save in database in Grid I have to Import a excel sheet and before save in database wants to view its data into a Grid...plz tell me how can I do this... ASAP

lovely neha · Answer

thanks

Anish · Answer

string strConn; strConn = Provider=Microsoft.Jet.OLEDB.4.0; + Data Source= + filename(with full path) + ; + Extended Properties=Excel 8.0; ; //Specify the connection string //You must use the $ after the object you reference in the spreadsheet OleDbDataAdapter myCommand = new OleDbDataAdapter( SELECT * FROM [Sheet1$]  strConn); DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet ExcelInfo ); // Fill the dataset GirdView1.DataSource = myDataSet.Tables[ ExcelInfo ].DefaultView; //set gridview datasource GridView1.DataBind(); //bind gridview foreach (DataRow dr in myDataSet.Tables[0].Rows) // loop through the dataset.datatable { loop through the DataTable and fill the Database }

Mahesh Chand · Answer

Here: Import data from Excel to Access using ADO.net