How to Use DataTable in Asp.net Mvc

Dr.Ajay Kashyap

9y1.4k.NET

Hello ...

Any One Can tell Me How to Use datatable in asp.net mvc ...and It should Be able to Fetch foreign key data also..

i want like this :-

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger9y ago
read the full documents about the jtable just this link

http://www.jtable.org/

example with MVC

http://www.jtable.org/Home/Downloads?ref=homebuttons#using

full article on code project
http://www.codeproject.com/KB/ajax/jTable.aspx
Dr.Ajay Kashyap9y ago
https://datatables.net/
Dr.Ajay Kashyap9y ago
Joginder Banger Sir.....i want table with paging searching and sorting..

can u share any link
Joginder Banger9y ago
Okay, use the jtable it's very easy and simple. Lot of thread available on google about the jtable in mvc.
Dr.Ajay Kashyap9y ago
Joginder Banger Sir I want To display Record Not any Other Opration i want to perfome ...
you just see this link:- https://datatables.net/
Joginder Banger9y ago
HI ajay,
as per your question and realted image you want to bind the data in gridview is that right. But in MVC have not any server side control so what you think? Lot of third party gird view are available in market. I personaly prefer Jtable because in jtable have lot of funcanitly available like shorting,searching and so on. Please refer below links for more information.

http://www.c-sharpcorner.com/article/crud-operation-in-jtable-using-mvc/

Convert datatable to List
#region "getobject filled object with property reconized"

   public List ConvertTo(DataTable datatable) where T : new()
   {
       List Temp = new List();
       try
       {
           List<string> columnsNames = new List<string>();
           foreach (DataColumn DataColumn in datatable.Columns)
               columnsNames.Add(DataColumn.ColumnName);
           Temp = datatable.AsEnumerable().ToList().ConvertAll(row => getObject(row, columnsNames));
           return Temp;
       }
       catch
       {
           return Temp;
       }

   }
   public T getObject(DataRow row, List<string> columnsName) where T : new()
   {
       T obj = new T();
       try
       {
           string columnname = "";
           string value = "";
           PropertyInfo[] Properties;
           Properties = typeof(T).GetProperties();
           foreach (PropertyInfo objProperty in Properties)
           {
               columnname = columnsName.Find(name => name.ToLower() == objProperty.Name.ToLower());
               if (!string.IsNullOrEmpty(columnname))
               {
                   value = row[columnname].ToString();
                   if (!string.IsNullOrEmpty(value))
                   {
                       if (Nullable.GetUnderlyingType(objProperty.PropertyType) != null)
                       {
                           value = row[columnname].ToString().Replace("$", "").Replace(",", "");
                           objProperty.SetValue(obj, Convert.ChangeType(value, Type.GetType(Nullable.GetUnderlyingType(objProperty.PropertyType).ToString())), null);
                       }
                       else
                       {
                           value = row[columnname].ToString().Replace("%", "");
                           objProperty.SetValue(obj, Convert.ChangeType(value, Type.GetType(objProperty.PropertyType.ToString())), null);
                       }
                   }
               }
           }
           return obj;
       }
       catch
       {
           return obj;
       }
   }
Vaibhav Deshmukh9y ago
Add and Use the following files :

jquery.dataTables.js
jquery.dataTables.min.js
jquery.dataTables.min.css
jquery.dataTables_themeroller.css

And Provide your table element class name in $ selector in Script : //.table
$('.table').dataTable({
"sDom": '<"search"fl><"top">rt<"bottom"ip><"clear">',
"bDestroy": true,
"bPaginate": true,
"bFilter": true,
"sPaginationType": "full_numbers",
"aLengthMenu": [[5, 10, 25, 50, 100, 500, -1], [5, 10, 25, 50, 100, 500, "All"]],
"iDisplayLength": 10,
"aaSorting": [[0, 'asc']],
"bAutoWidth": true,
"oLanguage": {
"oPaginate": {
"sFirst": "<<",
"sLast": ">>",
"sNext": ">|",
"sPrevious": "|<",
"sEmptyTable": "No data available in table"
}
},
});

How to Use DataTable in Asp.net Mvc

Joginder Banger Sir.....i want table with paging searching and sorting..

Joginder Banger Sir I want To display Record Not any Other Opration i want to perfome ...