Tuesday, January 15, 2013
Convert Data Table to JSON string
public string getTableJson(DataTable dt, string MethodName)
{
if (dt != null && dt.Rows.Count > 0)
{
Dictionary<string, string>[] MyJson = new Dictionary<string, string>[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
MyJson[i] = new Dictionary<string, string>();
for (int j = 0; j < dt.Columns.Count; j++)
{
MyJson[i].Add(dt.Columns[j].ColumnName, dt.Rows[i][j].ToString());
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
return "{\"status\":{\"status\":\"1\",\"message\":\"success\"},\"" + MethodName + "\":" + js.Serialize(MyJson) + "}";
}
else
{
return "{\"status\":{\"status\":\"0\",\"message\":\"Not Success\"},\"" + MethodName + "\":[{\"Msg\":\"No Data Found\"}]}";
}
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment