Questions tagged as 'datatable'

Tagged questions
2
answers

Repeat for many lines

I'm having a problem with an application I'm developing where I have a database with approximately 20 million lines. The problem is that the user wants to see all 20 million rows in a single screen, even if the scroll bar is huge, this table w...
asked by 30.03.2015 / 20:07
1
answer

How can I convert a DataTable to a dynamic object?

How can I convert a DataTable to a IEnumerable<dynamicObject> ? For example, I want to convert any DataTable ID | Name DI | emaN --------- ou --------- 1 | x 2 | x 2 | y 1...
asked by 22.12.2013 / 01:45
1
answer

Move uppercase to lowercase

I have a richfaces datatable component that returns a record from the database and this record comes in all capital letters. Example: PAULO FERNANDES DA SILVA . Would there be something I could do to edit this name with CSS to Pau...
asked by 27.10.2016 / 03:45
2
answers

Jquery Datatable Paging

Is it possible to set the number of pages without having the records? I want a more efficient paging, load page data when the page is clicked. The datatable it loads all the data creating the paging, and I have a client that loads 30 thousand...
asked by 26.02.2016 / 17:25
1
answer

Create DataTable Dynamically

I need to create a dynamic DataTable of the genre: List<p> =... List<l>=.... DataTable dt = new DataTable(); foreach (Prod pr in p) { dt.Columns.Add(prod.Nome.Trim()); for (int i = 0; i < l.Count; i++) {...
asked by 17.04.2014 / 17:08
2
answers

How to sort a p: dataTable

How do I sort a datatable by a text. For example my system is a system of order of services, I need the orders "Open" to come first. Follow the datatable code below. I tried sortby but it did not work. This is my listAll: public List<...
asked by 14.04.2016 / 13:12
1
answer

Configure stable's sZeroRecord parameter but no pagination

I'm using the DataTable function: "oLanguage": { "sZeroRecords": "Não há registros para mostrar" } }); But on my screen appears the export buttons, pagination without me having configured these opt...
asked by 16.11.2015 / 20:29
1
answer

Retrieve the ID of a DataTable within a GridView

I'm trying to rescue the ID from my client that is in GridView , but I'm using DataTable to fill GridView . DataTable public DataTable SelecionarDT() { objDAO = new ClienteDAO(); DataRow dr; DataTabl...
asked by 28.04.2014 / 17:00
1
answer

Too slow table using Datatable

I am bringing 3,000 MYSQL database records using a connection to PDO and PHP. The time to be taken costs around 40 seconds until all the data is presented. Is Datatable unable to bring data in pieces? Below is my entire code: -HTML-...
asked by 01.06.2018 / 14:46
1
answer

Export Datatables

I use the JQuery Datatables plugin , and would like to export the data (CSV, Excel, PDF ...) of the tables through custom buttons , instead of the buttons that the plugin itself offers, is it possible? In the red rectangle, the buttons of th...
asked by 05.07.2016 / 20:17