此代码段从 C#中的“将数据表转换为JSON字符串”中,VB.NET可能会为您提供帮助。它使用System.Web.Script.Serialization.JavaScriptSerializer将内容序列化为JSON格式:
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();
List<Dictionary<string, object>> rows = new List<Dictionary<string, 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);
}
}
}