clear dataGrid(C#)

kobystud · July 31st, 2004, 02:33 PM

hello
i have created datagrid. i made query and write this lines

adapter.Fill(dataSet);
dataGrid1.SetDataBinding(dataSet , "table");

but now i want to make a new query (i make always new query) and want to see the new results in datagrid but the old data is mix with new data in datagrid , how can i clear the datagrid completely and see just the new results?
thanks
koby

melvik · August 1st, 2004, 12:04 AM

Well first clear ur filled DataSet & then fill it! I recoment to not change ur codes much. just add clear() before ur Fill() I mean

Code:

dataSet.table.Clear();
adapter.Fill(dataSet);
dataGrid1.SetDataBinding(dataSet , "table");

HTH.

Always:),
Hovik Melkomian.

xtremePro · July 17th, 2011, 06:54 AM

It still doesn't remove previous query results.It just places "NULL" in those columns.For example if i made a query about the "firstNames" in a personal information table and executed it and then make a query about "lastNames", the first name columns is still there with all values set to "NULL" now.how can i completely empty the data grid so that it only shows the query result of currently executed query?