1.添加引用:
using Newtonsoft.Json;
2.序列化:
[WebMethod(Description = "票号查询")] public String GetID(string ticketcode) { try { List<SDTI_TicketList> list= db.GetTicketID(ticketcode).ToList(); string strSerializeJSON = JsonConvert.SerializeObject(list); return strSerializeJSON; } catch (Exception e) { throw; } }
3.Test
但是此方法本质还是Xml,下面是另一种方法
先看接口方法
[WebMethod] public void HelloWorld() { SqlConnection conn = DBConnection.Connection_DB(); //数据库连接实例化 conn.Open(); if (conn.State == ConnectionState.Open) { string SqlStr = "select * from Province"; SqlCommand cmd = new SqlCommand(SqlStr, conn); SqlDataReader sqlDataReader = cmd.ExecuteReader(); List<ProvinceFormatEntity> s = new List<ProvinceFormatEntity>(); while (sqlDataReader.Read()) { ProvinceFormatEntity provinceFormatEntity = new ProvinceFormatEntity { ID = sqlDataReader[0].ToString(), Name = sqlDataReader[1].ToString(), }; s.Add(provinceFormatEntity); } string jsonStudents = JsonConvert.SerializeObject(s); //Json序列化 Context.Response.ContentType = "text/json"; //指定格式 Context.Response.Write(jsonStudents); Context.Response.End(); } else { // return null; } }
再看Json序列化的实体类
public class ProvinceFormatEntity { public string ID { get; set; } public string Name { get; set; } }