The term "datatable" is ambiguous. In .NET, it's a class that represents a table of in-memory data. In component based MVC frameworks like JSF and Wicket, it's an UI component that dynamically renders a HTML table based on a collection. For jQuery DataTables plugin, please use [datatables] tag.

learn more… | top users | synonyms

5
votes
1answer
67 views

Optimize code block for LINQ and non LINQ

I have 2 code block to do same a work and have same target create some thing, but I don't know which block is the best (I mean LINQ or non-LINQ)? First of all, can anyone tell me how to optimize on ...
2
votes
1answer
45 views

Removing columns based on some conditions

This is a follow up to this question. I'm just removing some columns based on some condition as well using the same condition and adding the column values which I am going to remove to another ...
4
votes
2answers
89 views

Set default value for NULL in datatable

I have the following codes, which I created as extension for datatable in my project. It actually worked. Just wonder if there is any optimization can be made through. Thanks. =) ...
5
votes
1answer
35 views

Exporting a table from Google Sheets and sending it via email

Basically is a script to export a table from Google Sheets and send it via email. But it's not a clean script, although it works. If there is any way of making it more simple, or instead of get all ...
3
votes
1answer
64 views

Loose coupling, accessing class properties

I'm trying to get a better understanding of decoupling methods. Right now, I have this method: ...
3
votes
1answer
66 views

Populating DataGrids

I'm building an in house query tool. The main form has a drop down which allows the user to select how they want to find scripts, and a drop down for what server they want to run the query on. There ...
7
votes
3answers
118 views

Dataset with optional addition to where statement

I am trying to generate a dataset from a query that has a where statement. If the user passes a value additional things need to be added to the ...
1
vote
1answer
47 views

Adding additional function if condition is met

Here's my scenario: In case the table has class 'trans' - run dataTable() and ...
5
votes
2answers
1k views

Better method for updating data table

I have completed an application which gathers specific records and marks them as Collected. As of now, the application runs perfectly, does exactly what I need it ...
4
votes
2answers
149 views

Writing a JTable to a tab delimited file

I have wrote this class that will write JTable to a tab delimited file so that it can be opened in Excel. It works great but is there any way to make it better or is there a way to have it directly ...
1
vote
1answer
95 views

Find abstraction for classes which represent tables with differnt amount of colums (based on DataTables)

I have a lot of classes which are principal equal, but they consist small differences so that I can´t abstract then very well. The classes represent different kinds of DataTables. Every Class has two ...
3
votes
2answers
21k views

Faster way to convert DataTable to List of Class

I am using ExcelDataReader to import an excel file to a dataset. Example Excel table below: ...
1
vote
1answer
352 views

Adding blank rows for every skipped value in a DataTable

So I have a DataTable that returns results within a month to month range when available. However, when I format the return, I need to still show skipped months as ...
0
votes
2answers
2k views

Remove matched Rows from two Datatable (performance optimization)

Here I have two DataTables: dtTotalDateRangeExcludeSundays dtAbsentsLeavesHolidaysWorks Each having 10k+ values. I need to delete matched rows. Below code ...
1
vote
1answer
3k views

Performance of WPF datagrid when using DataGridTemplateColumn

I am using DataGrid to show storagehouse occupancy (Occupied-Show Image With a box, Not Occupied-Show Empty Image). In DataGrid I am using ...
1
vote
1answer
550 views

A faster implementation of AcceptChanges?

So I started wondering why it takes 3.5 seconds to AcceptChanges for one changed record in a large DataTable. I wrote another ...
4
votes
3answers
3k views

Search datatable faster

I would like to make the search faster as it takes a long time to retrieve the data that I require. Is there a faster method to do this? I have written the code below to allow me to search through a ...
3
votes
1answer
264 views

Is my base class constructed correctly?

I have tables that use BulkManager to save data to database. I moved common functionality to BulkTableBase. Because creation of ...