How to Clear the DataGrid...?

[haider7]

Dear Friends,

I have a project for Sales, and every time I have to clear the DataGrid when I Post the Transaction sales or Cancel it.

I'm trying to do this code to delete the table but doesn't work till now coz I have to make refresh to the record set and I don't know how?
anyway this is the code

If rs.RecordCount > 0 Then
     rs.MoveFirst
         For aloop = 0 To rs.RecordCount - 1
      Cn.Execute ("delete * from TmpDetails")
      rs.MoveFirst
                 DataGrid1.Refresh 

So I hope if there is anyone can help me and if there is any Questions plz let me know

note that I'm not using any Data Control (ADO) to connect I programmed it by code only

and thx alot

Best Regards