Questions tagged [datatable]

2

votes
1

answer
16

Views

R data table : How to find unknown number of empty cells directly below a specific cell and fill them with numbered strings

I know how to find empty cells in a data.table in general, but this is a little trickier and I haven't quite figured out how to manage this. Lets say I have a data.table which in df[2,1] contains my keyword string i need to target: 'Smart triggered!' in this case. The amount of smart triggers used...
Mark
1

votes
1

answer
2.2k

Views

Showing parent datatable in one datagridview and show child datatable elements in another?

Hi I have created a dataset and two datatables. The URLData table is parented to the KeywordData table via the keyword column. 'Create the primary object to hold both data tables Dim AllKeyWordInfo As DataSet = New DataSet('AllKeywordInfo') 'Create a Datatable For keyword Data. Data Tables are store...
Zach Johnson
1

votes
2

answer
3k

Views

How to render tables in django-datatable-view?

I can't figure out how to render an editable table using Django-datatable-view. I want to create a table exactly like this: http://django-datatable-view.appspot.com/x-editable-columns/ from model City for example. I've read the docs and tutorials but still can't figure out how to create the table....
Milano
1

votes
1

answer
333

Views

@Media Print Class in Datatable

Why my class to add text-aligndid not work on @media print? I made an EXAMPLE PLUNKER I want that Right Element stay on right when user clicks on Print button Style @media print { td.text-right-print { text-align: right!important } } Tabela Left Thead Right Thead Left Element Right Element Thanks!
Johnson
1

votes
2

answer
778

Views

Flutter DataTable - Tap on row

I am using Flutter DataTables to display list of items in cart. Now I want to edit the quantity of any selected row. Is there a way to get the information of the row user has tapped? Following is complete code of my DataTable: class _DataTableSampleState extends State { void _getSelectedRowInfo() {...
Zain SMJ
0

votes
0

answer
26

Views

issues with array of objects from variable in React render methodq

** I defined one constant variable blog from the state at the start of the render method. It contains an array of objects, which are printed to the console, and later passed to DataTable as the options.data prop.** import React, {Component} from 'react'; import axios from 'axios'; //import { Widge...
Andrey
1

votes
3

answer
4.3k

Views

DataTable need to sum a column with filter on it [closed]

I have a data table in C# with columns: Product|Status|ShipedVolume|TotalVolume A New 0 10 A New 5 20 B Closed 7 20 I want to sum (TotalVolume-ShipedVolume) filtered by product and Status. For example I want to query how many not shipp...
Freewind
0

votes
0

answer
3

Views

How to print markup code in RStudio to pdf

I created a table in RStudio using qwraps2 markup code. Is there a way to print this table in basic table format directly to PDF to be used for powerpoint/email/elsewhere? I am not interested in using it for html, website, php, etc. Only to use as email-able table.
ClareFG
1

votes
1

answer
607

Views

ng-select inside ngx-datatable dropdown is not visible

(I reproduced my issue here: https://plnkr.co/QvEWjhJhbsghy1OD) The drop down list of options is not displayed 'over' the row, it seems cut by the cell's height, making it pretty useless. A regular works fine though, I can see all options. How can I make the ng-select works as expected?
dstj
1

votes
6

answer
3.6k

Views

WPF MVVM Bind DataTable to DataGrid does not display data

I've got a simple control which contains a DataGrid which ItemsSource is bound to a DataTable. When I fill the DataTable, I can see that rows are added in the DataGrid, but no data is displayed. I don't use any special style for this DataGrid (take the default one), the only setting is the AutoGener...
GuillaumeA
1

votes
1

answer
111

Views

c# deleting duplicate rows from data table

I'm currently having a problem with my C# code; it is producing duplicate lines in my data table but not in my database itself. I can't for the life of me find whats causing it, so I've tried creating a work around, how ever that doesn't seem to be working either. Any help would be appreciated. for...
evilsponge
1

votes
1

answer
484

Views

dc.js - dataTable — combining data rows

I am creating a dashboard, and the data format is as such: var data = [ {'id': 'CDE', 'count': 1, 'name': 'ajdkf', 'type': 'E', 'state': 'A'}, {'id': 'CDE', 'count': 0, 'name': 'ajdkf', 'type': 'E', 'state': 'A'}, {'id': 'CDE', 'count': 0, 'name': 'ajdkf', 'type': 'E', 'state': 'A'}, {'id': 'CDE', '...
csymill26
1

votes
1

answer
41

Views

Click link and show 3 values on page from datatables

i have bunch of records in Datatables. i have a 4th button which is being used as Action. it do nothing for now just show a pop up. what i want to do is, when i click on one of the action button, then i want the adjacent three values to show on same page at down or up somewhere. for example if we c...
Junaid Farooq
1

votes
2

answer
302

Views

Datarow ItemArray doesn't work fine with a DataGridViewButtonColumn in first column

I have a datagridview with 3 columns. The fist one is a DataGridViewButtonColumn. The tow others are gathered from DB and I am populating my Datagridview from a datatable by using datarow.ItemArray. Since the first column is a DataGridViewButtonColumn, the datagridview is being filled wring. The sec...
ehh
1

votes
2

answer
136

Views

Datatable click on td or a (link) inside td

I'm using datatable, and I like to know, when I click inside the table, if the click is made on a(link) or td(cell). my text - mylink This is my datatable initialisation oTable = $('#mytable').dataTable( { ... }; And my check on td click oTable.on('click', 'td', function(e) { ... }); Actually, I ha...
Mike
1

votes
2

answer
3.8k

Views

Convert DataTable to CSV

I want to be able to Import-Csv into a PowerShell table so I can edit each section with PowerShell script, e.g. $table.row[0].name = 100. Import-Csv doesn't give that 'table' it makes with CSV file. $tabName = 'TableA' $table = New-Object system.Data.DataTable '$tabName' $col1 = New-Object system.Da...
Shale
1

votes
1

answer
89

Views

DataGridView get current column index

I have a DataGridView that can have its columns reordered by the user, what I need to obtain is the current order index of each column, but iterating over them before and after moving the columns shows the same order so it looks as if the index never changes: for (int i = 0; i < dsgDataGrid.Columns....
Dan Hall
1

votes
1

answer
598

Views

Filtering datatable number column

i would like to filter a datatable by a column which contains number data, i'm trying the following: string selected = colSelect.GetItemText(colSelect.SelectedItem); if (filterText.Text.Length == 0) { data_table.DefaultView.RowFilter = string.Empty; } else { data_table.DefaultView.RowFilter = strin...
Dan Hall
1

votes
1

answer
515

Views

How to apply between clause on two columns in Linq query while searching from datatable C#? [closed]

I have table in SQL Server 2008 in which grade criteria is defined and its columns are GradeID, GradeTitle, FromMarks, ToMarks, ClassID and data is populated as Then I have another table in which I store marks of different subjects and I need to apply grades on obtained marks. Here is example... If...
Waqas
1

votes
1

answer
626

Views

Filtering a DataTable and inserting the result into another datatable

I am working on a dataset with has several records in it and I have a method which accepts a datatable as an input parameter. For example, I have a dataset named dsDetails and one of the table in it is Charges with the following data Type Rate Name B 14 bbb A 10 ABC C 12 ccc I am pas...
DoIt
1

votes
2

answer
1.1k

Views

Nested JSON to DataTable Standard Format

What is the standard/Correct form of the Data Table for the give JSON which has Nested collection?. JSON FILE { 'F1':1, 'F2':2, 'F4':[{'E1':1,'E3':3}] 'F3':[ { 'E1':3, 'E2':4 }, { 'E1':5, 'E2':6 }, { 'E1':7, 'E2':8, 'E3':[ { 'D1':9, 'D2':10 } ] }, ] }
Vinod Kumar
1

votes
2

answer
43

Views

Querying from a DataTable to retrieve information based on DateTime

My question might be a bit long coz i've tried to explain the context behind it. I have a DataTable (retrieved from a database) which contains the following data: ---------------------------------- - State - Date - ================================== - on - 02/01/2016 15:38:13...
Tsar
1

votes
1

answer
3.3k

Views

How to populate data in jquery data table without making ajax call?

I am using jquery data table plugin to populate data in web table using ajax.But i want to populate data by calling a method which is present in js file without making ajax call.Is there any way? Sharing my code. ajax : $.fn.dataTable.pipelineAdv({ url : oMapUrls.loadDefaultMap, pages : !bLivePagin...
user3660375
1

votes
4

answer
11.3k

Views

change the setting of datatable after it initialized

I have a datatable with some settings, $(tblCategory).dataTable({ 'bPaging': true, 'sPaginationType': 'full_numbers', // 'bPaginate': false, // shows both next prvious and show 10,20,30 entries 'sdom': 't', 'bprocessing': false, // 'sAjaxSource': 'PM_MasterHelper.ashx?m=pmcfl&UserCode='+UserCode, '...
Gomathipriya
1

votes
2

answer
886

Views

Primefaces: DataTable inside AccordionPanel throws NullPointerException

I have a Primefaces DataTable inside an AccordionPanel with dynamic number of tabs. The DataTable can be sorted by each column by click on the column header. The DataTable throws an NullPointerException in Primefaces' DataTable class when updating a row. The error occurs only after the table has bee...
Frank Leuband
1

votes
1

answer
717

Views

VB .NET SqlBulkCopy - DataTable DateTime type conversion to SQL

I'm trying to use SqlBulkCopy.WriteToServer to insert data in a certain table of an SQL database. To do so, I have a DataTable which is populated with records I need to save on the database. Basically my code is based on the Microsoft's example provided for the method SqlBulkCopy.WriteToServer. The...
hawake
1

votes
2

answer
3.1k

Views

Number and a date range filter for datatable serverside script

I'm using Datatable (DataTables 1.10.10) and Datatable Editor. For my serverside script/table (500000 rows) I would like to have a number and a date range filter. As simple text filter is working fine. Where and how can I modify the data.php for the range filter to work? That's my setup: my script:...
Philipp M
1

votes
1

answer
139

Views

Optimization of nested loops using LINQ

Can you please suggest how to write an optmized LINQ query for the following operation? foreach (DataRow entry1 in table1.Rows) { var columnA = entry1['ColumnA'] as string; if (!string.IsNullOrEmpty(columnA)) { foreach (string entry2 in table2) { var dataExists = table3.Any(rows3 => !string.IsNullOr...
Nayan
1

votes
1

answer
1.2k

Views

Add new row to sorted datagridview c#

I'm trying to add a new row to my datagridview DataRow dr = new dt.NewRow(); dt.Rows.InsertAt(dr,5); And a few lines above I have this line of code Datagridview1.Sort(datagridview1.Columns[6],ListSortDirection.Ascending); The problem is that my datagridview sorted again after im adding new row. And...
ShmuelCohen
1

votes
1

answer
3.2k

Views

Using linq to group, select, and order a datatable

I want to use Linq to select and group DataTable rows... and I want to order those in a descending manner by the 'Max' created date in each group... are there any improvements that could be made to this code, in particular can I make the OrderByDescending part of the Linq, for example using: orderby...
Brian Rice
1

votes
2

answer
1.6k

Views

Using data table I want to search with only first letter

I have a table with Owner names. The users wants to be able to sort the tables from first letter on wards. Example: 1)Saurabh Gujarani 2)Testsa By searching 'Sa' should only list - Saurabh Gujarani But in my current code it display both. $(document).ready(function () { $('#custom_2').dataTable({ 'ao...
Saurabh Gujarani
1

votes
1

answer
585

Views

AngularJS Datatables sort on checked items

I am using anguarljs Lin Datatables Lin Datatables The datatables work nice and search,sort works great, but there is a requirement to sort the datatable's on checked items. For example , when user checks the checkbox and wants to sort on basis of checked items the sorting functionality doesn't wor...
Anand j. Kadhi
1

votes
1

answer
35

Views

Short Date that is given from a SQL data table shows with time and full details

I have a data table in my SQL that dates stored in a column as: Submit Date - and date Data Type Like: 2014/12/02 but when a get this table and put it into a gridview the Submit Date column become like : AM 12:00:00 '2014/12/02' so how can i remove the time first part and just get the date in gridv...
iman
1

votes
1

answer
1.1k

Views

Newtonsoft Json - Serialize DateTime type of DataTable

I have a problem when serializing DataTable to Json using Newtonsoft.Json. This is reductive code: using System; using System.Data; using Newtonsoft.Json; using Newtonsoft.Json.Converters; class Program { static void Main(string[] args) { DataTable dt = new DataTable(); dt.Columns.Add('Prop', type...
Van M. Tran
1

votes
1

answer
229

Views

How to group by categoryid and display subtotal at the end of rows of each category in C# linq

I am working on a datatable. I want to get the Subtotal for each category and Grand Total. I want to add the subtotal row at the end of rows of each. My problem is that I don't get the subtotal for the last category. I don't know where I went wrong. Any one who can help me please. Required output: +...
Mzwe Dlamini
1

votes
1

answer
50

Views

not to read empty or null records in datatble from text file - c#

I have a function which reads all the tab delimited records from a text file into a datatble, but I have a lot empty or null columns also which are tab delimited. I just want to read all records where column 3 is not null or non empty. how can I do it? Here is my simple method public DataTable Conve...
1

votes
1

answer
190

Views

datatable.select() with gridview and datatable

Can you compare a gridview value with a datatable value in a datatable.select() statement? If this is possible, this seems like the way to set it up. I need to work with the datatable rows that match the gridview rows. Similar to this: For Each gvRow As GridViewRow In gvMaps.Rows For Each dtrow As...
madmike
1

votes
2

answer
1k

Views

getting inputText on only the first row of a (Primefaces) dataTable, with dynamic columns and rows

I have a Primefaces (5.0) Datatable with dynamic columns as well as dynamic rows. In brief, my problem is how do I set it up so that the cells of the first row are a series of inputText's or inputTextarea's, while the rows below the first are outputText? To elaborate, the xhtml (following BalusC's r...
anvw
1

votes
2

answer
498

Views

How to highlight the most recent table row in datatables

I am creating a table row using mytable.row.add(getTableRow(data.report)).draw(); function getTableRow(report) { var id = report.id; var date = report.create_date; return [ '' + date + '', user ]; } How can I highlight the table row as soon as I draw it? Here is my table structure Date User Loading...
aaj
1

votes
1

answer
913

Views

Parsing commas in field with TextFieldParser causes extra column

Following on a previous thread Object reference on array with regex.replace() I have few columns in cpath which contain fields such as street,''test,format'', casio . Unfortunately, csvReader.SetDelimiters(new string[] { ',' }); adds empty extra columns to the DataTable csvData because of the comma...
dark.vador

View additional questions