datagrid operation and refresh

[ravi sankar]

i suppose dataset1 is ur SQL dataset which u have
populated some where. U need to refresh this dataset again
after u have deleted the row from the table.
So repopulate the dataset and then bind it to the datagrid

regards,
s.ravi sankar

-----Original Message-----
Hi.

I am deleting a row from my datagrid, but it is not refreshing immediatelyafter the delete.

My delete handler is as below.

What do I need to add to get it to refresh properly?

private void DataGrid1_DeleteCommand(object source,
System.Web.UI.WebControls.DataGridCommandEventArg s e)

{

cmdDeleteUser.Parameters["ID"].Value = DataGrid1.DataKeys [e.Item.ItemIndex];
oleDbConnection1.Open();

cmdDeleteUser.ExecuteNonQuery();

DataGrid1.DataSource = dataSet1;

DataGrid1.DataBind();

oleDbConnection1.Close();

}

Thanks in advance.
.