返回的Json数据在前台可EVAL解析成对象
public DataTable GetAllAdvertisementStatics()
{
string mSql = "SELECT AdvertisementName,Statics FROM siteserver_Advertisement";
//连接数据库
SqlConnection _conn = new SqlConnection(BaiRongDataProvider.ConnectionString);
_conn.Open();
//查询后存入DataTable
DataTable dt = new DataTable("result");
SqlCommand mySqlDataSetCmd = new SqlCommand(mSql, _conn);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = mySqlDataSetCmd;
adapter.Fill(dt);
//返回DataTable
if (dt.Rows.Count == 0)
{
return null;
}
else
{
return dt;
}
}
//DataTable 2 Json
public string ToJson(DataTable dt, string jsonName)
{
StringBuilder Json = new StringBuilder();
Json.Append("{'" + jsonName + "':[");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Json.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
Json.Append("'" + dt.Columns[j].ColumnName.ToString() + "':'" + dt.Rows[i][j].ToString() + "'");
if (j < dt.Columns.Count - 1)
{
Json.Append(",");
}
}
Json.Append("}");
if (i < dt.Rows.Count - 1)
{
Json.Append(",");
}
}
}
Json.Append("]}");
return Json.ToString();
}