Htykuut

On page load view is sending a get request to controller and based on default values for textbox studentsIdFrom(1) and studentsIDTo(30) webgrid is showing data of 10 students. Then based on filteration Let's say user filled value for textboxes studentsIdFrom(15) and studentsIDTo(55) and then user click on go button then a post request is sent to controller and data is shown with paging (10 students data per page) . But when I click on page 2 it shows data that is in 2nd page of default data. It means it is sending a get request to controller.

My Controller

using StudentData.Models;

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using Dapper;



namespace StudentData.Controllers

{

    public class StudentController : Controller

    {

        // GET: Student

        [HttpGet]

        public ActionResult Index()

        {

            int idFrom = 1;

            int idTo = 30;



            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["StudentData"].ConnectionString))

            {

                conn.Open();

                string sqlQuery = "Select * From Student WHERE Id >= @idFrom and Id <= @idTo";

                var resultSet = conn.Query<Student>(sqlQuery).ToList();

                return View(resultSet);

            }

        }



        [HttpPost]

        public ActionResult Index(int idFrom, int idTo)

        {

            using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["StudentData"].ConnectionString))

            {

                string sqlQuery = "Select * From Student WHERE Id >= @idFrom and Id <= @idTo ;";

                var resultSet = db.Query<Student>(sqlQuery).ToList();

                return View(resultSet);

            }

        }

    }

}

My View

@model IEnumerable<StudentData.Models.Student>



@using (Ajax.BeginForm("Index", "Student", new AjaxOptions { HttpMethod = "POST" }))

{

    <table>

        <tr>

            <td>ID(s):&nbsp;&nbsp;</td>

            <td>

                From:<input type="number" id="idFrom" name="idFrom" />



                &nbsp;&nbsp;To:<input type="number" id="idTo" name="idTo" />

            </td>

            <td>

                <a href="#">Clear</a>

            </td>

        <tr>

            <td align="right">

                <input type="submit" value="Go" />

            </td>

        </tr>

    </table>



}



<b>@Model.Count()</b>



@{

    Layout = null;

    WebGrid grid = new WebGrid(source: Model, canSort: true, canPage: true, rowsPerPage: 10);

    grid.Pager(WebGridPagerModes.All);



    @grid.GetHtml(htmlAttributes: new { id = "grid" },

            headerStyle: "webgrid-header",

            columns: new

            {

                grid.Column( "ID" , "ID"  , canSort:true ),

                grid.Column( "Name" , "Name"  , canSort:true ),

                grid.Column( "DOB" , "DOB"  , canSort:true ),

                grid.Column( "Dept" , "Dept"  , canSort:true )

            }

            )



}

My Model

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;



namespace StudentData.Models

{

    public class Student

    {

        public int ID { get; set; }

        public string Name { get; set; }

        public DateTime DOB { get; set; }

        public string Dept { get; set; }

    }

}

On Page Load it's showing data of first 10 students with 3 page symbol(1 2 3) at bottom. when i click on page 2 it shows data of students from id 11 to 20. Now i fill the values for textboxes idFrom(15) and idTo(60) and click on Go button. Now its shows data from students id 15 to 24 with 5 page symbols(1 2 3 4 5 ) at bottom and when i click on page 2 it shows data of id from 11 to 20. but i want data of id from 25 to 34 on this click.