//filepath是Excel的路径
#region 上传时的数据DataSet绑定:
protected DataSet DSBind(string filePath)
{
String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties=Excel 8.0;";
//Create connection object by using the preceding connection string.
OleDbConnection objConn = new OleDbConnection(ConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
DataSet objds = new DataSet();
objAdapter1.Fill(objds, "feeBudget");
return objds;
objConn.Close();
}
#endregion
Excel导入Dataset
最新推荐文章于 2024-07-22 09:01:45 发布