having error at updating database

[marniel647]

ok,ok guys
let think in other way & what are all needs to be refreshed.

(1) from where the data is coming
(2) where it is being shown

(1) accordingly the data source , i mean the data table which is set as the data source for the Data grid view should be refreshed first with fresh data.
that means the dataset + its table should be re populated or else we must add the changes to the dataset.

next

(2)for a while disconnect the datagrid view from its data source until the changes could take place with in the data source

(3) now refresh the datagrid view

here is my code to display the data in my datagrid vie the data is coming from a data table..

rReader is my oledb command

table.Load(rReader)
 
                DataGridView1.DataSource = table