protected void GetList(int pageindex = 1, int incr = 10) { using (SampleDataContext db = new SampleDataContext()) { //db.students.Skip(pageindex * incr).Take(incr); var data = db.spindexWork(pageindex, incr); GridView1.DataSource = data; GridView1.DataBind(); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "application/json"; string page_in = context.Request.QueryString["page"]; if (page_in == null) { page_in = "1"; } if (isValidQuery(page_in, 20)) { using (SampleDataContext db = new SampleDataContext()) { int p = Convert.ToInt32(page_in); var students = db.spindexWork(p, 20); context.Response.Write(JsonConvert.SerializeObject(students)); } } else { context.Response.Write(JsonConvert.SerializeObject("null")); } }