Questions tagged [.net-datatable]
In .NET, DataTable is a class that represents a table of in-memory data. For the jQuery DataTables plugin, please use [jquery-datatables] tag.
57 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
4
votes
2
answers
146
views
Lightweight utility classes to format text in columns
I am working on some helper classes to format console output and to write results to files formatted in columns. That's the big keyword here - columns. The target framework is .NET 8. Nullable ...
6
votes
1
answer
292
views
JSON data converting to Excel File
I have two sets of data coming in from the front end. One is the table header and the other is the table body. the data is in ...
0
votes
1
answer
560
views
Populate TreeView with arbitrary depth from DataTable
I have a DataTable with id, parent, label columns and want to populate a TreeView with it.
I'm new to c# and as far as I understand, there is no ready solution for it, unlike some other languages.
So ...
0
votes
1
answer
922
views
DataGridView Undo/Redo Manager in C#
While answering this code review question, I proposed a solution with List<DataTable>. I am trying to encapsulate this data structure into a "...
3
votes
1
answer
1k
views
Undo/Redo Functionality in DataGridView c#
I have looked at many topics related to this topic, but I could not find or understand for datagridview table. Finally I made the undo / redo implementation myself using datatable lists. This solution ...
1
vote
1
answer
605
views
Ideal ways for Choosing DataSet or DataTable
Required to know the performance overhead associated with DataSet
and DataTable.
When it comes choosing which data structure might be good and performance oriented
what if single Result Set is ...
5
votes
2
answers
312
views
Building equal number of records list object
I am trying to get equal number of records in both columns, even if that means that first column doesn't fill page to bottom on the second page. The only way I was able to do this was by using a ...
4
votes
2
answers
355
views
Making a list of customers who buy the top N items from a supplier
I have a method that works perfectly well and does what it's supposed to, albeit a little slow (30 - 40 seconds). I would like to be able to speed it up or at least make it more efficient, any ideas ...
4
votes
1
answer
1k
views
Mapping DataTable to a concrete type
I have an extension that adds values to a class and I was wondering if there was a faster way to do this.
Does a for loop execute faster or would a LINQ query do better?
...
0
votes
1
answer
5k
views
Search DataTable by column for a specific row
I would like to know if there are ways to make this run faster. Not a big concern right now, but I would like to think long term, it might be important.
This is C#, and I can not change the input ...
4
votes
1
answer
748
views
List of classes to datatable
I'm looking for a function to take a list of generic classes, and map it to different layout of datatable.
That means, I can't just directly map my class property names and values to grid, I need to ...
0
votes
2
answers
2k
views
Pull From Oracle into CSV File
I have written this code in C# to connect to an Oracle Database, omitting the tnsnames.ora file, then place results from a query into a CSV File.
Is there more efficient way to do this? (Such as ...
4
votes
0
answers
1k
views
CSV Data Table Extension
This is my library I wrote from scratch for the .net core that imports and exports CSVs from DataTable objects.
I've seen a lot of huge complicated libraries that handle this and a million other ...
1
vote
1
answer
1k
views
Vertical & Horizontal Direction of a DataTable
I wanted to have a DataTable with cells in direction that is top to bottom or bottom to top and left to right or right to left.
LR - LEFT to RIGHT
RL - RIGHT to LEFT
BT - BOTTOM to TOP
TB - TOP to ...
2
votes
4
answers
2k
views
C# SQL query builder to fill DataTable
I'm trying to optimize my code and in the process of doing that I made a class Query_builder that handles SQL queries. That class has couple of methods: ...