Questions tagged [datatable]

1

votes
3

answer
47

Views

The specified value “undefined” is not a valid number

I´m learning for an exam which is about company inventories. I thought i could do myself a favor and learn something new about coding while learning for this exams. Normally i only do frontend with very little javascript at my company. What i´m trying to do is setting up a table with 2 input rows....
Jurijcorn
1

votes
2

answer
5.5k

Views

Crystal Report Displaying only one row in each page

I am using Crystal Reports with Visual Studio 2012. I am totally new to crystal reports. I just added my data fields to the details section, but instead of showing all the rows in one page, a new page is created for each row. I did not use any grouping or change the section paging settings. Even i c...
Santosh
0

votes
1

answer
23

Views

Datatable doesnot show rows while reading tsv file

AM reading .tsv file which has around 3500 columns and 1000 rows , when i add rows to data table , rows are added to data table successfully( i see datatable.Rows.Count is increasing) but data table doesn't show any data. i have referred various articles,still see same issue, any suggestions would h...
Venkat
0

votes
1

answer
19

Views

c# Enter value into datatable via different forms

I have a c# project with 4+ forms (parent-child relationship). In Form01 I create a datatable with initial 'Rating' values in it assigned to variable 'Horse': public Form01() { InitializeComponent(); dgvMeetings.DataSource = GetMeetings(); dtRatings = GetRating(); } dtRatings table is produced by an...
Tammboy
1

votes
2

answer
1.9k

Views

jQuery how to fix Cannot set property '_DT_CellIndex' of undefined?

I'm new in Jquery and I want once the user adds new row and give the important information once he clicks on 'Ajouter' button it will add on data base then reload the table automatically. Once i run that I found that the data added successfully to the database however 'tablebqup' does not reload an...
DINA TAKLIT
0

votes
0

answer
5

Views

NGX-DATATABLE RowClass select particular column or cell within row

Instead of selecting the entire row like this I just want to select 2 cells like this using data from rows, is there a way I could achieve this?
Jin
1

votes
3

answer
76

Views

How to check whether it is the last page in DataTable?

I am using the jQuery DataTables plugin (https://datatables.net/). I want to check if current page is last the page then show div else hidden. How can I do that? Here is my example Datatable: $(document).ready(function() { $('#example').DataTable({ pagingType: 'simple', 'searching': false, 'Fi...
Fatikhan Gasimov
0

votes
0

answer
12

Views

MySqlDataAdapter doesn't fill DataTable

I would like to fill a DataTable object from MySql query, and display with DataGrid. The display part of my code works well (It shows a custom DataTable). Somehow the DataTable fill method won't work for me (i copied it from stackoverflow). If i fill up DataTable from List with this function is work...
Mark Ferenczi
0

votes
0

answer
8

Views

Cascading combo boxes in VB.Net with Datatables using Designer

I found this tutorial and am trying to make it fit my needs using the designer. I could design the data tables using the designer in VB.net but when I try to execute, I am getting an error on this line Dim dv As DataView = combo2.DataSource https://www.tek-tips.com/viewthread.cfm?qid=1534892 Private...
Shan
1

votes
1

answer
4.1k

Views

DataTables deleting a row without page refresh

I am using this code to initialize datatable and after Delete link is clicked - EVERYTHING works OK, but Iam using refresh page, so I tried to delete row directly with DataTable function, but can't get it to work at all.... Here is current code (the one that works, but refreshes whole page): $(docum...
Peter
1

votes
1

answer
406

Views

Datatable how to pass data from input to controller

In datatable I have for every row one input,and I want to add some text to this input and for every input I want to take the text and save it into database Im using laravel and want to use ajax Now its working fine only for the first input but for the second whatever I wrote it will take the first i...
Hala ways
1

votes
0

answer
43

Views

Set alias of data table pagination numbers

I am working on a project which for some reasons we need to load data in separate pieces . we load 5000 number of rows on every page load and show them to user. in first loading we have correct pagination which starts from 1 to 500(10 item per page). But when we want to load second bunch of data whi...
Jafar rezaei
1

votes
2

answer
53

Views

Disable sorting datatable

I am trying to disable sorting 'Empty' column. I'm adding bSortable: false, targets: [0], orderable: false, but no luck. $('#example').DataTable({ aaSorting: [], bPaginate: true, aaData: _vIntArrData, aoColumns: [{ sTitle: '' }, { sTitle: 'Category' }, { sTitle: 'Name' }, { sTitle: 'Audience / Cove...
Ananda
1

votes
1

answer
978

Views

Get current display count from Ngx-Datatable

I have been using swimlane/ngx-datatbles with angular5. Want to add a new footer that has the current displayCount. https://github.com/swimlane/ngx-datatable Here is what I want in the footer: Showing 10 of 25 total Hoping the code is something like this Showing {{displayCount}} of {{rowCount.toLoca...
kosmos
1

votes
1

answer
35

Views

How to apply method datatable to table which is created on a fly

I'm creating table dynamically via button click event function createTable() { $.ajax ({ url: 'php/GetData.php', type: 'POST', data: {id:25}, success: function(msg){ var obj = JSON.parse(msg); var tableString = 'NameAgeBirthday'; for (var i=0; i
GGSoft
1

votes
0

answer
150

Views

ajax update row while using the rowStyleClass of p:datatable

i have a p:datatable of 30 sets of rows with each row can have different colors(rowStyleClass) based on the values chose in one of the column with ajax update table. however, this give me problem with unsaved values in other columns of input text where everytime i change the value ajax, the table ge...
user3160432
1

votes
1

answer
105

Views

Django 1.11: combine fields for QuerySet using Q

I'm using the DataTable Plugin to render a list of reference for 'nanas' (spanis for babysitters). Right now I can filter on: nana's nombre(name) or reference's nombre(name). In adition to this I want to filter on nana's nombre + nana's apellido_paterno Doing this doesn't work (returns empty table...
Omar Gonzales
1

votes
1

answer
19

Views

Originalvalue in RowDeleted-Event

I have the following Code: public Test() { var dt = new DataTable('arguments'); dt.Columns.Add('id', typeof(string)); dt.Columns.Add('name', typeof(string)); dt.Columns.Add('type', typeof(string)); dt.Rows.Add('a', 'b', 'c'); dt.Rows.Add('1', '2', '3'); dt.RowDeleted += DtOnRowDeleted; dt.Rows[0].De...
BennoDual
1

votes
1

answer
2.4k

Views

Laravel Yajra Datatable Server Side with pagination problems

I'm newby on Laravel and I'm trying to use Yajra Datatable Plugin with server side funtionality. The plugin works well with a small amount of records, but I have a large amount of about 100000 record. To speed up the process in my controller I limit the query's result with take(10) and I use anothe...
Roberto Remondini
1

votes
1

answer
232

Views

Google Visualization DataTable Change background color

everyone! I have using google visualization datatable to create a simple orgchart but I want to change background color dynamically like the following. I have hardcode the row index to change backgroud color. How to get this row index using for loop or other methods? Please help!!! function OnSucces...
user1735815
1

votes
0

answer
311

Views

Yajra datatable global search not working

The Yajra Datatable global search is not working. Controller Code public function getTable() { $query = Customer::query(); return Datatables::of($query) ->addColumn('name', function ($query) { return '$query->name'; }) ->addColumn('number', function ($query) { return '$query->number'; }) ->addColumn...
DOEE
1

votes
2

answer
751

Views

Limit in Laravel Datatable

I use a Laravel Datatable in Laravel to create a Datatable. I need to show only 5 records, so i try this code. $visitas = Visita::select(['id','f_salida','f_entrada','nombre', 'empresa','visitado_id'])->orderBy('f_entrada', 'desc'); ->setTotalRecords(5) -> make(true); I set total records to show on...
El Hombre Sin Nombre
1

votes
0

answer
338

Views

Update Row in datatables

I have a jquery script in which i have a datatable but when i would like to edit a field in datatable it does not show me that the field is modify knowing that in the database the field is modify but i would like to display in row the field that already modify. In the method addPost i used this code...
Yannick jansen
1

votes
1

answer
271

Views

How to remove all the items in an p-chips input inside PrimeNG datatable by clicking on a link?

I need help in removing all items in a primeng p-chips input inside PrimeNG datatable when user clicks on 'remove all'. In this case, I want to remove all the selections of carBrandOptions for that row when user clicks on remove all link. I am looking for typescript code for this. Thank you! remo...
Saman
1

votes
0

answer
275

Views

Datatables Search(multiple values for single column) not working if the values contain space character

I am implementing a web application using datatables(for table view). where I need to add search feature against some columns. Now user may want to look for multiple values in a column at a same time. For example if the column name is place. The user may ask for place with value tokyo and london at...
Dip686
1

votes
1

answer
144

Views

Error in Datatable: Cannot display correct number of rows

I am using angularjs and datatable. I can perfectly display the data but I have a problem in pagination and displaying of rows. The number of rows displayed on load of the page is 10 and the UI somewhat shows like this: Show 10 entries But it displays all the data and not just only 10, after I reloa...
daya_nara
1

votes
0

answer
143

Views

How do I add a button on each row in DataTable when using SQL connection

I am brand new to using DataTables and trying to add a button to the end of a row that passes a value to a function to insert into another sql database table. I'm using an SQL connection and have not implemented AJAX yet. Was following this example My ASPX File is using this: $(document).ready(fun...
jroyce
1

votes
1

answer
78

Views

how to manipulate with dom (datatable)?

I am working on a project where, we are showing each year data summary to user, and in that summary they will see each years total data. (counted rows). IMG : data summary and when user click on '+' icon he will see the data of that year. Suppose i click on 2013: IMG: data summery of the year 2013 N...
sam
1

votes
0

answer
22

Views

How to highlight datatables individual search texts?

i want to highlight search texts without using Datatables highlight js. i am using Datatable individual column search API. but i want to try something different. any suggestion would be appreciated. i know this : Datatable highlight js $('.text-inputs-searching thead th').each( function () { var ti...
sam
1

votes
0

answer
118

Views

Primefaces datatable selection malfunctions after update

I am facing a problem with the update of the datatable component in the primefaces. My goal is to update the datable and the selected row of the table to remain highlighted. Instead of this I have the following: The 1st, 3rd, 5th,... selected highlighted row stays selected after the update whereas t...
evaliotiri
1

votes
0

answer
20

Views

JQuery DataTables Multi-Checkboxes in a row issue

I am using data table in which row might have checkbox in first column to select row and couple more checkboxes in other columns for associated data. Problem is when I am selecting row it select all checkboxes within that row. I was wondering how I could fix this issue. Thanks for help! There is Dat...
Imphusius
1

votes
1

answer
1.6k

Views

Jquery datatable date format “DD/MM/YYYY” not correct ordering with these formats

Jquery datatable column Date format is DD/MM/YYYY not Correctly ordering asc or desc with these date's 27/12/2017 , 18/1/2018 and 15/1/2018. I google a lot but not found any helpful solutions Please give me helpful soluation here is html code. Date Description 27/12/2017 2 Kit Light Gray M-1 18/1/20...
zubair Ahmad
1

votes
0

answer
55

Views

Generate dynamic tables using datatable with order, limit, search functionality

I am using jQuery datatble server side processing (https://datatables.net). First i am sharing my database structure you are aware about idea that how the data stored in database and how to render it. Table Row Master: Table Column Master: Table Data Master: These are the three tables And I am putti...
Darshan ambaliya
1

votes
0

answer
255

Views

Pass Mock datareader to datatable load method

I am trying to unit test a piece of code which has one of the below line var datatable = new DataTable(); datatable.Load(datareader); So I want to pass mocked data reader object in the load method. I want data table class to load my stub values from data reader. I have done below setup in my test ca...
Viru
1

votes
0

answer
350

Views

Row grouping and its subTotal for multiple level in Datatable

Example as I needed pics is attachedI want to group multiple columns and also display the sub totals of each groups respectively using rowGroup extension or any other alternative I have got the code for multiple RowGrouping But I want to find its summation or Average(ie, Any Aggregate Function). the...
Rupesh U.R
1

votes
0

answer
339

Views

how to join multiple tables in datatable [row child]

I am using datatable serverside row child functionality row child but I need to get data from two tables using join. How can I get my required results. Here is my ajax file :
Haris Khan
1

votes
0

answer
22

Views

Ajax Error on Loading Datatable

I am currently trying to load a data table from my controller, and this Ajax Error appears enter image description here function InitOverviewDataTable() { $('#data-table').dataTable().fnDestroy(); $('#data-table').dataTable({ bProcessing: true, sAjaxSource: '@Url.Action('LoadUser', 'Setup')' }); } [...
Jet Ronrick Glomar
1

votes
0

answer
55

Views

How I can filter a datatable using a html form

Is it possible to perform this? I want a field search for my datatable. I created 3 field as search options. I'm using a postgresql my database. I checked the datatables plugin. They have the field filter that I wanted but I would be better if I can put the fields outside the datatable itself.. UPDA...
user_boq
1

votes
1

answer
451

Views

How to Join 2 Tables using Server-Side Processing DataTables

Index.php HTML $(document).ready(function() { $('#users').DataTable({ 'processing': true, 'serverSide': true, 'ajax': 'server_processing.php' }); }); Server Side DataTable Id Fist Name Last Name Phone Location Server Script $table = 'users'; $primaryKey = 'id'; $columns = array( array( '...
Vester
1

votes
0

answer
172

Views

Datatable search in nested table

I'm using metronic v5.0.7.1 i have a datatable which is contains nested array so i just want to search in this array. I'm able to bind my case status like that; { field: 'case.case_status', title: 'Status', } there is my search field; var query = datatable.getDataSourceQuery(); $('#m_form_durum').on...
Jackquin

View additional questions