Hi,

I have the follwoing code

vb Code:
  1. Dim Conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
  2.                                                             "Data Source=" & DBPath & ";")
  3.         Dim Comm As System.Data.OleDb.OleDbCommand
  4.  
  5.         Dim sqlcom As String
  6.  
  7.         If Me.cmb_client.Text <> "" Then
  8.             sqlcom = "Select * from tbl_client where client_id = " & Me.cmb_client.SelectedValue
  9.             MessageBox.Show(sqlcom)
  10.             Comm = New System.Data.OleDb.OleDbCommand(sqlcom, Conn)
  11.             'defines new data adapter
  12.             Dim DA As New System.Data.OleDb.OleDbDataAdapter
  13.             DA.SelectCommand = Comm
  14.  
  15.             ' defines new dataset
  16.             Dim DS As New DataSet
  17.  
  18.             Try
  19.                 DA.Fill(DS)
  20.             Catch ex As Exception
  21.                 'The user may have entered a string as their login id
  22.                 MessageBox.Show(Err.Description)
  23.                 Me.Close()
  24.  
  25.                 Exit Sub
  26.             End Try
  27.  
  28.             Comm.Dispose()
  29.             DA.Dispose()
  30.             Conn.Close()
  31.             Conn.Dispose()
  32.  
  33.         Else
  34.  
  35.         End If
how do i make it populate the data into my text fields with the data?