Questions tagged [dataview]
A dataview is a .net class which represents a databindable, customized view of a DataTable for sorting, filtering, searching, editing, and navigation. The DataView does not store data, but instead represents a connected view of its corresponding DataTable. Changes to the DataView’s data will affect the DataTable. Changes to the DataTable’s data will affect all DataViews associated with it.
721
questions
60votes
4answers
121kviews
Looping through rows in a DataView
The DataView object doesn't have a Rows property like DataTable.
How do I loop through the rows of a DataView?
- 57.6k
45votes
6answers
31kviews
How to use GWT 2.1 Data Presentation Widgets
At the 2010 Google IO it was announced that GWT 2.1 would include new Data Presentation Widgets. 2.1M is available for download, and presumably the widgets are included, but no documentation has yet ...
- 30.3k
36votes
3answers
5kviews
Read id3 v2.4 tags with native Chrome Javascript/FileReader/DataView
Based on the answer of ebidel, one can read id3v1 tags by using jDataView:
document.querySelector('input[type="file"]').onchange = function (e) {
var reader = new FileReader();
reader.onload ...
- 15.8k
21votes
5answers
25kviews
C#: Custom sort of DataGridView
I need to sort a DataGridView with Natural Sorting (Like in Explorer) so that numbers and text (in the same column) are sorted naturally, and not alphabetically (so that "place 3" comes before "place ...
- 145k
19votes
2answers
55kviews
Easiest way to copy a dataview to a datatable in C#?
I need to copy a dataview into a datatable. It seems like the only way to do so is to iterate through the dataview item by item and copy over to a datatable. There has to be a better way.
- 1,138
15votes
5answers
49kviews
How to bind dataGridView predefined columns with columns from sql statement (without adding new columns)?
Is there a elegant way, to bind predefined dataGridView columns with results from a SQL statement?
Example:
dataGridView1.Columns.Add("EID", "ID");
dataGridView1.Columns.Add("FName", "FirstName");
...
- 679
14votes
3answers
44kviews
Compare dates in DataView.RowFilter?
I am scratching my head over something rather stupid yet apparently difficult.
DataView dvFormula = dsFormula.Tables[0].DefaultView;
dvFormula.RowFilter = "'" + startDate.ToString("yyyyMMdd") + "' &...
- 13.7k
14votes
2answers
39kviews
Sorted dataview to datatable
I have the following method:
private DataTable getsortedtable(DataTable dt)
{
dt.DefaultView.Sort = "Name desc";
//I would need to return the datatable sorted.
}
My issue is that I cannot ...
- 2,544
13votes
4answers
27kviews
How Can Convert DataRow to DataRowView in c#
Can or how to convert DataRow to DataRowView?
For example:
DataTable dt=ds.Tables[0];
DataRow dr= dt.NewRow();
DataRowView drv = ????
- 2,047
12votes
1answer
26kviews
12votes
3answers
13kviews
making rows distinct and showing all the columns
In my project there are two datatables dtFail and dtFailed (dtFailed has nothing but column names declarations). dtFail has duplicate "EmployeeName" column values. so i took a dataview dvFail and did ...
- 38.7k
11votes
4answers
19kviews
Create ADO.NET DataView showing only selected Columns
In C# & .NET, can one create a DataView that includes only a proper subset of the DataColumns of a given DataTable?
In terms of relational algebra, one assigns a RowFilter in order to perform a "...
- 2,335
10votes
3answers
44kviews
How do I check for blank in DataView.RowFilter
Assuming I have a column called A and I want to check if A is null or blank, what is the proper way to check for this using the DataView's RowFilter:
DataTable dt = GetData();
DataView dv = new ...
- 44.1k
10votes
4answers
21kviews
Sorting a List<FileInfo> by creation date C#
Using this example off MSDN:
using System.Collections.Generic;
using System.IO;
namespace CollectionTest
{
public class ListSort
{
static void Main(string[] args)
...
- 3,137
9votes
4answers
69kviews
How to get a value from a column in a DataView?
I have a dataview defined as:
DataView dvPricing = historicalPricing.GetAuctionData().DefaultView;
This is what I have tried, but it returns the name, not the value in the column:
dvPricing.ToTable(...
- 44.1k
9votes
4answers
9kviews
Is there a reference for the SharePoint XSLT extension functions?
There are a couple of different .NET XSLT functions that I see used in the out of the box SharePoint web parts (RSS Viewer and Data View web part).
<xsl:stylesheet
xmlns:ddwrt="http://schemas....
- 45.4k
8votes
2answers
8kviews
How to merge multiple dataviews into one?
I have three dataviews (dataview1, dataview2, and dataview3). These are of type System.Data.DataView, and all three have the same columns. Is there an easy way to merge them into one, so I have one ...
- 12.4k
8votes
3answers
3kviews
Stacked barplot in UpSetR
I have been looking for a way of having a stacked bar plot in an upsetR graph.
I downloaded the movies data set (from here) and added a column having only two values "M" and "C".
Below, information on ...
- 445
8votes
1answer
12kviews
LEFT JOIN in Dynamics AX View
Does anyone know how to do a LEFT OUTER JOIN in a Dynamics AX View from the AOT (not a programmatically-created query).
Can't seem to find a way to do anything other than an INNER JOIN, and the ...
- 1,357
6votes
1answer
29kviews
Missing operand after 'Operator Name' operator
I am filtering my gridview using dataview. I am passing the filter command to dataview as mentioned below;
string strFilter= " 0=0 ";
if (Session["SampleSession"] != null)
{
...
- 16.5k
6votes
2answers
12kviews
How to set RowFilter case-insensitive for DataView
I have a datagrid, its datasource is a dataview. There is a textbox with which users can type in filter text. I want to make the filter to be case insensitive.
say, the typed text is "Tg"
I tried ...
- 2,209
6votes
1answer
14kviews
Receive an ArrayBuffer on WebSocket (ws) [duplicate]
I would like to handle ArrayBuffer messages received from the client using ws. Client-side, I directly receive an ArrayBuffer thanks to ws.binaryType, but server-side, I don't receive an ArrayBuffer ...
- 311
6votes
2answers
11kviews
Dynamic tooltip depending on mouse over on a row in a datagrid(NOT datagridview)
I am trying to make it so that when the user mouses over a row in my DataGrid / dataview, each row would display a different tooltip outcome.
I cannot really figure this out. with DataGrid how can I ...
- 766
6votes
2answers
2kviews
Why does DataTable.Select() return the wrong rows?
The DataTable.Select() function returns the wrong rows with a filter like this...
"booleanColumn1 AND booleanColumn2 AND GuidColumn1 = '00000000-0000-0000-0000-000000000000')"
Making virtually any ...
- 71
6votes
2answers
6kviews
Trouble Sorting a DATE column in DataTable/DataView in C#
I am trying to Sort a DataView in C#. It seems the Sort method of DataView Class takes the dates as strings.
In the output am getting this -
5/9/2013 4:56:38 PM
5/8/2013 4:23:06 PM
5/8/2013 1:38:21 ...
- 3,155
6votes
3answers
18kviews
How to validate data input on a sharepoint form?
How does one verify a text field with another list's column? I am currently populating a Drop down list with a datasource and then comparing the text field with items in the dropdown using javascript. ...
- 216
6votes
1answer
3kviews
SlickGrid RemoteModel vs. Dataview Model
We're currently using the slick.remotemodel.js model implementation of SlickGrid for its remote Ajax loading functionality. With this example the only filtering provided is a simple Search element. ...
- 71
5votes
2answers
14kviews
Select top N rows AFTER sorting from Dataview in c#
I have a DataTable with 10 rows say one of the columns
numbered 1 to 10 randomly.
I want to sort them. usually, I do this:
DataView Dv = new DataView(dtPost, "", "views desc", DataViewRowState....
- 5,283
5votes
1answer
4kviews
Updating a single cell (not the entire row) in slickgrid with DataView
I have a slickgrid (using a DataView) that I'm using to display rapidly changing values. As far as I know, when a value changes in the underlying model, the only choice I have is to update the entire ...
- 163
5votes
1answer
2kviews
How do I display the property name in the group header in wpf
<!-- GroupHeaderStyle -->
<Style x:Key="GroupHeaderStyle" TargetType="{x:Type GroupItem}">
<Setter Property="Template">
<Setter.Value>
<...
- 429
5votes
5answers
22kviews
How to create a dataview In Sharepoint with data from a join query?
I have 3 Lists in Sharepoint.
I want to create a dataview that is a join of 3 tables.
Table1 is joined with Table2 on FieldA
Table 2 is joined to Table3 on FieldB
Table1 has duplicate values in ...
- 216
4votes
5answers
54kviews
SELECT DISTINCT in DataView's RowFilter
I'm trying to narrow down the rows that are in my DataView based on a relation with another table, and the RowFilter I'm using is as follows;
dv = new DataView(myDS.myTable,
"id IN (...
- 5,054
4votes
2answers
5kviews
Add One DataView to Another in C#
I need to add two DataViews together to have one Dataview that can then be bound to a Repeater.
I am plugging into someone else's API so I can't change the way the data is retreived at the SQL Level. ...
- 1,245
4votes
1answer
12kviews
How to get data after DataView filtering?
I apply a filter to Dataview and after that I need to get the filtered data.
before filtering I did:
dvUnloadOpenAccounts.RowFilter = "uso_id = '30640'";
foreach (DataRow row in dvUnloadOpenAccounts....
- 1,119
4votes
3answers
3kviews
DataTable sorting with Datacolumn Name with comma
I have data table showing statistics of different cities for different periods. It has following columns names
Period | city1,state | city2,state | city3,state
Jan 15 25 ...
- 1,674
4votes
2answers
2kviews
Data browser for R similar to Stata
I'm new to R with a background using Stata.
I am wondering if there is a real-time browser to see how data changes after executing codes, much like the Data Browser in Stata.
I've consulted previous ...
- 141
4votes
1answer
301views
Why is Javascript TypeDArray not working?
I have 4 bytes ArrayBuffer and I assigned a number at the index 0 using dataview. When I try to get the value using dataview that gives result correctly but it does not give correct result when I try ...
- 43
4votes
1answer
1kviews
Convert Sorted DataView to Typed DataTable
i have a strong typed DataTable named Account wich i sorted on Account.FullName:
DataView dvAccount = new DataView(dtAccount)
dvAccount.Sort = "FullName desc";
The fullname is a generated field ...
- 333
4votes
2answers
10kviews
How to Naturally Sort a DataView with something like IComparable
My DataView is acting funny and it is sorting things alphabetically and I need it to sort things numerically. I have looked all across the web for this one and found many ideas on how to sort it with ...
4votes
1answer
3kviews
Remove empty columns from DataTable/DataView
I have a DataTable that returns data from a stored-procedure (it's generated by a dynamic pivot statement, but I don't think that is relevant). The returned data may have columns without data. How can ...
- 11.8k
4votes
3answers
10kviews
What SQL query or view will show "dynamic columns"
I have a table of data, and I allow people to add meta data to that table.
I give them an interface that allows them to treat it as though they're adding extra columns to the table their data is ...
- 89.4k
4votes
2answers
5kviews
Sencha Touch DataView not showing items from Store
I'm using Sencha touch 2. I have store that load from existing js object:
Ext.define('majestic.store.Dataset', {
extend : 'Ext.data.Store',
requires : [
'majestic.model.Dataset',
...
- 6,153
4votes
1answer
411views
How can we make the DataView Control respond to javascript events?
If I had an ASP.NET 4.0 DataView control that looked like below, how can I control javaScript events on the client side?
Body tag:
<body xmlns:sys="javascript:Sys" xmlns:dataview="javascript:Sys....
- 6,671
4votes
3answers
2kviews
DateTime filtering in DataTable.DefaultView.RowFilter
I have tried to filter the DateTime column from a DataTable using RowFilter and the column contains the Date with the Time.
I have tried like below,
dataView.RowFilter = "[Date] = #6/26/2011 2:53:24 ...
- 141
3votes
4answers
20kviews
Missing operand after '=' operator
I have this line of code which uses a dataview view_1 and I'm trying to filter the datagridview by product_name and its size using the RowFilter.
Here is the code:
view_1.RowFilter = "product_name = '...
- 377
3votes
4answers
24kviews
dataview rowfilter value to datatable convertion
I want to convert dataview rowfilter value to datatable. I have a dataset with value. Now i was filter the value using dataview. Now i want to convert dataview filter values to datatable.please help ...
- 360
3votes
1answer
2kviews
WPF datagrid hide column with dynamic datasource
I'm binding a datagrid to a DataView. I would like to hide the ID column when the data is displayed. The ID column needs to exist in the data as it is used in another part of my code.
The ID column ...
- 1,917
3votes
4answers
13kviews
How to sort a DateTime-column in DataView?
I have a gridview with some columns and I need to sort the gridview by a date-column. But I fail in sorting it correctly. This is the code that I use:
dt.DefaultView.Sort = "Meldingsdatum asc";
...
- 9,153
3votes
2answers
9kviews
New DataView vs. DefaultView of a DataTable
Why would you construct a new DataView instead of using the DefaultView of the DataTable in C#?
What are the scenarios creating a new DataView is preferable?
What are the advantages and ...
- 468
3votes
3answers
3kviews
DataView LIKE function on Integer value
I have Sql table Tracks which keeps track information such as TrackID and TrackName. I have c# application with textbox and listbox. I use dataSet to retrieve sql table and when I write "3" on textbox,...
- 553