Here is an example of how to utilize ado.net with jqgrid, which I trust will be beneficial for you.

Controller"

 public ActionResult GetCustomer(int rows, string sidx, string sord, int page)
        {
            List<Customer> _customerList = new List<Customer>();

            DataTable dt = new DataTable();
            string strConString = @"Data Source=gen5win10;Initial Catalog=AsifDb;Integrated Security=True";

            using (SqlConnection con = new SqlConnection(strConString))
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("Select * from Customer", con);

                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.SelectCommand = cmd;
                DataSet ds = new DataSet();
                da.Fill(ds);

                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    Customer cobj = new Customer();
                    cobj.CustomerId = Convert.ToInt32(ds.Tables[0].Rows[i]["CustomerId"].ToString());
                    cobj.ID = Convert.ToInt32(ds.Tables[0].Rows[i]["CustomerId"].ToString());
                    cobj.Name = ds.Tables[0].Rows[i]["Name"].ToString();
                    cobj.Phone = ds.Tables[0].Rows[i]["Phone"].ToString();
                    cobj.Address = ds.Tables[0].Rows[i]["Address"].ToString();
                    cobj.Date = Convert.ToDateTime(ds.Tables[0].Rows[i]["Date"].ToString());

                    _customerList.Add(cobj);
                }

            }

                int pageIndex = Convert.ToInt32(page) - 1;
            int pageSize = rows;

            var Results = _customerList.Select(
                    a => new
                    {
                        a.ID,
                        a.Name,
                        a.Phone,
                        a.Address,
                        a.Date,
                    });

            int totalRecords = Results.Count();
            var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
            if (sord.ToUpper() == "DESC")
            {
                Results = Results.OrderByDescending(s => s.ID);
                Results = Results.Skip(pageIndex * pageSize).Take(pageSize);
            }
            else
            {
                Results = Results.OrderBy(s => s.ID);
                Results = Results.Skip(pageIndex * pageSize).Take(pageSize);
            }
            var jsonData = new
            {
                total = totalPages,
                page,
                records = totalRecords,
                rows = Results
            };
            return Json(jsonData, JsonRequestBehavior.AllowGet);

} 

HTML:

<link href="~/Scripts/jquery-ui-1.12.1/jquery-ui-1.12.1/jquery-ui.css" rel="stylesheet" />
<link href="~/Scripts/Guriddo_jqGrid_JS_5.2.0/css/ui.jqgrid.css" rel="stylesheet" />

<script src="~/Scripts/Guriddo_jqGrid_JS_5.2.0/js/jquery-1.11.0.min.js"></script>
<script src="~/Scripts/jquery-ui-1.12.1/jquery-ui-1.12.1/jquery-ui.js"></script>

<script src="~/Scripts/Guriddo_jqGrid_JS_5.2.0/js/i18n/grid.locale-en.js"></script>
<script src="~/Scripts/Guriddo_jqGrid_JS_5.2.0/js/jquery.jqGrid.min.js"></script>

<h2>Customers</h2>

<br>

<script type="text/javascript">
    $(document).ready(function () {

        $('#sample').jqGrid({
            datatype: 'Json',
            url: '/Customer/GetCustomer',
            type: 'POST',
            colNames: ['ID', 'Name', 'Phone', 'Address', 'Date'],
            colModel:
            [
                {key:true , name: 'ID', index: 'ID', editable: false },
                {name: 'Name', index: 'Name', editable: true ,editoptions: {maxlength: 15 },editrules:{ required: true,  }, },
                {  name: 'Phone', index: 'Phone', editable: true,  editoptions: {   maxlength: 15, },editrules: { required: true, },},
                {name: 'Address', index: 'Address', editable: true, editoptions: { maxlength: 30,}, editrules: {required: true,},},
                { name: 'Date', index: 'Date', editable: false, formatter: "date" },
            ],
            pager: jQuery('#pager'),
            jsonReader: {
                root: "rows",
                page: "page",
                total: "total",
                records: "record",
                repeatitems: false,
                Id: "0"
            },
            caption: 'Sample JqGrid Table',
            viewrecords: true,
            rowNum: 10,
            rowList: [10, 20, 30, 40],
            height: '100%',
           // multiselect: true

        }).navGrid('#pager', { edit: true, add: true, del: true, search: true, refresh: true },
             {
                 // edit options
                 url: '/Customer/EditCustomer',
                 closeOnEscape: true,
                 closeAfterEdit: true,
                 recreateForm: true,
                 afterComplete: function (response)
                 {
                     if (response.responseText) {
                         alert(response.responseText);
                     }
                 }

             },

           {
               //add
               url: '/Customer/AddCustomer',
               closeOnEscape: true,
               closeAfterAdd: true,
               afterComplete: function (response) {
                   if (response.responseText) {
                       alert(response.responseText);
                   }
               }
           },
             { //Options for Delete
                 url:'/Customer/DeleteCustomer',
                 closeOnEscape: true,
                 closeAfterAdd: true,
                 afterComplete: function (response)
                 {
                     if (response.responseText) {
                         alert(response.responseText);
                     }
                 }

             }
             );

    });


</script>



<table id="sample"></table>
<div id="pager"> </div>