Hello All.

I am using DATAGRID in my VB6 forms. Once after loading, I would like to clear it,using CLEAR button. I dont find ANY CLEAR option for this datagrid control.

Can u pls help me to solve this .

Thanks
Regards
Sudhagar.S

Private Sub Command1_Click()
Set Me.DBGrid1.DataSource = Nothing
Me.DBGrid1.ClearFields
Me.DBGrid1.ReBind

Me.DBGrid1.Refresh

End Sub

If you're using a control that's designed to be bound to a datasource, you should always use it in that manner. If you want to "clear it" and so-forth without affecting the underlying data-source, plan to load data into the grid (and to save data from it) programmatically. In other words, your own code.

Even though data-aware controls are convenient, they're convenient only when used for their intended purpose ... and a headache otherwise. Funky code that "you managed to get it to work" and a slew of maintenance problems thereafter.

thank you Marvel...

Regards
Sudhagar.S