convert table to json

Sanjay gautam

6y843Learn iOS Programming

static public string table2Json(DataSet ds, int table_no)
{
try
{
// Given a Dataset & Table NO , function returns a 2 dim JSON Array of values in that table
int rcnt = ds.Tables[table_no].Rows.Count; // Row Count
int ccnt = ds.Tables[table_no].Columns.Count; // Col Count
object[][] tb = new object[rcnt][];
int r = 0;
foreach (DataRow dr in ds.Tables[table_no].Rows)
{
tb[r] = new object[ccnt];
for (int col = 0; col < ccnt; col++)
{
tb[r][col] = dr[col];
if ((tb[r][col]).Equals(System.DBNull.Value))
tb[r][col] = "";
}
r++;
}
var table= JsonConvert.SerializeObject(tb);
return table;
}

I have some code for convert table to json string i want to remove for loo from these code how does it is possible

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Try this code:
public string ConvertDataTabletoString()
{
    DataTable dt = new DataTable();
    using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Initial Catalog=master;Integrated Security=true"))
    {
        using (SqlCommand cmd = new SqlCommand("select title=City,lat=latitude,lng=longitude,description from LocationDetails", con))
        {
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
            Liststring, object>> rows = new Liststring, object>>();
            Dictionary<string, object> row;
            foreach (DataRow dr in dt.Rows)
            {
                row = new Dictionary<string, object>();
                foreach (DataColumn col in dt.Columns)
                {
                    row.Add(col.ColumnName, dr[col]);
                }
                rows.Add(row);
            }
            return serializer.Serialize(rows);
        }
    }
}
Amit Mohanty6y ago
Then try this
public static object DataSetToJSON(DataSet ds)
{
    ArrayList root = new ArrayList();
    Liststring, object>> table;
    Dictionary<string, object> data;

    foreach (DataTable dt in ds.Tables)
    {
        table = new Liststring, object>>();
        foreach (DataRow dr in dt.Rows)
        {
            data = new Dictionary<string, object>();
            foreach (DataColumn col in dt.Columns)
            {
                data.Add(col.ColumnName, dr[col]);
            }
            table.Add(data);
        }
        root.Add(table);
    }
    JavaScriptSerializer serializer = new JavaScriptSerializer
    {
        MaxJsonLength = Int32.MaxValue
    };
    return serializer.Serialize(root);
}
Sanjay gautam6y ago
hi Amit Mohanty sir this is not perfect salution. I have data set which contain number of table and table no also
Amit Mohanty6y ago
Hey try this
public static object DataTableToJSON(DataTable table)
{
    var list = new Liststring, object>>();
    foreach (DataRow row in table.Rows)
    {
        var dict = new Dictionary<string, object>();
        foreach (DataColumn col in table.Columns)
        {
            dict[col.ColumnName] = (Convert.ToString(row[col]));
        }
        list.Add(dict);
    }
    JavaScriptSerializer serializer = new JavaScriptSerializer
    {
        MaxJsonLength = Int32.MaxValue
    };
    return serializer.Serialize(list);
}