BoldSignA modern eSignature application with affordable pricing. Sign up today for unlimited document usage!
public ActionResult DataSource(Syncfusion.JavaScript.DataManager dm)
{
using (SqlConnection cn = new SqlConnection(connectionStr))
{
cn.Open();
//Getting the records based on skip and top value.
SqlCommand cmd = new SqlCommand("SELECT OrderID,CustomerID,EmployeeID,Freight,OrderDate FROM Orders", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
dt = (DataTable)ds.Tables[0];
. . . . .
}
var order = (from DataRow row in dt.Rows
select new Order
{
OrderID = Convert.ToInt32(row["OrderID"]),
CustomerID = row["CustomerID"].ToString(),
Freight = Convert.ToDecimal(row["Freight"]),
EmployeeID = Convert.ToInt32(row["EmployeeID"]),
OrderDate = Convert.ToDateTime(row["OrderDate"])
}).Skip(dm.Skip).Take(dm.Take).ToList();
return Json(new { result = order, count = count }, JsonRequestBehavior.AllowGet);
} |