Response title
This is preview!
$(
"#serverResponse").load("JSONCall.aspx");$.getJSON(
'JSONCall.aspx', function(data) { var items = [];$.each(data,
function(key, val) {items.push(
'<li id="' + key.ItemCode + '">' + val + '</li>');});
$(
'<ul/>', { 'class': 'my-new-list',html: items.join(
'')}).appendTo(
'body');});
<
div id="serverResponse"></div>{
Response.Cache.SetCacheability(
HttpCacheability.NoCache); // create sample datatable DataTable dtJSON = new DataTable(); // add test columns to tabledtJSON.Columns.Add(
"Index");dtJSON.Columns.Add(
"ItemCode");dtJSON.Columns.Add(
"Price"); // generate random data and add 10 records in temp table Random randomNo = new Random(); for (int i = 0; i < 10; i++){
dtJSON.Rows.Add(i
, generateRandomString(5) +
"-" + generateRandomString(5), randomNo.Next(99, 500));
}
// generate JSON string out of the temp datatable and write it in response of the pageResponse.Write(datatableToJSON(dtJSON));
Response.Expires = -1;
}
public static string generateRandomString(int length){
string randomString = Guid.NewGuid().ToString("N");randomString = randomString.Substring(0, length);
return randomString;}
public static string datatableToJSON(DataTable dt){
StringBuilder jsonStringBuilder = new StringBuilder(); StringWriter jsonStringWriter = new StringWriter(jsonStringBuilder); JsonWriter jsonWriter = new JsonTextWriter(jsonStringWriter); if (dt != null && dt.Rows.Count > 0){
jsonWriter.Formatting =
Formatting.None;jsonWriter.WriteStartArray();
for (int i = 0; i < dt.Rows.Count; i++){
jsonWriter.WriteStartObject();
for (int j = 0; j < dt.Columns.Count; j++){
jsonWriter.WritePropertyName(dt.Columns[j].ColumnName.ToString().ToLower());
jsonWriter.WriteValue(dt.Rows[i][j].ToString());
}
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
return jsonStringBuilder.ToString();}
else{
return null;}
© 2013 jQuery Foundation
Sponsored by and others.