How to clear columns record for dataset search query??

[HOTFIX]

well, for starters you should NEVER be using a reader to execute an action query like that. You should be using .ExecuteNonQuery ... that's what it is designed for.

as for clearing dataset columns... that could mean a couple things... what is it you are trying to do?

-tg

Hi TG..

Thanks for the advice about using .ExecuteNonQuery

For the dataset clearing I’m trying to do the following scenario:

I’ve got DGV which showing the complete database as dataset1, after doing a search by command button ; the results will be shown in the same DGV as dataset2,now I want to clear a specific columns in the dataset2 by pressing a button…

Any idea...

Regards…