Can someone help me i have a report screen where the user builds the select command for a DataAdapter based on the checkboxes the tick.
once they have chosen the info they want they press the preview button which runs the select command and fills a dataset. Then the datasource of the Datagrid is set to the dataset.
This works fine but if you want to run the report again say because the first one didn't have all data needed when the preview button is pressed again it clears the dataset (first i did this by rows.clear, columns.clear then i tried clearing the dataset with ("Tablename").clear and then finally i've tried re-creating the dataset via ds=new dataset and re doing the tables).
It runs the same function as before but instead of getting rid of the old data and displaying the new data it adds it'self on to the end so i have the old columns then the new columns next to it.
have tried everything i can think of can anyone help me???
i attach my code and forms.
Last edited by nokia8210; Feb 11th, 2004 at 10:44 AM.
Reply With Quote