private void GetJsonForNoticeDatagrid(HttpContext context) { int totalRecords = 0; int pageIndex = 1; int pageSize = 10; int.TryParse(context.Request.QueryString["page"], out pageIndex); int.TryParse(context.Request.QueryString["rows"], out pageSize); string sqlWhere = string.Empty; SqlParameter parm = null; if (!string.IsNullOrEmpty(context.Request.QueryString["title"])) { sqlWhere = "and Title like @Title "; parm = new SqlParameter("@Title", SqlDbType.NVarChar, 100); parm.Value = "%" + context.Request.QueryString["title"].Trim() + "%"; } Notice bll = new Notice(); var list = bll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, parm); if (list == null || list.Count == 0) { context.Response.Write("{\"total\":0,\"rows\":[]}"); return; } StringBuilder sb = new StringBuilder(); foreach (var model in list) { sb.Append("{\"Id\":\"" + model.Id + "\",\"Title\":\"" + model.Title + "\"},"); } context.Response.Write("{\"total\":" + totalRecords + ",\"rows\":[" + sb.ToString().Trim(',') + "]}"); }