Questions tagged as 'datatable'

Tagged questions
1
answer

How to filter a DataView.RowFilter

I have a DataView and I'm trying to make a filter, where the 'photo' field is different from NULL I tried: dv.RowFilter = "foto <> ''"; But it did not filter. I searched here on StackOver and recommended: dv.RowFilter = "Isnull(...
asked by 07.01.2016 / 17:54
2
answers

If - Datatable condition

I need to compare a value of one of the fields of a DataTable , to accomplish a if condition, but I do not know how to do it. below: public partial class imp_orcamento : DevExpress.XtraReports.UI.XtraReport { Datatable_orcame...
asked by 08.08.2016 / 12:47
1
answer

How to create button with function to export the DataTable to (.csv) in jQuery?

I have the following button: $(document).ready(function() { $('#example').DataTable({ "dom": 'T<"clear">lfrtip', "tableTools": { "sSwfPath": "/swf/copy_csv_xls_pdf.swf" } }); }); <script src="https:...
asked by 12.03.2016 / 21:03
1
answer

Sort by number with DataTables

I have a problem with the DataTables plugin in the order of numbers. I have a list of numbers: 1 2 3 4 ... 10 11 12 The problem happens because of the digits. It sorts type 1 10 11 12 2 3 4 ... The correct order would be from 1...
asked by 01.01.2016 / 18:08
2
answers

Problem retrieving null Data for a DataTable in C #

I'm working with C # and the PostGreSQL Database, I have a field of type Date where it can be filled in dd / mm / yyyy or empty null. the same problem is related to any field of the table, if it is empty, even if it may be, the error occurs....
asked by 22.03.2017 / 22:27
1
answer

JPA / Primefaces - Add / Remove records from a child table

I have a problem with a cadastral panel. There is a store network registry in which I am taking care of the implementation. I can normally insert and remove dataTable items, but this is not reflected in the base in the burning process - when...
asked by 30.11.2015 / 20:14
2
answers

JQuery DataTables - Custom Header

I researched a lot and could not figure out how to customize the pdf report header that I generated from the plugin; For example, the "sTitle": "Groups" is the title that is in the header, but it comes out with the default styling of the plugin,...
asked by 09.06.2014 / 20:45
1
answer

Datatable Server Side with JOIN [closed]

Good evening! I started using Datatable recently, I'm using it with the server-side feature. I need to relate 2 tables with INNER JOIN, I saw that there is a "difficulty" in doing this type of procedure in the case of server-side. I even foun...
asked by 11.07.2018 / 02:12
1
answer

Return string search in table

Data and database queries have a very special place in the universe of computers. The popularization of the internet was due to the agility of searches implemented by the Enginner Search Web mechanisms. Simply searching for a string using sql...
asked by 05.04.2018 / 19:23
2
answers

JQuery DataTables - Number of Paging Numbers

I'm implementing DataTables pagination and I could not figure out how to change the number of paging number buttons. As you can see, we have 1 a 5 , or we could have 7 a 11 numbers of the Page, that is, always 5 numbers . I would...
asked by 10.06.2014 / 19:20