[2008] How to select data from sql table to string value?

[MAHDi25]

Hi All:
my sql2008 table is :

T1:

 Code(*)     Genus
 --------     ------  
  SA10           A1
  SA11           A2
  SA12           A3

        Dim a As New DataTable
        Dim b As New SqlDataAdapter
        b.SelectCommand = New SqlCommand("SELECT * FROM T1 ORDER BY Genus ASC", M)
        b.Fill(a)
        ComboBox1.DataSource = a
        ComboBox1.DisplayMember = "Genus"

I want when select item from combobox1 then filled Selecteditem(from Combobox1) 'Code' to string value.
how to do?

[Hack]

"SELECT genus FROM T1 WHERE CODE = '" & Combobox1.Text & "' "

Is that what you mean?

[MAHDi25]

Thanks Hack.