WebServices返回Json数据

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; }
    }

这样就很简单了

 

转载于:https://www.cnblogs.com/xinyibufang/p/7344571.html