clearing and replacing data in a datatable

[Bernie Yaeger]

I first load a small amount of data into a dataset with
da.fill(ds,"customers")

Later, I want to change that data based on user input:

Me.da.SelectCommand.CommandText = "select ptype, posstatus, shipdt, bipad,
issuecode, brname, imcacct, draw, preturn, rreturn, shortage, uprice, net,
efficiency from histd where custid = " & Chr(39) & mcustid & Chr(39)

How do I clear out the first datatable in the ds and replace it with this
new command? I don't want to create a second datatable, which I know how to
do.

Thanks for any help.

Bernie Yaeger

 

[Visual Barty]

Bernie -

The dataset has a clear method that will clear all of the tables in the
dataset, I think that it will work for you.

Code snippet: ds.Clear()

Hope this helps.

Bart A. Robinson, MCP

 

[Bernie Yaeger]

Hi Bart,

Tx - that did it!

Bernie

Bernie -

The dataset has a clear method that will clear all of the tables in the
dataset, I think that it will work for you.

Code snippet: ds.Clear()

Hope this helps.

Bart A. Robinson, MCP


how