62,266
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
programmeraaron 2004-09-08
- 打赏
- 举报
运行上面的代码，是不是服务器端要装什么软件阿？
我在服务器上出现的错误是 连接不能打开，未知的错误
我在服务器上出现的错误是 连接不能打开，未知的错误
evans00220405 2004-09-07
- 打赏
- 举报
//获取excel表中的用户数据
DataSet myDataset = new DataSet();
string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='"+ path +"';Extended Properties=Excel 8.0;";
OleDbConnection myOleDbConnection = new OleDbConnection(connectionstring);
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM [Sheet1$]",myOleDbConnection);
OleDbDataAdapter myData = new OleDbDataAdapter(myOleDbCommand);
myData.Fill(myDataset);
DataSet myDataset = new DataSet();
string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='"+ path +"';Extended Properties=Excel 8.0;";
OleDbConnection myOleDbConnection = new OleDbConnection(connectionstring);
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM [Sheet1$]",myOleDbConnection);
OleDbDataAdapter myData = new OleDbDataAdapter(myOleDbCommand);
myData.Fill(myDataset);
