Strongly typed Datasets and explicit cast..

[Oscar Thornell]

Hi,

I have a general all purpose class that can take the name of a stored
procedure and return a dataset...

This general dataset that is returned I wish to cast to a strongly typed
dataset of my choosing.
I have the XML Schema and a generated specialization of the DataSet that I
wan´t to cast to...

Generated by xsd.exe
public class MyStronglyTyped DS : DataSet {
....
}

My app code: (wich causes Invalid Cast Exception...)

MyStronglyTyped DS ds = (MyStronglyType dDS) obj.GetDataSet( "MyStoredProc") ;
My DAL code:

public DataSet GetDataSet(stri ng sproc) {
....
return ds;
}

I would rely appreciate some feedback!
Thanks

/Oscar

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

Oscar,

You can not do this. What you have to do is get the contents of the
dataset into some other medium (string, stream, file, etc, etc), and then
create a new instance of your typed dataset. Once you have that, you should
be able to load the contents of the other dataset in that medium (using
ReadXml, most likely), and then it will populate the new typed dataset
appropriately.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Oscar Thornell" <os***@cyberode .se> wrote in message
news:up******** ******@TK2MSFTN GP11.phx.gbl...

Hi,

I have a general all purpose class that can take the name of a stored
procedure and return a dataset...

This general dataset that is returned I wish to cast to a strongly typed
dataset of my choosing.
I have the XML Schema and a generated specialization of the DataSet that I
wan´t to cast to...

Generated by xsd.exe
public class MyStronglyTyped DS : DataSet {
...
}

My app code: (wich causes Invalid Cast Exception...)

MyStronglyTyped DS ds = (MyStronglyType dDS) obj.GetDataSet( "MyStoredProc") ;
My DAL code:

public DataSet GetDataSet(stri ng sproc) {
....
return ds;
}

I would rely appreciate some feedback!
Thanks

/Oscar

[Roman S. Golubin]

Hi, Oscar Thornell

I have a general all purpose class that can take the name of a stored
procedure and return a dataset...

This general dataset that is returned I wish to cast to a strongly typed
dataset of my choosing.
I have the XML Schema and a generated specialization of the DataSet that I
wan´t to cast to...

Generated by xsd.exe
public class MyStronglyTyped DS : DataSet {
...
}

My app code: (wich causes Invalid Cast Exception...)

MyStronglyTyped DS ds = (MyStronglyType dDS) obj.GetDataSet( "MyStoredProc") ;

Try

MyStronglyTyped DS ds = new MyStronglyTyped DS();
ds.Merge(obj.Ge tDataSet("MySto redProc"));

Hope this helps.

--
Roman S. Golubin
ICQ UIN 63253392
go************* ****@arhcity.ru