服务器json数据代码protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = DataBD().Tables[0];
Response.Write(DataTableToJSON(dt));
}
//将datatable数据转换成JSON数据
public string DataTableToJSON(DataTable table)
{
StringBuilder json = new StringBuilder();
json.Append("[");
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i]; // json object
json.Append("{");
for (int j = 0; j < table.Columns.Count; j++)
{
string columnName = table.Columns[j].ColumnName;
string columnType = table.Columns[j].DataType.Name; // json field
if (columnType == "Int32" || columnType == "Int16" || columnType == "Decimal")
{
// don't surround numbers with quotes
json.AppendFormat("\"{0}\":\"{1}\"", columnName, row.IsNull(columnName) ? "" : row[columnName]);
}
else if (columnType == "Boolean")
{
// make the bool value lowercase
json.AppendFormat("\"{0}\":{1}", columnName, row.IsNull(columnName) ? "" : row[columnName].ToString().ToLower());
}
else
{
// everything else gets quotes around the data
json.AppendFormat("\"{0}\":\"{1}\"", columnName, row[columnName]);
} if (j < table.Columns.Count - 1) json.Append(","); // add comma if not last column
}
json.Append("}"); if (i < table.Rows.Count - 1) json.Append(","); // add comma if not last row
}
json.Append("]");
return json.ToString();
}我用ajax从服务器获获取到数据,请问该怎么把数据转换成如:
var datas=[['1/1/2006', 2], ['2/1/2006', 6], ['3/1/2006', 4], ['4/1/2006', 3]]的格式???
{
DataTable dt = DataBD().Tables[0];
Response.Write(DataTableToJSON(dt));
}
//将datatable数据转换成JSON数据
public string DataTableToJSON(DataTable table)
{
StringBuilder json = new StringBuilder();
json.Append("[");
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i]; // json object
json.Append("{");
for (int j = 0; j < table.Columns.Count; j++)
{
string columnName = table.Columns[j].ColumnName;
string columnType = table.Columns[j].DataType.Name; // json field
if (columnType == "Int32" || columnType == "Int16" || columnType == "Decimal")
{
// don't surround numbers with quotes
json.AppendFormat("\"{0}\":\"{1}\"", columnName, row.IsNull(columnName) ? "" : row[columnName]);
}
else if (columnType == "Boolean")
{
// make the bool value lowercase
json.AppendFormat("\"{0}\":{1}", columnName, row.IsNull(columnName) ? "" : row[columnName].ToString().ToLower());
}
else
{
// everything else gets quotes around the data
json.AppendFormat("\"{0}\":\"{1}\"", columnName, row[columnName]);
} if (j < table.Columns.Count - 1) json.Append(","); // add comma if not last column
}
json.Append("}"); if (i < table.Rows.Count - 1) json.Append(","); // add comma if not last row
}
json.Append("]");
return json.ToString();
}我用ajax从服务器获获取到数据,请问该怎么把数据转换成如:
var datas=[['1/1/2006', 2], ['2/1/2006', 6], ['3/1/2006', 4], ['4/1/2006', 3]]的格式???
再补充下:我用了一个图表插件,它需要这样格式的的数据。我从服务器获取过来的数据把它转换成json格式,但还是不行,报个参数错误。一定要像var datas=[['1/1/2006', 2], ['2/1/2006', 6], ['3/1/2006', 4], ['4/1/2006', 3]]格式的数据才行