C# 序列化json,以及前端解析json
此方法用于把对象序列化成Json格式的数据
protected void Page_Load(object sender, EventArgs e)
{
string strcon = "Data Source=.;Initial Catalog=Test2;User ID=sa;pwd=sasa";
string sql = "select OperatorID,OperatorName from tblOperator";
DataTable dt = new DataTable();
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, strcon))
{
adapter.Fill(dt);
}
JavaScriptSerializer serialize = new JavaScriptSerializer();
List<Dictionary<string, string>> list =new List<Dictionary<string,string>>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Dictionary<string, string> dir = new Dictionary<string, string>();
dir.Add(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString());
list.Add(dir);
}
string str = serialize.Serialize(list);
Response.Write(str);
Response.End();
}
此段代码是前端解析Json格式的数据
<script src="script/jquery-1.7.2.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$.ajax({
type: 'get',
url: 'Josn.aspx',
success: function(msg) {
var jsons = eval("(" + msg + ")");
for (var i = 0; i < jsons.length; i++) {
for (var key in jsons[i]) {
var option = new Option(jsons[i][key], key);
$("#sel")[0].options.add(option);
}
}
}
});
});
</script>
</head>
<body>
姓名:
<select id="sel" name="D1">
<option value="1">Hello</option>
</select>
</body>
</html>