110,567
社区成员
发帖
与我相关
我的任务
分享
public DataTable GetExcelConnect(string p_dataPath,string p_Filename)
{
try
{
string path = @"E:\Documents and Settings\Administrator\桌面\DQUOT20120224\DQUOT\bin\Debug\";
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Text;HDR=Yes;FMT=Delimited\"";
OleDbConnection myConnect = new OleDbConnection(strCon);
if (myConnect.State == ConnectionState.Closed)
{
myConnect.Open();
}
string strCommand = "select * from 17.txt";
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCommand, myConnect);
DataSet myDataSet = new DataSet();
DataTable dataTable = new DataTable();
myCommand.Fill(dataTable);
if (myConnect.State == ConnectionState.Open)
{
myConnect.Close();
}
return dataTable;
}
catch (Exception ex)
{
return null;
}
}