Question on dataadapter

[Agnes]

in my dataadapter's command text, I only select the current month records
and then use binding manager to bind it.
The user can press'button' to move forward or backward to that record.
I need to do another search button to let the user search the old records
and amend it . (user need to input specified docno. e.g invoiceno)
My question, How can i do this approach ?
Should option(1) I create another datadapater with another commandtext ? and
then fill in the same dataset ?
Option (2)or clear the original dataset , then fill in that particular
records ???

Please give some advice.

 

[Guest]

If you are going to use the same form and buttons to move between the
searched records then surely you will have to use the same variable name for
the DataSet. Dispose the existing DataSet, fill it again and then do whatever
it is you do to display your data.

Hope this helps.
Chris.