Looking for a better way to build a Dataset - C# Discussion Boards

Re: Looking for a better way to build a Dataset

2-Mar-05 5:03

I have a situation where I need to load 8 key value pairs into a DataSet manually.

The data looks like this:

Mon -- 123.4
Tues -- 232.1
Wed -- 187.4
...
EOW -- 923.6

I have to get these values into a DataSet. Is there a better (less lines of code) way to load it into a DataSet than to create a DataTable manually?

This is what I have so far:

<br />
DataSet ds = new DataSet();   <br />
DataTable dt = new DataTable("MCDVals");<br />
dt.Columns.Add("Legend", typeof(string) );<br />
dt.Columns.Add("Value", typeof(double) );<br />
<br />
DataRow dr = dt.NewRow();<br />
dr("Legend") = "Monday";<br />
dr("Value") = 123.4;<br />
dt.Rows.Add(dr);<br />
<br />
// ... above block repeats another 7 times for the other values<br />
<br />
ds.Tables.Add(dt);<br />

Thanks,
Adam

"...practice safe hex when IM'ing"
--Shawn L. Morrissey, Managing Editor, MSDN Online ( MSDN Flash; Volume 8, Number 20, 10/4/2004)

leppie2-Mar-05 6:59

leppie

2-Mar-05 6:59

Adam Wimsatt wrote:
Is there a better (less lines of code) way to load it into a DataSet than to create a DataTable manually?

Yes, it's called Xml Smile | :)

Just load it Smile | :)

^{xacc-ide 0.0.15 now with C#, MSIL, C, XML, ASP.NET, Nemerle, MyXaml and HLSL coloring - Screenshots}

Re: Looking for a better way to build a Dataset

Samar Aarkotti2-Mar-05 7:38

Re: Looking for a better way to build a Dataset

2-Mar-05 7:38

Just load it into the XML , it is very simple. and you have lots of methods to write , save ...xml using datasets

Peter Vertes2-Mar-05 18:37

Peter Vertes

2-Mar-05 18:37

Like the other's suggested I would use XML also. In your case you are interested in the DataSet.ReadXml() and DataSet.WriteXml() methods. I would:

1) Input all the data by hand into my DataTable and then add that DataTable into a DataSet.

2) Call the DataSet's WriteXml() methods and pass a FileStream into it so you will end up with a file.

3) Now you can use that file as a template to manually change the Value tags in there.

4) When you are done with changing your Value tags you can call the DataSet's ReadXml() method, with another FileStream, to take all your data in the XML file and put it inside a DataTable and a DataSet.

-Peter

C# Application to Web

Samar Aarkotti2-Mar-05 4:42

2-Mar-05 4:42

Hi,

Can anyone tell me a way to put my Application on to a web, This is right now a stand alone application with forms ,button ,tab controls ..etc , how do i make this web enabled.

I have tried to put the code under wwwroot on IIS and created a simple html file with a button to invoke my .exe file directly , but it throws an expection for security breach, then i have removed all the security issues and tried, then i get different error.

is there a simple way to move (convert) your stand alone Application to web based

thanks
Samar

Adam °Wimsatt2-Mar-05 5:06

2-Mar-05 5:06

This[^] is a good way to go.

"...practice safe hex when IM'ing"
--Shawn L. Morrissey, Managing Editor, MSDN Online ( MSDN Flash; Volume 8, Number 20, 10/4/2004)

Anonymous2-Mar-05 5:33

Anonymous

2-Mar-05 5:33

what is that???

Adam °Wimsatt2-Mar-05 6:08

2-Mar-05 6:08

Read this[^] to find out what it is.

"...practice safe hex when IM'ing"
--Shawn L. Morrissey, Managing Editor, MSDN Online ( MSDN Flash; Volume 8, Number 20, 10/4/2004)

Samar Aarkotti2-Mar-05 7:32

2-Mar-05 7:32

Hi Adam,

I have read that and was lost , i would appreciate if someone could post a simple application with a form , and then call it from webbrowser. My aplication involves Microsoft Agent controls also with speech enabled.

samar

Adam °Wimsatt2-Mar-05 8:13

2-Mar-05 8:13

Here[^] is a code project article on the subject.

"...practice safe hex when IM'ing"
--Shawn L. Morrissey, Managing Editor, MSDN Online ( MSDN Flash; Volume 8, Number 20, 10/4/2004)

Samar Aarkotti2-Mar-05 9:16