Better method to input data from one Table into dataset ?

  • Thread starter Thread starter Agnes
  • Start date Start date
A

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
 
Because that is about the dataadapter, what is normally the most simple way
to load a datatable.

Cor
 
Back
Top