使用linq to datset。
private void button10_Click(object sender, EventArgs e)
{
//初始化dataset
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("name");
DataRow r1 = dt.NewRow();
r1[0] = 1;
r1[1] = "财务总监";
DataRow r2 = dt.NewRow();
r2[0] = 2;
r2[1] = "会计";
DataRow r3 = dt.NewRow();
r3[0] = 3;
r3[1] = "出纳";
dt.Rows.Add(r1);
dt.Rows.Add(r2);
dt.Rows.Add(r3);
ds.Tables.Add(dt);
//end
string aa = "{" +
string.Join(
",",
ds.Tables[0].AsEnumerable()
.Select(x => string.Format("\"{0}\" : \"{1}\"", x["id"].ToString(), x["name"].ToString()))
.ToArray()
) + "}";
}
