3,服务器端的编写
1)传统的写法:返回xml
[WebMethod]
public DataSet getCookBook(int storeID)
{
try
{
conn.Open();
string selectnews = " select * from View_foodCooke where storeID='" + storeID + "'";
SqlDataAdapter Adapter = new SqlDataAdapter(selectnews, conn);
DataSet Ds = new DataSet();
Adapter.Fill(Ds);
conn.Close();
return Ds;
}
catch
{
return null;
}
}
2,放回xml+json——————需要引用(using Newtonsoft.Json)
public string getOnlineBookInfomation()
{
try
{
conn.Open();
string selectnews = " select * from onlineBook";
SqlDataAdapter Adapter = new SqlDataAdapter(selectnews, conn);
DataSet ds = new DataSet();
Adapter.Fill(ds);
conn.Close();
string str=null;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
List<Hashtable> testList = new List<Hashtable>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Hashtable ht = new Hashtable();
DataRow row = ds.Tables[0].Rows[i] as DataRow;
ht["id"] = Convert.ToString(row["bookid"]).Trim();
ht["type"] = Convert.ToString(row["booktype"]).Trim();
ht["bookdata"] = Convert.ToString(row["bookdata"]).Trim();
ht["bookname"] = Convert.ToString(row["bookname"]).Trim();
ht["indexpic"] = "http://iphone.demo.whnuke.com/fileUploadpdf/indexpic/" + Convert.ToString(row["bookindexpic"]).Trim();
ht["pdf"] = "http://iphone.demo.whnuke.com/fileUploadpdf/" + Convert.ToString(row["pdffile"]).Trim();
ht["bookinfomation"] = Convert.ToString(row["bookinfomation"]).Trim();
testList.Add(ht);
}
string json = JavaScriptConvert.SerializeObject(testList);
str += json;
}
return str;
}
catch
{
return null;
}
}
返回结果的形式是:<result>json string</result>
3,返回纯json数据
添加一个aspx和aspx.cs文件
aspx文件只留下以下代码:
<%@ Page Language="C#" AutoEventWireup="true" ValidateRequest="false" CodeFile="getjosndata.aspx.cs" Inherits="getjosndata" %>
aspx.cs里的方法
//获取www.test.com/getjosndata.aspx?id=[id] id的值
int cangguanID = Convert.ToInt32(Request.QueryString["ID"]);
protected void Eat_API_GetCanguanCaipu(int canguanID)
{
DataSet ds = new DataSet();
ds = Eat_API_Getinfomation("Eat_API_GetCanguanCaipu", canguanID);
string str = null;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
List<Hashtable> testList = new List<Hashtable>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Hashtable ht = new Hashtable();
DataRow row = ds.Tables[0].Rows[i] as DataRow;
ht["id"] = Convert.ToString(row["CaipuID"]).Trim();
ht["cx"] = Convert.ToString(row["CaixiTypeID"]).Trim();
ht["name"] = Convert.ToString(row["Mingcheng"]).Trim();
if (Convert.ToString(row["ImageURL"]).Trim() != "")
{
ht["imgurl"] = "http://caipu.demo.alldnnskins.cn/Portals/0/caipu/" + Convert.ToString(row["ImageURL"]).Trim();
}
else
{
ht["imgurl"] = "";
}
//ht["Summary"] = Convert.ToString(row["Summary"]).Trim();
ht["Price"] = Convert.ToString(row["Price"]).Trim();
//ht["FabuRen"] = Convert.ToString(row["FabuRen"]).Trim();
// ht["CreatedOn"] = Convert.ToString(row["CreatedOn"]).Trim();
// ht["ModifiedOn"] = Convert.ToString(row["ModifiedOn"]).Trim();
ht["IsApproved"] = Convert.ToString(row["IsApproved"]).Trim();
// ht["IsHidden"] = Convert.ToString(row["IsHidden"]).Trim();
// ht["IsFeatured"] = Convert.ToString(row["IsFeatured"]).Trim();
testList.Add(ht);
}
string json = JavaScriptConvert.SerializeObject(testList);
str += json;
}
Response.Write(str);
}
得到的结果是纯json结果