Clearing the Contents of a Datagrid

If the DataGrid is bound to a VB data control, you need to set theRecordSource property of the data control to “” (null string)and then use the Refresh method:

 Sub Command1_Click() Data1.RecordSource = "" 'set RecordSource to null string Data1.Refresh SSDataGrid1.Refresh End Sub 

If the DataGrid is unbound, setting the Rows property to zero willclear it.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: