22,095 questions
0
votes
0
answers
46
views
Is it possible to add a column to a datatable read from a file?
I have a DataTable read from a csv file:
ID,ItemCode,ItemDescription
1,Test0,test item
2,Test2,second test item
When I try to create an additional column as in https://learn.microsoft.com/en-us/...
- 229
1
vote
3
answers
164
views
How to lazily load DataTable rows from a large text file using IEnumerable and yield return in C#?
I'm working on a C# application where I need to read a very large text file and convert its contents into a DataTable. However, I don't always need all the rows—so I want to avoid loading the entire ...
- 37
1
vote
1
answer
42
views
Selection on expanded row in DataTable is not working
Describe the bug:
In my attached code I have a parent table with multiple rows (rows are expandable) when I expand it and try to select a sub-row, it doesn't get selected,
Note: both parent table and ...
- 21
2
votes
0
answers
92
views
Problem with frozen columns in Datatable component from PrimeVue library (gaps, shifting)
I have encountered a problem with the DataTable component from the Primevue library.
When I assign pagination to a table and set several frozen columns, if I switch the number of rows displayed in the ...
- 1,658
0
votes
0
answers
41
views
PrimeVue DataTable MultiSelect Filter Shows Incorrect Selected Count When Pre-selecting Values
I'm using PrimeVue DataTable with a MultiSelect filter on the "Project Status" column. I want to pre-select certain status values by default, but only those that actually exist in my data.
...
- 1
0
votes
1
answer
44
views
Svelte + Routify: Carbon Pagination always resets to page 1 instead of syncing with URL
I’m building a Svelte 4 app with Routify for routing and carbon-components-svelte for UI.
I have a Pagination component that should read the current page from the URL query params ($params.page) and ...
- 317
0
votes
2
answers
168
views
Why my code is becoming slower over long loop?
I have below code,
library(data.table)
library(dplyr)
Number = 10
iSimu = 1
dat = as.data.table(matrix(0, nr = 1, nc = Number))
while (iSimu <= 500000) {
...
- 3,896
0
votes
1
answer
85
views
Get original DataRow from GetChanges()-Table
I have some sort of undo functionality in my application. I remove a row from the GUI an could undo or commit it through the underlaying DataTable-functions RejectChanges or AcceptChanges. But when I ...
- 505
0
votes
0
answers
48
views
How can I bind the results from a paginated ASP.NET Web API endpoint to a jQuery DataTables table in my ASP.NET MVC view?
I'm attempting to pass paginated results from a Web API to an MVC application and displaying in the View using DataTable. While I've successfully retrieved the data from the server and transmitted it ...
- 19
1
vote
0
answers
130
views
Header alignment with sort/filter icons in PrimeReact DataTable
I have a PrimeReact DataTable with multiple columns.
Each column has a text header, optionally with sort and filter options.
Alignment of the columns can differ, and I would like the alignment of the ...
0
votes
2
answers
580
views
C# LINQ Dynamic - Against a DataTable - Syntax not working?
My app allows the user to choose what table and columns to filter on. It can be a different table and columns each time the user runs this routine. So standard LINQ will not work. I need to do this ...
0
votes
1
answer
65
views
How to convert string "false" and "true" to numeric 0 and 1
How do I convert string "false" and "true" to numeric 0 and 1 within Grafana?
I need to do this to then summarize a row or a column and get a count of trues.
I tried using "...
- 19
0
votes
1
answer
103
views
The fixedColumn feature not being applied in the datatable
I am trying to freeze the first four columns of this datatable when a user is scrolling it horizontally. But the style "dtfc-has-left" style="position: relative;"" is not ...
- 33
0
votes
1
answer
131
views
I have a DataTable mapped by ExcelDataReader, and I want to inject a new column with a fixed value
I'm building a service that would receive a .xlsx, .csv or .xls file through form-data, and I need to read the file columns (should be just 3 columns) and bulk copy the data into my SQL Server ...
0
votes
1
answer
61
views
React Datatable unable to intialised DataTable for the second time
I am having problems with reinitializing my datatable in react. Below is an example that I have compiled for everyone to replicate the problem immediately. Currently, I am trying to let user to select ...
1
vote
1
answer
110
views
In PowerShell, I cannot transfer System.Data.DataTable using the invoke-command to the remote host
Here is a script in which I am trying to pass a variable of type System.Data.DataTable via invoke-command to the remote host:
function Test1 {
param (
[System.Data.DataTable]
$...
- 21
0
votes
0
answers
88
views
How to acheive both fixedColumn and colresize in Jquery datatable
I'm trying to implement both column resizing and fixed columns in a jQuery DataTable. I'm using the ColResize plugin, which works fine for column resizing. However, when I enable fixed columns, the ...
0
votes
0
answers
46
views
Colresize option on Jquery Data table for fixed column
I have implemented jQuery DataTables on a Visualforce page and am currently using the FixedHeader and FixedColumns extensions. Now, I’m trying to implement column resizing functionality, but I am ...
1
vote
1
answer
96
views
How to select certain row(s) by code in a DataGrid table in Python-Shiny?
I created a table ("DataGrid") using:
ui.output_data_frame("grid")
which I filled using
@render.data_frame
def grid():
df = ...
return render.DataGrid(df, ...
- 640
0
votes
1
answer
59
views
DataTables loses selected checkboxes across pages when generating custom PDF with jQuery
I'm using DataTables with pagination and checkboxes to allow users to select multiple banners. Upon clicking "Generate Proposal", I collect all checked rows, generate HTML, and convert it to ...
0
votes
1
answer
83
views
Razor - Convert DataTable to Array in JavaScript
I have a datatable in Razor Project with rows containing id, name, title, parent, and other fields. I need to bind a JavaScript array dynamically, but I tried this code and got an error. Please help.
...
- 23
1
vote
1
answer
55
views
The table has no ID, the date is contained in two columns
I have a table in which a new record is added about once a second. The ID is missing from the table. The "Time" column shows the time in milliseconds, which is reset at the end of the day.
...
- 41
0
votes
0
answers
46
views
In R Shiny, DT:Datatable, filter out selected rows [duplicate]
My question: I have a rather large dataset in R Shiny and want to give the user the possibility to filter out single rows.
As my problem was not clear before, I explain it a little more: Filtering out ...
- 704
0
votes
0
answers
72
views
Datatable Load from reader failure
I´m trying to fill a datatable with some information. The information is the result of a query.
here my code that not working:
TrinoConnectionProperties properties = new TrinoConnectionProperties()
`...
0
votes
1
answer
69
views
Sort values across different columns
I have the following data frame I need to sort in a specific way.
D1 and C1 are linked together
D2 and C2 are linked together,
D3 and C3 are linked together.
I need columns D1, D2 and D3 to contain ...
- 487
0
votes
1
answer
50
views
Sorting DataTable object by current values, while preserving original values
In C# I have a DataTable that has been modified several times, where some rows are deleted, some rows are updated, some rows remain the same.
DataTable detailsTable = GetDdetails();
Insert code that ...
- 469
0
votes
1
answer
143
views
Issue with Azure Data Factory Copy Activity: Transferring Data from Azure Storage Table to SQL Database
If you face issue while copying data from source Azure Storage table to SQL, where you see few columns are missing, this can be resolved by giving the first row with dummy values rather than they ...
2
votes
1
answer
96
views
'Failed to compare two elements in the array' when Order is done
I am getting an output from a DataTable for certain columns that have been defined in a string array: string[] columnsToBeUnique;
var ordered = dataTable1
.AsEnumerable()
...
- 611
0
votes
2
answers
78
views
Count duplicate rows in a DataTable
I want to perform a select distinct on a DataTable using Columns that are stored in string array: string[] columnsToBeUnique.
This is what I have at the moment but it doesn't return any values...
...
- 611
1
vote
0
answers
59
views
Syntax error using DefaultView.RowFilter on DataTable
I'm getting this error when my code runs and I can't work out why as the syntax looks on point but I could be missing or misunderstanding something
System.Data.SyntaxErrorException: 'Syntax error: ...
- 705
-1
votes
3
answers
105
views
Sum of multiple datatable columns
I want to get the sum of only two columns for each data row in datable and display it in datagridView. I tried to use link query:
SqlCommand cmd = new SqlCommand("SELECT * FROM Student", con)...
- 194
0
votes
0
answers
19
views
DataTable with ContextMenu not handling muli-selected rows
I have working DataTable that works well with ContextMenu when DataTable is in single row select mode. When selectionMode="multiple", however, a right click on one of the selected rows ...
- 358
0
votes
1
answer
81
views
VBA JSON Parser "datatype mismatch" error importing into MS Access table
I have used the VBA JSON library (https://github.com/VBA-tools/VBA-JSON/releases) to attempt to parse a json file into an access table.
The code I use is:
Private Function JSONImport()
Dim db As ...
-1
votes
1
answer
451
views
how to wrap lwc lightning datatable header text
how to wrap lwc lightning datatable header text,
i'm already using wrapText: true, for table sorting its workig for table data but not for table header
<lightning-datatable data={pagedRecords} ...
0
votes
1
answer
96
views
How to reset datatable columns' filters
I created a datatable that filters on each column. Everything was fine until I updated my code trying to reset all filters.
Here's my code:
$('.dt-column-search thead tr:eq(1) th').each(...
- 11
0
votes
0
answers
91
views
Flutter DataTable2 - Expand/Collapse on clicking a row
I am using the Flutter DataTable2 to display one set of data. However, would like to know if I can add additional rows to display a second set of data on clicking a row. This is like the Expansion ...
- 139
0
votes
0
answers
106
views
Vuetify 3 Multi Filter Data Table
I am working on a Vue 3 project with Vuetify 3.
In a datatable, I want to add the possibility to filter multiple columns that can be of multiple data types (text, int, datetime).
I have tried to ...
2
votes
1
answer
122
views
How to make select cell focused in jquery datatable
Im using Jquery data table
im using 3 fixedColumn when i press shift+tab from end row its navigating each cell but some cell are not focusable its showing half field which difficult identify which ...
0
votes
0
answers
32
views
C# OleDbDataAdapter Fill and merge table function not working as expected
I am trying query few Historian tags data from Proficy Historian using OleDbDataAdapter. The code pulls the data right from the historian but when I am trying to merge the data in a common Data table, ...
- 1
0
votes
0
answers
54
views
How to dynamically Access `c:set` defined values in JSF Facelets (Primefaces Datatable)?
The value defined by c:set refers to a var (name of the iterator variable used to refer each data), but the column values are not displayed.
How should it be defined to be displayed correctly?
<c:...
0
votes
1
answer
91
views
Dynamic LINQ struggling to manage DBNull value in Sum with Group By (in Datatable)
I'm using a dynamic linq on the DataTable to generate consolidated summations. All everything works great except when a value is null for Column9 used for summation. I got NullException ''Object ...
- 83
0
votes
1
answer
111
views
SqlDataAdapter not filling DateOnly fields from SQL Server in C#
I have a SQL Server table with
CREATE TABLE date_table
(
id int NOT NULL,
my_date date NULL
);
And I'm fetching data into the table from a DataTable in C# with a standard call to Fill like ...
- 11
0
votes
0
answers
57
views
How to make a data frame reactive to changes of a date range?
I have got two data frames "Table 1" and "Table 2".
Features of the data frame "Table 2" are the following:
It is created by means of rhandsontable and, hence, new rows ...
- 119
0
votes
1
answer
55
views
Can not read XML data from the file written with 'dataTable.WriteXml()' method
I have a data table with the following columns.
dataTable.Columns.Add("ID", typeof(string));
dataTable.Columns.Add("File Name", typeof(string));
dataTable.Columns.Add(&...
- 2,311
0
votes
1
answer
64
views
React warning: A component is changing an uncontrolled input to be controlled in `react-data-table-component-with-filter`
Problem description
I’m using the react-data-table-component-with-filter library to implement a table with column filters. However, when I type in the filter input of any column typing an existing ...
- 11
1
vote
1
answer
91
views
Datagridview's Datasource Doesn't Update Until Leaving Row
Sorry if this is answered elsewhere, I've searched all over and can't find an answer. I think my scenario is pretty simple.
I have a DataGridView who's DataSource is set to a DataTable. I handle the ...
- 159
0
votes
3
answers
95
views
How to Redirect to Login Page on 401 Unauthorized Response in DataTable Ajax Requests (ASP.NET Core MVC)
I'm working on an ASP.NET Core 8.0 MVC project where I'm using DataTables to display data with server-side processing via Ajax requests. I have implemented a custom middleware to check if the user is ...
- 21
0
votes
1
answer
45
views
LINQ - DataTable GroupBy Count Distinct
I am trying to join to tables together in vb.Net using linq to return the distinct count of the primary keys, and I can't quite seem to get the syntax
Here's the code to create the tables
Dim ...
- 17
0
votes
1
answer
65
views
Trouble with Filtering a .NET DataTable
I have the following code:
myDataSet.myTable.DefaultView.RowFilter = "Code <> 'X'"
After the line executes, I can see the updated result where no rows contain an X for the Code column,...
- 6,585
0
votes
0
answers
25
views
Uncaught TypeError: Cannot set properties of undefined (setting '_DT_CellIndex') and the data table also not working
<table class="table datatable-basic table-bordered" id="mviewTable">
<thead>
<tr class="bg-blue-800">
...
- 1