do i ever have to clear the table contents in my dataset if i do a new search? becaus if i use
adap.fill(ds,"table1)
it fills the table with the search results, but if i search again it doesnt empty the table1, its adding the new resulst to the end of the table, so i get more and more data in the table but not the last search results?
i tried this to clear the table out
ds.tables("table1").clear()
is there another way to populate a datatable only with the results no more no less?
adap.fill(ds,"table1)
it fills the table with the search results, but if i search again it doesnt empty the table1, its adding the new resulst to the end of the table, so i get more and more data in the table but not the last search results?
i tried this to clear the table out
ds.tables("table1").clear()
is there another way to populate a datatable only with the results no more no less?
