Hello everyone ,

So , i was performing manual paging but i passed skip and top parameter and using stored procedure returning the records.But its only showing page 1 and top records specified next and previous page options are disabled. Could you please help me and let me know what i am doing wrong?

Code:

dataSourceUrl: "/Student/Data12",
dataSource: "/Student/Data",
responseDataKey: "Records",


features: [
{
name: "Selection",
mode: "row",
multipleSelection: true
},
{
name: "RowSelectors",
enableCheckBoxes: true,
enableRowNumbering: true
},
{
name: "GroupBy"
},
{
name :"Paging",
type:"remote",
pageSize: 7,
visiblePageCount:5,
recordCountKey: "TotalRecordsCount"
},

CONTROLLER:

public IActionResult Index()
{

var absolutepath1 = Request.QueryString.Value;

Console.WriteLine(absolutepath1);
return View();
}

public JsonResult Data()
{

// var absolutepath = HttpUtility.ParseQueryString(HttpContext.Request.QueryString.ToString()) ;
var absolutepath1 = Request.QueryString.Value;
NameValueCollection parse1 = HttpUtility.ParseQueryString(absolutepath1);
int skip = Convert.ToInt32(parse1["$skip"]);//number of rows to skip
int top =Convert.ToInt32(parse1["$top"]);// entries to be displayed
Console.WriteLine(skip.GetType());
if(skip!=null && top != null){
IEnumerable<Student> s = data.paging(top, skip);
return Json(s);
}

//to check query string parameter for paging

//Console.WriteLine(parse1 +"hi");
//foreach(string keys in parse1.Keys)
//{
// Console.WriteLine(keys + ":" + parse1[keys]);
//}

// dynamic p = Request.GetDisplayUrl();

// Console.WriteLine(absolutepath);

IEnumerable<Student> students = data.GetStudents();

return Json(students);

}

//UPDATE URL OR SORTING AND OTHER OPERATIONS
public JsonResult Data12()
{

var absolutepath1 = Request.QueryString.Value;
{
var absolutepath12 = Request.QueryString.Value;
NameValueCollection parse1 = HttpUtility.ParseQueryString(absolutepath12);
Console.WriteLine(parse1 + "hi");
foreach (string keys in parse1.Keys)
{
Console.WriteLine(keys + ":" + parse1[keys]);
}
}
var absolutepath = HttpContext.Request.Query["$orderby"].ToString();
Console.WriteLine(absolutepath1);
Console.WriteLine();
// string? a= HttpUtility.UrlDecode(absolutepath1);
// NameValueCollection parameters = System.Web.HttpUtility.ParseQueryString(a);
string filter = ApplyFilterExpr(absolutepath1);
Console.WriteLine("filter" + " " + filter);

IEnumerable<Student> sat= data.filter(filter);

if (absolutepath!="")
{
// Code inside the if block
string[] m = absolutepath.Split(' ');
Console.WriteLine("hi");

var colname = m[0]; // to get col name

var orderb1y = m[1];// top get orderby

sat = data.sort(colname, orderb1y);
}

// sat is not accessible here outside the if block
return Json(sat);

}

So , then data method runs when the grid is loaded first time and when you make any changes like manual sorting or filtering etc the method specified in the datasourceurl runs i.r data12() method.