Questions tagged [datatable]

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 the [datatables] tag, for the data.table R package please use [data.table]. For the Python datatable package, use [py-datatable].

DataTable in .NET

A DataTable is a .NET class that represents one table of in-memory data. Unlike other programming languages and platforms, a .NET DataTable is not a GUI control but rather a representation of a SQL table directly accessible in code and a source of data for other controls.

A DataTable may exist as part of a DataSet, which represents an in-memory relational data store. In that context, they can be connected through instances of the DataRelation class, and constrained by ForeignKeyConstraint or UniqueConstraint instances.

A DataTable has a set of DataColumn instances, which describe its schema. Data is stored in DataRow instances.

A DataTable may be sorted and filtered without changing the data by attaching it to a DataView. The sorted and filtered rows are then accessed as instances of the DataRowView class.


DataTable in JSF

A <h:dataTable> is an UI component which allows you to render a HTML table dynamically based on a given List<Entity>. You can specify columns using <h:column>. Assuming that Entity is a fullworthy javabean with 3 properties id, name and value, here's an example how you can render a dynamically sized HTML table out of it:

<h:dataTable value="#{bean.entities}" var="entity">
    <h:column>#{entity.id}</h:column>
    <h:column>#{entity.name}</h:column>
    <h:column>#{entity.value}</h:column>
</h:column>

DataTable in Wicket

A data table builds on data grid view to introduce toolbars. Toolbars can be used to display sortable column headers, paging information, filter controls, and other information.

Data table also provides its own markup for an html table so the user does not need to provide it himself. This makes it very simple to add a datatable to the markup, however, some flexibility. (from Wicket 1.4.18 Javadoc)

22197 questions
3
votes
6 answers

IListSource does not contain any data sources

So what does this exactly means? Some advised that to circumvent around this error, only bind a gridview to a dataset when the rows count of the datatable is greater than zero. but how about if for example your search yielded no record returned, so…
Batuta
  • 1,684
  • 17
  • 48
  • 62
3
votes
1 answer

Primefaces DataTable - Filtering [column not filtering]

I am trying this example 'DataTable - Filtering'. Everything works except for the Search all fields: textbox that filters. when i enter characters to it it doesn't filter as in the example. There is no errors or exceptions thrown. I don't undestand…
Illep
  • 16,375
  • 46
  • 171
  • 302
3
votes
1 answer

SQL/C#: DataTable to stored procedure (INSERT from user-defined table type) - Converting error

I am trying to pass my DataTable to a stored procedure. The DataTable holds the contents of an Excel sheet. The Excel sheet has two empty columns, five with text, and five with decimal numbers. The empty columns are OppdragsMVAkode and…
Ole M
  • 317
  • 1
  • 17
3
votes
2 answers

PrimeFaces DataTable - Filtering (problem running the example)

I am trying this example in PrimeFaces. I understand only the first few lines of the code.
Illep
  • 16,375
  • 46
  • 171
  • 302
3
votes
5 answers

jquery data table headers not expanding or expanding slow in some scenarios, like reloading

Data tables loads header after the body loads, its visible to user. First body loads and in few seconds header is expanding. In some cases when reload the page headers are not expanding. This is the preloaded data table. Using defer loading here. …
user630209
  • 1,123
  • 4
  • 42
  • 93
3
votes
0 answers

Full page datatable in shiny dashboard

I am trying to make a shiny dashboard with datatables that span the entire height of the page (similar to this flexdashboard layout). With my current layout, I am facing an issue where the datatables are short and do not take up the full page. How…
3
votes
4 answers

Flutter Scrollbar in vertical and horizontal axis

I have two scrollbars in my flutter project for scrolling the data table. Here are the codes. Widget build(BuildContext context) { return Scaffold( body: Center( child: Container( width:…
minathen
  • 85
  • 1
  • 1
  • 9
3
votes
2 answers

Add rows by group and fill them with zero in R with dplyr

I have a huge data frame that looks like this gene=c("A","A","A","A","B","B") frequency=c(abs(rnorm(6,0.5,1))) time=c(1,2,3,4,1,2) df <- data.frame(gene,frequency,time) gene frequency time 1 A 0.08463914 1 2 A 1.55639512 2 3 A…
LDT
  • 2,856
  • 2
  • 15
  • 32
3
votes
1 answer

datatable filter by not in

Trying to subset a datatable by values that don't match a list: DT1 = dt.Frame(A = ['a', 'b', 'c', 'd']) sel_rows = functools.reduce(operator.or_,(f.A != obs for obs in ['a', 'b'])) DT1[sel_rows, :] However this returns all the rows, I'd expect…
Rafael
  • 3,096
  • 1
  • 23
  • 61
3
votes
2 answers

How to adjust table height in flexdashboard?

I have a flexdasboard with a page that contains 1 plot then below it a table. The table currently is compressed, so whilst it shows 25 rows it has them all within a scroll option so you can only view 2 of those rows at a time. How can I change…
LN3
  • 67
  • 1
  • 2
  • 10
3
votes
1 answer

How to add minimum and maximum range filter with input field in datatable?

I have a table with multiple columns, each column has an input field to search through a particular column. But for 4 columns, which are number-based, I wanted a range filter. That means, those 4 columns will have two input fields, the first is to…
Gaurav Sharma
  • 107
  • 1
  • 7
3
votes
4 answers

QTP datatable operations *extremely* slow (much better under MMDRV batch executor)?

Possibly a smashing story -- QTP seems to waste our worktime for no reason: Consider this script, having a datatable of exactly one global row with 26 columns named "A" to "Z" filled with any value: Print "Started" Services.StartTransaction…
TheBlastOne
  • 4,291
  • 3
  • 38
  • 72
3
votes
2 answers

C# data table to hold tables (infinite nesting)

I'm relatively new to C# - but come from a C/C++ background. I need a data type (class) that is similar to DataTable, but allows the stored columns to hold "simple" types (int, float, boolean, [string]) AS WELL as data of the same type (so that a…
oompahloompah
  • 9,087
  • 19
  • 62
  • 90
3
votes
2 answers

How to make sort with International characters in dataTable

I am trying to make my sort working with international characters. However is messed up when I try to sort, the order is not right. Below is my code: function character_substitute(string) { var first_char = string.replace( /<.*?>/g, ""…
Ivan Nukli
  • 57
  • 4
3
votes
2 answers

What does this { ! } mean in the specific line of code?

I was reading a block of code, which reads an Microsoft access database schema. Between others i saw that line of code in a loop ColName = SchemaTable.Rows(i)!COLUMN_NAME.ToString Why the exclamation mark is used for { ! }?
OrElse
  • 9,709
  • 39
  • 140
  • 253
1 2 3
99
100