Better method to input data from one Table into dataset ?

[Agnes]

Now, i need to query some data from InvoiceTable and then put into one
dataset.
my way is using store procedure ,
1.by passing date,company code to the store procedure)
2. use datarow to loop the execute reader ,
3 . for each datarow, i need to put a new voucherno
(myRow.item("voucherno") = no
4. myNewTable.import(myRow)

I am wonder is there any better way to do that ?
Thanks a lot

 

[Cor Ligthert]

Agnes,

See this messages to you in this newsgroup

http://tinyurl.com/6bpam

Cor

 

[Agnes]

Cor, You want me to review my old post ? Why ? What do you mean ?

 

[Cor Ligthert]

Because that is about the dataadapter, what is normally the most simple way
to load a datatable.

Cor