The following code snippet can be used for showing the data from the dataset into Datagrid control when you are working in vb 6.
We are using Datasource property of the DataGrid control for displaying the data. For it we get the Data from the database into ADODB recordset object. the program require to add the reference of the Microsoft Activex Data objects library so that you can use the ADODB.
See the example:
Private m_strCnn As String Private m_adoConn As ADODB.Connection Private Sub SetData() With m_adoConn If .State = 0 Then .Open m_strCnn End If End With Dim gridrs As New ADODB.Recordset With gridrs .ActiveConnection = m_adoConn .CursorLocation = adUseClient .CursorType = adOpenKeyset .LockType = adLockReadOnly .Source = "Select * from yourtable" .Open End With Set DataFrid1.DataSource = gridrs Set gridrs = Nothing End Sub