Update worked for me , though you can try this which repaint the grid .
VB Code:
  1. Me.DataGrid1.Refresh()
For the foreach loop , no clue .