refresh datagrid

[chowboon]

Dear All,
how to refresh the datagrid after i made some changes of by data. i used
datagrid1.Refresh()
but it is not working, please help.

regards

[Lunatic3]

I am not at my dev machine now to check it, but maybe you have to refresh the underlying currency manager of your datagrid.

[jasonlimks]

solly i didnt get what u mean,,,'refresh the underlying currency manager of your datagrid.' ,,appreciate if u can give me some sample code !


TIA

Boon

[DevGrp]

I dont think refreshing the datagrid will work. You have to refresh the underlying datasource. So you would do something like this

Dim ds as New DataSet()
dataGrid1.DataSource = ds.Tables("mytable").DefaultView
 
'make changes here
 
Dim tempDs as DataSet = ds.GetChanges()
ds.Merge(tempDs) 'datagrid should be refreshed with new data

[jasonlimks]

just put this into your code

ds.clear()


regards

[Lunatic3]

I will post you the code for refreshing the currency manager when i get home. You dont need to use temporary datasets. You better take a look at databinding concept in windows forms first.

[Lunatic3]

I think this should work for you.

Dim cm As CurrencyManager
cm = CType(Me.BindingContext("datagrid data source here"), CurrencyManager)
cm.Refresh