سلام،
این لینک: http://www.codeproject.com/KB/databa...l_and_SQL.aspx
کد:
privatevoid button1_Click(object sender, EventArgs e)
{
DataTable test = getDataFromXLS("c:\temp.xls");
if (test != null)
dataGridView1.DataSource = test;
}
privateDataTable getDataFromXLS(string strFilePath)
{
try
{
string strConnectionString = "";
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strFilePath + "; Jet OLEDB:Engine Type=5;" +
"Extended Properties=Excel 8.0;";
OleDbConnection cnCSV = newOleDbConnection(strConnectionString);
cnCSV.Open();
OleDbCommand cmdSelect = newOleDbCommand(@"SELECT * FROM [Sheet1$]", cnCSV);
OleDbDataAdapter daCSV = newOleDbDataAdapter(); daCSV.SelectCommand = cmdSelect;
DataTable dtCSV = newDataTable();
daCSV.Fill(dtCSV);
cnCSV.Close();
daCSV = null;
return dtCSV;
}
catch (Exception ex)
{
returnnull;
}
finally { }
}
مراقب باش که تو strFilePath هر \ باید \\ باشه.