How to perform custom paging with stored procedure on Grid in .NET MVC application?

@(Html.EJ().Grid<object>("Editing")

        .Datasource(ds=> ds.URL("DataSource").Adaptor(AdaptorType.UrlAdaptor))

        .AllowPaging()

        .PageSettings(p=> p.PageSize(10).CurrentPage(3))

        .Columns(col =>

        {

            col.Field("OrderID").Add();

            col.Field("CustomerID").Add();

            col.Field("Freight").Add();

            col.Field("EmployeeID").Add();

        })

)

CREATE PROCEDURE [dbo].[CustomPaging]

                @SkipCount int,

                @PageSize int,

                @TotalRows int output

AS

BEGIN

SET NOCOUNT ON;

                SELECT @TotalRows = COUNT(*)

    FROM Orders

                SELECT * FROM Orders ORDER BY OrderID OFFSET (@SkipCount) ROWS FETCH NEXT @PageSize ROWS ONLY

END

RETURN 0

public ActionResult DataSource(DataManager dm)

        {

            DataOperations operation = new DataOperations();

            int count;

            DataTable dt = new DataTable("Order");

            string constring = ConfigurationManager.ConnectionStrings["NORTHWNDConnectionString"].ConnectionString;

            using (SqlConnection con = new SqlConnection(constring))

            {

                using (SqlCommand cmd = new SqlCommand("CustomPaging", con))

                {

                    cmd.CommandType = CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@SkipCount", dm.Skip);

                    cmd.Parameters.AddWithValue("@PageSize", dm.Take);

                    cmd.Parameters.Add("@TotalRows", SqlDbType.Int, 4);

                    cmd.Parameters["@TotalRows"].Direction = ParameterDirection.Output;

                    con.Open();

                    SqlDataReader dr = cmd.ExecuteReader();

                    dt.Load(dr); // Load into the dataTable

                    dr.Close();

                    con.Close();

                    count = Convert.ToInt32(cmd.Parameters["@TotalRows"].Value);

                }

            }

            //Convet the dataTable into list

            List<EditableOrder> resList = new List<EditableOrder>();

            resList = (from DataRow dr in dt.Rows

                      select new EditableOrder()

                         {

                             OrderID = Convert.ToInt32(dr["OrderID"]),

                             CustomerID = dr["CustomerID"].ToString(),

                             EmployeeID = Convert.ToInt32(dr["EmployeeID"]),

                             Freight = Convert.ToDecimal(dr["Freight"]),

                             ShipCity = dr["ShipCity"].ToString()

                         }).ToList();

            return Json(new { result = resList, count = count }, JsonRequestBehavior.AllowGet);

        }