🚀 go-pugleaf

Clear the DataTable column information if you are going to be using the same 
datatable for both queries.

MyDataTable.Columns.Clear();

Do this before filling the DataTable for the second time. Does this work for 
you?

./John

"Bob" <rcf2@email.com> wrote in message 
news:41dcb587$1@newsgroups.borland.com...
> (sorry about this cross post, but original was in wrong group)
>
> I have a datagrid that I populate with a datatable.  But, if I change
> the data in the datatable, the grid seems to just add the new columns
> to the display rather than "clearing" and updating with the new table
> data in the datatable.
>
> Basically:
>  Fill(dataTable) // fill with query 1
>  dataGrid.DataSource:= dataTable
>
>  dataTable.Close
>  Fill(dataTable) // fill table with query 2
>  dataGrid.Datasource:= dataTable
>
> The end result, has all the columns for query 1 and query 2 displayed.
> The query 1 columns are all "nil" of course but they are still shown.
>
> Is there a way to "Clear" the datagrid completely before assigning a
> new datasource?
>
> I have tried, dataTable.ResetBindings hoping that would work but it
> didn't