Remove Column name from array in JSON

Viewed 4000

I am getting format like this in an array here is my array=

  var array= [{"address":"Jaipur"},{"address":"Mumbai"},{"address":"Mumbai"}]

I want format like this

var array= [

    "Jaipur",
    "Mumbai"
];

what things should be done to in JSON so i can get desired array.

5 Answers
 string json = DataTableToJSON(dt_main); 
 jsonnew = @"{""Data"":" + json + "}";



private static string DataTableToJSON(DataTable table)
{

    List<string[]> result = table.Rows
 .Cast<DataRow>()
 .Select(row => row.ItemArray
     .Select(x => x.ToString())
     .ToArray())
 .ToList();

    JavaScriptSerializer serializer = new JavaScriptSerializer();
    return serializer.Serialize(result);

    //------another method----------------
    //ArrayList arr = new ArrayList(); 
    //List<ArrayList> list = new List<ArrayList>();

    //foreach (DataRow row in table.Rows)
    //{ 
    //    arr = new ArrayList();
    //    foreach (DataColumn col in table.Columns)
    //    { 
    //       arr.Insert(col.Ordinal, row[col]);
    //    }

    //     list.Add(arr); 
    //} 

   // JavaScriptSerializer serializer = new JavaScriptSerializer();
   // return serializer.Serialize(list);

}
Related