I am trying to access data in SQL Server and pull it into the form. I am somewhat new at this. Can anyone help me out? I have one form open and you type in the case number. or lastname. Then I want it to be able to pull in data into another form. PLEASE HELP! This is what I have so far:

VB Code:
  1. SqlConn.Open()

  2.  
  3.         Dim drSqlDataReader1 As SqlDataReader = cmdSqlCommand1.ExecuteReader()

  4.         drSqlDataReader1.Read()

  5.          Dim search As String

  6.  
  7.         If IsNumeric(txtSearchCase.Text) Then

  8.             search = "SELECT * FROM CapRec WHERE CaseNumber LIKE '%" & txtSearchCase.Text & "%';"

  9.  
  10.             'txtCaseNum.Text = drSqlDataReader1.Item(0)

  11.  
  12.         Else

  13.             search = "SELECT * FROM CapRec WHERE LastName LIKE '%" & txtSearchCase.Text & "%';"

  14.         End If