refreshing datagrid

[EyeTalion]

After I do a delete from my datagrid the record still shows on the grid unless you leave the page and come back. I placed

'refresh the Datagrid
OleDbDataAdapter1.Fill(DataSet11)
DataGrid1.DataBind()

after the delete, but it keeps the old data in the grid and give me the new data from the database. What is the correct way to refresh the grid after a delete?

[ChrisWise]

What you want to do is execute the query again then fill the dataset.

Chris

[Lethal]

You have to restablish the communication between the dataset and the datagrid. The solution is setting the datasource property on the datagrid to the datasource (dataset). However, it all depends on how you actually have everything setup.

Cheers