Dataset to typed dataset

[Guest]

hello
I would like to convert dataset returned by SqlHelper to a typed dataset.
How to do it ? (MyTypedDataSet) SqlHelper.ExecuteDataSet(...) doesn't work
It says wrong cast. Any other ideas ?
Jarod

 

[Nicholas Paldino [.NET/C# MVP]]

Jarod,

It's a little expensive (performance-wise), but you should be able to
call the WriteXml method on the untyped data set (writing to a memory
stream), and then create a new instance of your typed data set and call the
ReadXml method on it, reading from the stream (where you reset the stream
pointer to the beginning).

Hope this helps.

 

[Guest]

It's a little expensive (performance-wise), but you should be able to

call the WriteXml method on the untyped data set (writing to a memory
stream), and then create a new instance of your typed data set and call the
ReadXml method on it, reading from the stream (where you reset the stream
pointer to the beginning).

It doesn't work for me MyTypedDataset after ReadXML is empty.
Jarod

 

[Guest]

Jarod,

It's a little expensive (performance-wise), but you should be able to
call the WriteXml method on the untyped data set (writing to a memory
stream), and then create a new instance of your typed data set and call the
ReadXml method on it, reading from the stream (where you reset the stream
pointer to the beginning).

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

hello
I would like to convert dataset returned by SqlHelper to a typed dataset.
How to do it ? (MyTypedDataSet) SqlHelper.ExecuteDataSet(...) doesn't work

It says wrong cast. Any other ideas ?
Jarod

 

[Guest]

It's a little expensive (performance-wise), but you should be able to

call the WriteXml method on the untyped data set (writing to a memory
stream), and then create a new instance of your typed data set and call the
ReadXml method on it, reading from the stream (where you reset the stream
pointer to the beginning).

It doesn't work for me ;( The new typed dataset after ReadXml is empty
Jarod

 

[Guest]

It's a little expensive (performance-wise), but you should be able to

call the WriteXml method on the untyped data set (writing to a memory
stream), and then create a new instance of your typed data set and call the
ReadXml method on it, reading from the stream (where you reset the stream
pointer to the beginning).

Almost good but... doesn't work. But I make it work ))
So first we need to ReadXmlSchema(pathToFile)
then we need to change the table name in untyped dataset
ds.Tables[0].TableName = "OurTableName"

With this two corrects it really works
Jarod

 

[Michael Rodriguez]

hello
I would like to convert dataset returned by SqlHelper to a typed dataset.
How to do it ? (MyTypedDataSet) SqlHelper.ExecuteDataSet(...) doesn't work

It says wrong cast. Any other ideas ?
Jarod

This is how I do it:

// load the generic data from the data layer into a strongly typed dataset
dsTyped.Load(dsUntyped.Tables[0].CreateDataReader(),
LoadOption.OverwriteChanges, dsTyped.mytablename);

HTH,

Mike Rodriguez