6,721
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 把DataTable转化成json字符串
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public string DataTableToJson(DataTable dt, string TableName)
{
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
using (JsonWriter jw = new JsonTextWriter(sw))
{
JsonSerializer ser = new JsonSerializer();
jw.WriteStartObject();
jw.WritePropertyName(TableName);
jw.WriteStartArray();
foreach (DataRow dr in dt.Rows)
{
jw.WriteStartObject();
foreach (DataColumn dc in dt.Columns)
{
jw.WritePropertyName(dc.ColumnName);
ser.Serialize(jw, dr[dc].ToString());
}
jw.WriteEndObject();
}
jw.WriteEndArray();
jw.WriteEndObject();
sw.Close();
jw.Close();
}
return sb.ToString();
}
public string Points
{
get
{
DataSet ds = null;//假如这是你从数据库里查出来的数据,这里不去查了,让他等于null
string json = DataTableToJson(ds.Tables[0],"Points");
return "JSON.parse('" + json + "')[\"Points\"];";
}
}
<script type="text/jscript">
var points = <%=Points %> // 这就是你想要的坐标,你可以拿着他去画折线了
</script>