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.

Filter by
Sorted by
Tagged with
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?
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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.
user avatar
  • 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"); ...
user avatar
  • 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") + "' &...
user avatar
  • 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 ...
user avatar
  • 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 = ????
user avatar
  • 2,047
12votes
1answer
26kviews

List<T> to DataView

How to convert List to a dataview in .Net.
user avatar
  • 5,775
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 ...
user avatar
  • 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 "...
user avatar
  • 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 ...
user avatar
  • 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) ...
user avatar
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(...
user avatar
  • 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....
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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) { ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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. ...
user avatar
  • 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. ...
user avatar
  • 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....
user avatar
  • 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 ...
user avatar
  • 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> <...
user avatar
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 ...
user avatar
  • 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 (...
user avatar
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. ...
user avatar
  • 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....
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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', ...
user avatar
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....
user avatar
  • 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 ...
user avatar
  • 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 = '...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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"; ...
user avatar
  • 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 ...
user avatar
  • 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,...
user avatar

15 30 50 per page
1
2 3 4 5
15