Winan,

To clear the DataSet, you would call

MyDataSet.Clear();

The filling of the DataSet is calling the Fill method of your DataAdapter

MyDataAdapter.Fill(MyDataSet,"MyTable");

>Thanks Cathi, but I am not sure that I already understood what you mean exactly .. could you please give me a very simple example ? .. many thanks in advance
>
>Regards
>Winan