ashx c# 输出多个json 数组

Question

  connection = new MySqlConnection(connectionString);
                MySqlCommand myCommand = new MySqlCommand();
                myCommand.Connection = connection;
                myCommand.CommandType = System.Data.CommandType.Text;
                string sql = "select DISTINCT package_category from all_shop where shopname =?shopname and package_category !=''";
                myCommand.CommandText = sql;
                myCommand.Parameters.Add(new MySqlParameter("shopname", MySqlDbType.VarChar, 255)).Value = shopname;
                MySqlDataReader myReader = null;
                connection.Open();
                myReader = myCommand.ExecuteReader();                System.Collections.ArrayList people = new System.Collections.ArrayList();                while (myReader.Read())
                {
                    Person p1 = new Person();
                    p1.package_category = myReader["package_category"].ToString();
                    people.Add(p1);
                }                connection.Close();
                Person[] ps = (Person[])people.ToArray(typeof(Person));
                context.Response.ContentType = "text/plain";
                System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
                string json = jss.Serialize(ps);//json 
                context.Response.Write(json);想输出2个数组(sql select 不一样) , 但目前只会写一个的，愿好心人帮帮忙，给个简单例子，教导教导 ！ 感恩！

Answer 1

两个求组？哪两个？如果结构一样直接合成一个数组，如果结构不一样，拼成大的字符串给前台来处理不同的json数组。

Answer 2

  connection = new MySqlConnection(connectionString);
            MySqlCommand myCommand = new MySqlCommand();
            myCommand.Connection = connection;
            myCommand.CommandType = System.Data.CommandType.Text;
            string sql = "select DISTINCT package_category from all_shop where shopname =?shopname and package_category !=''";
            myCommand.CommandText = sql;
            myCommand.Parameters.Add(new MySqlParameter("shopname", MySqlDbType.VarChar, 255)).Value = "pkcyber";
            MySqlDataReader myReader = null;
            connection.Open();
            myReader = myCommand.ExecuteReader();            System.Collections.ArrayList people = new System.Collections.ArrayList();            while (myReader.Read())
            {
                Person p1 = new Person();
                p1.package_category = myReader["package_category"].ToString();
                people.Add(p1);
            }
            myReader.Close();
            Person[] ps = (Person[])people.ToArray(typeof(Person));
            System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
            string json = jss.Serialize(ps);            sql = "select package_title,package_title2,package_discount,package_discount_price,admin_package_discount_price,admin_package_image1 "
                + "from all_shop where shopname =?shopname and admin_package_image_display='true' and package_category=?package_category";
            myCommand.CommandText = sql;
            myCommand.Parameters.Clear();
            myCommand.Parameters.Add(new MySqlParameter("shopname", MySqlDbType.VarChar, 255)).Value = "pkcyber";
            myCommand.Parameters.Add(new MySqlParameter("package_category", MySqlDbType.VarChar, 255)).Value = "sofa";
            myReader = myCommand.ExecuteReader();            people = new System.Collections.ArrayList();            while (myReader.Read())
            {
                Person p1 = new Person();
                p1.package_category = myReader["package_title"].ToString();
                people.Add(p1);
            }
            myReader.Close();
            ps = (Person[])people.ToArray(typeof(Person));
            jss = new System.Web.Script.Serialization.JavaScriptSerializer();
            json = json + "??" + jss.Serialize(ps);
            connection.Close();            context.Response.ContentType = "text/plain";
            context.Response.Write(json);前台就:
.done(function(data) {
                 var ttc = data.split('??');
                 var value = $.parseJSON(ttc[0]);
                 var value2 = $.parseJSON(ttc[1]);自己想的 ，感觉好像哪里不太对... 
问 : 假设结构一样的话，接合成一个数组? 

Answer 3

JSON本身就是可以描述成类似数组那样的，你在JSON里多一个分组不就行了吗？

Answer 4

先分别得到JSON然后
json= string.Format("[{0},{1}]",json1,json2);

Answer 5

以数组的样式var jsonstr = "[{name:'fish',age:18},{address:'china'}]";
var arrobject = eval('('+jsonstr+')');
console.log(arrobject[1].address);输出:china