Fetch data from Excel
The below code explains how you can fetch data from EXcel to a data adapter . Here I have used a OLEDB Connection
public void GetExcelData(string strFilename)
{
try
{
dataset dsExcelData;
dsExcelData.Clear();
string sCurrentSheet = "[Sheet1$]";
string strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sFilename + ";Extended Properties='Excel 8.0;HDR=Yes'";
OleDbConnection oConnection = new OleDbConnection(strConnectionString);
oConnection.Open();
OleDbCommand oCommand = new OleDbCommand("Select [MAKE BOX], [L],[W],[D],[ID],[SEQ],[PART],[PARTDESCRIPTION] from " + sCurrentSheet, oConnection);
OleDbDataAdapter oDataAdapter = new OleDbDataAdapter(oCommand);
oDataAdapter.Fill(dsExcelData);// dataset
oConnection.Close();
}
catch (Exception)
{
}
}
// binding to a datagridview control
BindingSource bsDataBind = new BindingSource();
bsDataBind.DataSource = dsExcelData;
datagridview1.DataSource = bsDataBind;
or you can directly bind
datagridview1.datasourse= dsExcelData;
Nice code but OLEDB is slow. Try using GemBox . It's much faster then OLEDB and easier to use.