Short question: does anyone have any information about what the memory performance of Linq is with large amounts of data? Specifically Linq to Datasets or Linq to Objects. What is the largest number of records / objects it can handle? What is the memory overheads? Can anyone post some ballpark memory usage figures? Background My compa...
I'm developing a search form. It has about 10 fields and a search button that retrieve records from a table and put them in a gridview. The user can fill some fields, all the fields or none, and then click Search. Only the fields with info has to be used to perform the search. I use a query in a tableadapter of a dataset to make the sea...
I'm trying to decrypt an encrypted XML file and put it into a stream then load it into a dataset. I am able to do this if I decrypt the file, and write it back as a file. Then do the Dataset.ReadXML method. However, so I don't defeat the purpose of the encryption I'd like to leave it in memory. I see that .ReadXML does accept a syste...
(Using Visual Studio 2005 / .NET 2.0) I have a DataSet which is being prepopulated from another module using SQL. All the values in it are fine and will stay the same as they are. But once I retrieve the DataSet (and assign it to a DataTable since it is a one-table set) I need to add an additional column onto the end of the DataTable a...
How do I pull a single column of data out of a filled dataset? I have a filled dataset object, with a variety of tables. I need to get all of the data that is stored in a particular column in one of the tables, and bind a ComboBox ItemSource to it. (This may require me to pull the data out and make it into a string collection ...) ...
i know this has been asked here. But my question is slightly different. When the dataset was designed keeping the disconnected principle in mind, what was provided as a feature which would handle unexpected termination of the application, say a power failure or a windows hang or system exception leading to restart. Say the user has enter...
Hi; dsrm_usersTableAdapters.rm_usersIPTableAdapter _tuser = new dsrm_usersTableAdapters.rm_usersIPTableAdapter(); dsrm_users _dsuser = new dsrm_users(); _dsuser.EnforceConstraints = false; dsrm_users.rm_usersIPDataTable _muser = _dsuser.rm_usersIP; _tuser.FillBy(_muser, _IP); it is very good works; However, when I use ObjectDataSou...
I was trying to store the url on button click using the following code.There were no error but the required url is not sroeing in my column field (i used ntext data tpe for this).Please help me if there was some mistake in my code public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs ...
I've got a Winform app that will be used in the US and China. The SQL Server 2005 database is in the US, so the data access is going to be slower for the people in China. I'm deciding between using a DataReader and a Dataset for best performance. The data will immediately be loaded into business objects upon retrieval. Question: Which p...
Hi, I have a dataset that is populated by reading excel file. The dataset stores the data from the excel. The date in the dataset in in the format "2\2\2009 12:00:00 AM" but i need the data format converted to "2\2\2009" . I want to change the format of all the data in that particular column. Please help. ...
Hi, Does anybody know of good tools/plugins to organize the dataset designer in Visual Studio 2008? Right now it's a big jumble of TableAdapters without relationship views - it would be very cool if there was a tool available that could organize it, kinda like how it's done in SQL Server Management studio's 'Diagram' pane. Cheers, WT ...
VS 2008 in vb.NET Hi, I have a manually created a dataset (dsPickingList) that I add data too as the user inputs data on a form. There is a datagridview on my form of which it's datasource is set to dsPickingList. What I would like to do is spot if a user deleteds a row from the datagridview and update the dataset (dsPickingList) as i...
Having a problem adding a table to a dataset, watching in debugger I read xml file into datatable all looks fine, when add datatabe to dataset table/dataset ( using dataviewer ) first record looks good remaining records/fields contain a red ! mark. fs = new FileStream(Server.MapPath(GlobalVar.compathver), FileMode.Open, FileAccess.Read...
Hi there. I'm using v.s 2008 with c#. I have a .xsd file and it has a table adapter. I want to change table adapter's command time. out. Thanks for your helps.. ...
Hi, At work we use typed dataset in some projects for our DataAccess layer. Sometimes we extend them using the partial class feature : using View code on a dataset create a DataSetName.cs with the partial class declaration where you can add code. Inside this file we also add the TableAdapter partial class. Recently we migrated on Visua...
When a typed DataSet is written to XML using ds.GetXml the columns with null values are removed from the XML. I know this is because the schema is not written etc. but is there a way to override this without having to parse through the DataSet and convert all database nulls to empty string before writing the XML? EDIT: additional info...
We have a .NET 2 SOAP web service meant for consumption by another app that is internal to our organisation. The web service returns a .NET dataset like so: public System.Data.DataSet GetStatementFor(string contractList, System.DateTime startDate, System.DateTime endDate) Now in one of the use cases it is necessary to get to the Dat...
I have an XML document as below: <?xml version="1.0" encoding="utf-8" ?> <Providers> <Provider> <ProviderType>Email</ProviderType> <ProviderTitle>MyProviderTitle</ProviderTitle> <DeliveryRules> <PersonalDelivery>true</PersonalDelivery> </DeliveryRules> <ProviderConfiguration> <SendTo> ...
I have a dataset that I read in from a complex xml structure.... here is a basic version of it, for the sake of the question <cars> <car> <carName>Golf</carName> <engine> <model></model> </engine> <//car> <car> <carName>Dodge</carName> <engine> <model></model> </...
The arXiv e-print archive has several terabytes of papers from various fields of science. Some users would like to maintain a full copy of this data on their own computers, while others just want to download the most recent papers in a particular category. They are looking to reduce bandwidth load using some kind of distributed downloa...