本地客户端读取WebService中的DataSet

WebSevice层代码：

??? [WebMethod]
??? public DataSet GetDataSet()
??? {
??????? string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/testdata.mdb");
??????? string selstr = "Select space_single from [user] Where [userID]=" + "2" + "";
??????? DataSet ds = new DataSet();
??????? OleDbConnection objConn = new OleDbConnection(connstr);
??????? OleDbDataAdapter adap = new OleDbDataAdapter(selstr,objConn);
??????? adap.Fill(ds,selstr);
??????? return ds;
??? }

注：connstr为连接Access数据库地址，selstr为查询的SQL的字符串。此两项可根据情况修改。

客户端代码:

??????? public Form1()
??????? {
??????????? InitializeComponent();
??????????? WindowsFormsApplication1.datatest.datatest ss = new WindowsFormsApplication1.datatest.datatest();
??????????? DataSet ds = ss.GetDataSet();
??????????? dataGridView1.DataSource=ds.Tables[0];

??????? }

注：1、使用该代码前，需要先添加WEB应用，这里将引用命名为：datatest

??? 2、WindowsFormsApplication1为该方案的解决方案名，Form1为当前的窗体名