为何.net中连接Accessdb的时候,webservice返回dataset的时候,不能获取数据
为何.net中连接Accessdb的时候,webservice返回dataset的时候,不能获取数据
是直接在Server Explore中拖出來的connection, adaptor, 但是不能返回正確的dataset
可以改用語句寫的則可以看到
string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\tt\\ServiceData.mdb";
OleDbConnection myAccessConn = new OleDbConnection(strAccessConn);
OleDbCommand myAccessCommand = new OleDbCommand("select * from Customers",myAccessConn);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);
myAccessConn.Open();
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet);
myAccessConn.Close();
return myDataSet;
是直接在Server Explore中拖出來的connection, adaptor, 但是不能返回正確的dataset
可以改用語句寫的則可以看到
string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\tt\\ServiceData.mdb";
OleDbConnection myAccessConn = new OleDbConnection(strAccessConn);
OleDbCommand myAccessCommand = new OleDbCommand("select * from Customers",myAccessConn);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);
myAccessConn.Open();
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet);
myAccessConn.Close();
return myDataSet;
浙公网安备 33010602011771号