//下载Newtonsoft.Json.dll文件并引用
//webserver调用端代码(C#窗体)
//要增加:using Newtonsoft.Json.Linq;
private void button1_Click(object sender, EventArgs e)
{
ServiceReference1.WebServiceSoapClient client = new ServiceReference1.WebServiceSoapClient();
string jsonstring = client.getdata("李明").ToString();//查找姓名为李明的相关记录数据
JObject json = JObject.Parse(jsonstring);
string xm = json["年龄"].ToString(); //获取李明的年龄
}
//webserver服务端代码(C#.NET)
//要增加:using Newtonsoft.Json;
[WebMethod]
public string getdata(string scbh)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
ds = ExecuteDataSet("select 姓名,年龄,籍惯,工龄 from 用户表 where 姓名='" + xm + "' ");
dt = ds.Tables[0];
var abcObject = new
{
姓名 = dt.Rows[0][0].ToString(),
年龄 = dt.Rows[0][1].ToString(),
籍惯 = dt.Rows[0][2].ToString(),
工龄 = dt.Rows[0][3].ToString()
};
string serJson = JsonConvert.SerializeObject(abcObject);
return serJson;
}