Hi. I'm developing an application that as to export a dataset to excel, this dataset have 3 tables and the relation between them, I would like to export this to a single excel sheet where for each parent table there is a '+' sign that when expanded shows the child values related to it. To export a single table to excel I know how to do i...
using a dataset,each row has a method called hasVersion() which implies to me it keeps a copy of the original and current versions of that row. How can I get one of the original row values? I'd imagine it's possible to call reject changes on that row and then check the value, but I'd rather not lose the changes, just read the value(s)....
Hi. I have a (disconnected) typed Dataset in an XML, which I query in LINQ: var productlist = from prds in dsProducts.Products.AsEnumerable() where (prds.Field<string>("productid").Contains(searchpattern) || prds.Field<string>("productname").Contains(searchpattern)) select prds; This list is fine, but if I try to say: return ...
I have a C# Windows Forms application, whose prototype was created on SQL Server (strongly-typed dataset). In its final version, the application must be able to work over SQL Server, MySQL or Oracle. Now I am wondering which parts (if any) can be reused from the prototype. 1. Dataset (typed) ? 2. TableAdapters? (probably not, they conta...
In C#, is it possible to get all values of a particular column from all rows of a DataSet with a simple instruction (no LINQ, no For cicle)? ...
I have the exact same question as this one: http://stackoverflow.com/questions/831519/aggregate-functions-in-ado-net-with-group-by-functionality/1084230 however the proposed solution was for .net 3.5 but I am using .Net 2.0 so I cant the LINQ query. To summarize: I have a DataSet and I want to create a view from it and apply something s...
So I had an architect on a previous project who railed against Datasets. He hated them, and said they had no place in a web application, specifically a web app which will have a lot of traffic. I've noticed in many instances of code I've taken over that Datasets are used quite heavily. Are they really that bad/performance killing? Sh...
Trying to use a typed dataset with nullable fields... As been the case since the dawn of time, the typed dataset generator of visual studio does not support nullable types. Is there, somewhere in the net, a generator for a properly typed dataset? Thank you. ...
I would like to be able to use a Dataset as an in-memory datastore. I want to be able to use SELECT, INSERT, UPDATE, and DELETE, CREATE TABLE, DROP TABLE, ALTER TABLE ADD COLUMN, ALTER TABLE DROP COLUMN, and support for Constraints PRIMARY KEY, UNIQUE, NOT NULL, FOREIGN KEY, REFERENCES. ...
Using EF, is it possible to create the model from a disconnected dataset? Keep in mind that there is no "database", only a dataset. ...
Lots of web sites offer this data (see http://www.google.com/search?hl=en&q="average+temperature"+by+zip+code) but I don't see the dataset they are using. I looked at the national weather service for a bit (see for example http://www.rdc.noaa.gov/~foia/index.html#electronic), and didn't see it. NWS is in the National Oceanic and At...
I used DataSet to load a schema from following xml file; <node id="0"> <node id="1"/> </node> Then I cleared this dataset and filled data in. When I tried to invoke WriteXml method of my dataset, it threw a exception said: Cannot proceed with serializing DataTable "node". It contains a DataRow which has multiple parent rows on th...
Hi In datasets there was a method WriteXml or ReadXml Does anyone have any idea on how to this with Entity Framework? Has anyone implemented this before? ...
I am using DataSets for access to Sql Server 200x in a C# project. Our common practice is, in almost all tables, to not delete the record. Instead we have a field which simply holds a bit for whether the record is deleted. I can manually edit each table in the DataSet and make their select command include Where Deleted = 0 and the del...
Here is my ultimate goal... to take this xml file.. <?xml version="1.0"?> <Songs> <Song> <Name>Star Spangled Banner</Name> <Artist>Francis Scott Key</Artist> <Genre>Patriotic</Genre> </Song> <Song> <Name>Blankity Blank Blank</Name> <Artist>Something Something</Artist> <Genre>Here here</...
Hello Since Embarcadero's NNTP server stopped responding since yesterday, I figured I could ask here: I work with a non-DB-aware grid, and I need to loop through a dataset to extract the number of columns, their name, the number of rows and the value of each fields in each row. I know to read the values for all the fields in each row, ...
What is the best way to save data in session variables in a classic web site? I am maintaining a classic web site and want to be able to allow my users to demo all functionality of the site, this means allowing them to delete records. The closet example I have seen so far are the demos of Telerik controls where they are saving the data...
Hi, How do you take a couple of data tables and put them in a dataset and relate (that doesn't even sound like correct English) them? I know how to create datatables. Thanks R. ...
Hi, I have a parent table called Publication and a child table called Owner. These two (data)tables are contained within a DataSet (this is all C# stuff) and have a defined relationship. One publication can have more than one owner. I am using a GridView control and my question is, how do I get the information in the child table to s...
Hello, 1) A) DataSets can be 10+ times slower than DataReader at retrieving data from DB. I assume this is due to overhead of DataSets having to deal with relations etc. B) But is the speed difference between DataSets and DataReader due to DataSets having to retrieve more data ( information about relations ... ) from DB, or due ...