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" <ag***@dynamictech.com.hk>

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

[Agnes]

Cor, You want me to review my old post ? Why ? What do you mean ?
"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:Om**************@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...

Agnes,

See this messages to you in this newsgroup

http://tinyurl.com/6bpam

Cor

"Agnes" <ag***@dynamictech.com.hk>

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]

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

Cor

"Agnes" <ag***@dynamictech.com.hk>
...

Cor, You want me to review my old post ? Why ? What do you mean ?
"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:Om**************@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...

Agnes,

See this messages to you in this newsgroup

http://tinyurl.com/6bpam

Cor

"Agnes" <ag***@dynamictech.com.hk>

> 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
>
>