Setting Parameters for CR

[TS]

Hi all,
From my windows form I connected to a SQL database and had two cbo boxes
generating clients last and first names from the SQL database. I also created
a CR report pulling data from the same database and included it in my
project. What I want to do is the following:-

1- I want the cbo box that holds the first name of the client to return the
clients first names based on the last name selected from the last name cbo
box.
2- I want to have another lst box in my form showing the client IDs (it will
show more than one client ID if more than one client has the same last and
first name)based on the last name and first name selected.
3-I want the user when selecting a client ID from the lst box and hit on a
button to generate the CR for that particular client.

The codes I wrote so far to connect to the SQL database and generate the two
cbo boxes are the following. I am having difficulties to move forward to
accomplish what I need, please help!!

Private Sub ConnectSQL_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles ConnectSQL.Click
Dim SQLEV As SqlClient.SqlConnection = New SqlClient.SqlConnection()
Dim cmd As SqlClient.SqlCommand
Dim ClientName As SqlClient.SqlDataReader

SQLEV.ConnectionString = "Persist Security Info=true;Integrated
Security=false;User ID=sa;Password=xxxx;database=yyyy;server=zzzz"
SQLEV.Open()
cmd = New SqlClient.SqlCommand("SELECT * FROM qmf_cint", SQLEV)

ClientName = cmd.ExecuteReader
cbo_ChildLName.Items.Clear()
cbo_ChildFName.Items.Clear()
Do While ClientName.Read

cbo_ChildLName.Items.Add(Trim(ClientName.Item("Las t_Name").ToString))

cbo_ChildFName.Items.Add(Trim(ClientName.Item("Fir st_Name").ToString))
Loop
SQLEV.Close()

End Sub


--
TS