Ccopying a datatable content from an untyped dataset into a table which is inside a typed dataset

N

Nedu N

Hi All,
I am facing problem in copying content of table from a untyped dataset into
to a table inside the typed dataset. I wanted to copy the data into typed
dataset in order to ease the further processing using typed references.

DataSet ds = getDataFromDB(); - i am getting the dataset ds from a
webservice

I have got MyXSD which decsribes the shcema for the table which i am getting
from the webservice
and i am trying to cast like following
MyXSD myds = (MyXSD)ds; ==> but giving me invalid exception error

And i tried copying the table from ds into myds like
myds.Tables[0] = ds.Tables[0];

but it is giving me error saying myds.Tables[0] is READ ONLY....

I tried ImportRow also but getting errors and i don't want to manually go
thru the rows and put into my Typed dataset..

Thanks for your help.

Nedu
 
C

Chris Taylor

Hi,

I believe (read that as I have not tried it!) that you can accomplish this
with the Merge member of the DataSet.

DataSet ds = getDataFromDB();
MyDataSet myds = new MyDataSet();

myds.Merge( ds );

For the cast to work your getDataFromDB() would have to actually be creating
a strongly typed dataset and merely return it as a generic DataSet.

Hope this helps

Chris Taylor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,444
Messages
2,571,709
Members
48,796
Latest member
Greg L.
Top