62,046
社区成员
发帖
与我相关
我的任务
分享
protected DataSet createDataSource(string path)
{
string strCon = String.Empty;
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=No;IMEX=1';";
OleDbConnection olecon = new OleDbConnection(strCon);
string strSel = "select * from [Report1$]";
olecon.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strSel,olecon);
DataSet myds = new DataSet();
myCommand.Fill(myds);
olecon.Close();
return myds;
}
try
{
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR=No;IMEX=1'";
System.Data.OleDb.OleDbConnection myConn = new System.Data.OleDb.OleDbConnection(strCon);
string strCom = "SELECT * FROM [" + dbName + "$]";
myConn.Open();
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, myConn);
//创建一个DataSet对象
DataSet myDataSet = new DataSet();
//得到自己的DataSet对象
myCommand.Fill(myDataSet);
//关闭此数据链接
myConn.Close();
return myDataSet;
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.ToString() + "')</script>");
}