How to Use DataTable in Asp.net Mvc

Question

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 :-

Vaibhav Deshmukh · Answer

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" : ' rt ' , "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" } }, });

Joginder Banger · Answer

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 Kashyap · Answer

https://datatables.net/

Dr.Ajay Kashyap · Answer

Joginder Banger Sir.....i want table with paging searching and sorting.. can u share any link

Joginder Banger · Answer

Okay, use the jtable it's very easy and simple. Lot of thread available on google about the jtable in mvc.

Dr.Ajay Kashyap · Answer

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 Banger · Answer

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; } }

How to Use DataTable in Asp.net Mvc

Answers (7)