Here's the code : try { string strReadDataLine; strReadDataLine = sr.ReadLine(); while (strReadDataLine != null) { string[] strReadDataLineSplited = strReadDataLine.Split(';'); DataRow thisRow = thisDataSet.Tables["Repartition"].NewRow(); ...
In writing some tests for a project I'm working on, I found that the best way for me to get the data back I needed about whether the project was correct was to put results into an ADO.NET DataTable. I got sick of setting breakpoints and waiting for them to be hit so that I could use the DataSet Visualizer to see what my results were, an...
Hi, I want to allow my application to allow import of data through XLs files. I already do this with CSV files and XML files, but would like to open the scope for users. I am having trouble with the loading of the file. We load the files (XLS,CSV,Xml) into a data set and work on it from there. The loading code for XLS is below ...
I'm looking for a tool that will let me generate a data set with certain statistical properties. For example, suppose I want to generate 1 million integers with x number of outliers for use in testing. Are there any tools for generating test data sets like this? I don't necessarily need anything fancy, just some basic functionality. ...
I am refactoring an existing VB.NET application to use Linq. I've been able to successfully get it to work, but it takes ages (over a minute) on the client machine! They have lots of rows in the database table, but the old version of the programme on the same machine (which uses Datasets) takes 5 seconds. My Linq queries are pretty st...
I am using framework 2.0, and I don't understand how the datagrid and the datasets works after doing a postback. In msdn says that there's no need to do a databind again if the request is a postback. But my question is: how the datagrid shows again the records if there is no databind? I supose that asp.net saves in a cache the query resu...
I have a dataset with a number of data columns, due to sizing issues I've updated a number of the varchar columns from say VARCHAR(20) to VARCHAR(50). I'd like the DataTable to automatically grab the new column information, is this possible? I'd rather not go through each column in the table and update the length. ...
Could extension method be used for DataColumn.Expression to support for example the replace function ? If yes, any sample code available somewhere ? Thanks. ...
Is it possible in C# to use an OleDbAdapter and use its Update method for a dataset when a table has no primary key and how can I do this? ...
Hello, I am preparing a new Windows project and wonder what kind of DAL technology to use. Originally I was looking for something simpler to not spending too much time on building it. But I understand also that it has to be efficient and scalable in the long run. I plan to use WPF (MVVM) Client and WCF Service on a 3 Tier system. Just...
hi I thought I can fill a typed dataset , which I created like this: The name of the table is HouseInformation In design mode I created a column NameOfHouse and Price. Is it not possible to fill the columns directly? like... dsWincObjects dsHouse = new dsWincObjects(); dsHouse.NameOfHouse = "value"; and and... or option I thought...
Hey all, I'm trying to build a strongly-typed dataset in ADO.Net and am having a little trouble with one aspect of the TableAdapters. My query looks like SELECT * FROM testdict.ModuleVariable WHERE Module = ? My problem revolves around the testdict part. We use several different schemas to access our data (because of a multiplexed ...
The following code: DataSet ds = new DataSet; ds.ReadXml("c:\output\" + nome); GridView1.DataSource = ds; GridView1.DataBind(); succeeds in getting the fields from the XML, but as default it only displays the three first fields (this XML specially may have about 60 fields, of which i wish to gather 3 or 4 of them) how do i take off t...
i have loaded an xml file to a dataset successfully (i can display it in a datagrid), i'd like to load it in several textboxes (about 10 or 12). the xml has about 60 fields, and i'm not that familiar with getting their names (though i know which ones i want). that's what i have: Dim ds As New DataSet ds.ReadXml(<PATH>) a glim...
What is the best way for me to have several datasets ? i've thought about creating a routine for creating datasets with a number in their names, each one with the desired data, but that's not very intelligent (although might work) i'd like to create what would be like an "ARRAY OF DATASETS" vb: <whatever> = ds(1).<whatever> <whatever>...
I would like an automated way to run compile time checks on datasets (or any xml) to make sure that expected values are found for certain properties. I have a fairly complex dataset in my asp.net Web Site. After modifying a query Visual Studio regenerates the tableadapter object and returns many properties to their default values. Thi...
On my main window I have a DataGridView that I wish to display my data. My application allows users to input, change, and delete data. I asked my friend the best method of doing this he said storing the information in an XML file. So now I am wondering on HOW to use XmlSerializer. Can I make an XML document or DataSet and give it values,...
I have created three data tables by pulling data from an sql database. DT1, DT2, DT3. I have added these three tables to a data set, myDS. I have added relations between these three tables. I then dragged a DataGridView onto my form and I want to bind the three tables to the DataGridview. So I added my dataset DS to a dataview ma...
I have DataSet. it returns date, and value by date. for ex: 01.01.2009 454 02.01.2009 785 03.01.2009 475 ---------- --- 30.01.2009 523 I need new DataSet, that group by week. for ex: 1 Week 1-7 2017 2 Week 7-15 4586 ----------------- 5 Week 24-30 1482 Week begin from monday. not importand only for this example, i...
Hi, short question: Refering to http://stackoverflow.com/questions/170455/how-can-i-read-multiple-tables-into-a-dataset#answer-366402 My App has a db factory. Can i use 'da.Fill(ds)' [with IDataAdapter implementation] for multiple tables? Or how can i add more tables to the same DataSet. Copy the whole table would work but is this the o...