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

thanks

Anish17y ago

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

}

Here: