Questions tagged as 'datatable'

Tagged questions
4
answers

DataTable does not sort correctly

I'm using the datatables plugin to render results in a table. The problem is that the first column has 3 dates: 26/11/2015 19/11/2015 03/12/2015 I need to sort the results of dataTables based on these dates. The correct would be fr...
asked by 29.11.2015 / 02:29
2
answers

Add class to a DataTable

I'm making changes to a pagina.aspx of a system, however many things are generated through language functions. <table id="ctl19_tableAreas" style="height:100%;width:100%"> <tbody> <tr style="height:249...
asked by 24.11.2015 / 05:58
4
answers

Sort DateTime field of a DataTable

Hello. I have the following DataTable: success: function (data) { $('#table-controle').html(data); $('#table-controle').DataTable({ "language": { "url": "../../../Content/json/...
asked by 23.08.2016 / 15:13
3
answers

Create a table with dates [closed]

I'm creating a table and need the columns to be created as follows: Mon, 23 Nov | Tue, 24 Nov | Wed, 25 Nov | Thu, 26 Nov | Fri, 27 Nov | Sat, 28 Nov | Sun, 29 Nov To create the table I pass by a date parameter (which is selected through a ca...
asked by 26.11.2015 / 17:30
1
answer

What are the differences between a DataTable and a DataReader for MySQL queries in C #?

I am creating a C # project with MySQL, my connector follows the Singleton pattern and I use MySqlDataReader to retrieve the data from the table and popular a List so far so good. My problem started when I had to recover data from one table b...
asked by 26.01.2015 / 20:58
2
answers

Bring the columns of the DataTable by the Datatabe Ajax itself

Is there a way to bring the columns of the DataTable through the API from Ajax? As an example we have this code $(document).ready(function() { $('#example').DataTable( { "processing": true, "serverSide": true, "ajax...
asked by 02.08.2018 / 20:50
1
answer

Add row in a dataTable

I need to add a row in a table in a given position. I have the following methods: public void criarTabela(DateTime dia) { tabela = new DataTable(); switch (dia.DayOfWeek) { //case...
asked by 30.11.2015 / 03:03
2
answers

Create a table with sorting using DataTable

I am creating a table and need to give the option to sort the table by the field of your choice. I tried to use the dataTable the data is padded correctly in the table but when I click on a header to sort, filter, or any other function of the da...
asked by 15.11.2015 / 19:54
2
answers

Which object performs best? SqlDataSource or DataTable?

In terms of performance, speed, or security, what is the best object to use as a DataSource ? Example, I am creating a DataSource , to popular a GridView : By SqlDataSource : this.sqlDataSource1.ConnectionName = "...
asked by 27.07.2016 / 15:35
1
answer

Manage DataTable with lots of information

I have here a "small" problem with a DataTable . From a SQL query I'm getting a huge amount of records (> 1,000,000 ), and although the query is relatively fast, loading DataTable from Fill() is extremely slow and, in some...
asked by 31.08.2018 / 15:32