populate a text box from table data on dropbox change

Hi I want to populate a text box from a stored table I have this for the data

With DropDownList1

.DataSource = ds.Tables(“property”)

.DisplayMember = “propRef”

.ValueMember = “propRef”

.SelectedIndex = 0

End With

“property” holds all the info from the db when the user changes the dropdown list I want a text box to display additional info

(Toggle Plain Text)

 Dim connString As String = "Data Source=*****;Initial Catalog=****;Integrated Security=True"
        Dim conn As New SqlConnection(connString)

        Dim strSQL As String = "SELECT * FROM property WHERE (availible=1)"
        Dim da As New SqlDataAdapter(strSQL, conn)
        Dim ds As New DataSet
        da.Fill(ds, "property")

        With DownList1
            .DataSource = ds.Tables("property")
            .DisplayMember = "propRef"
            .ValueMember = "propRef"
            .SelectedIndex = 0
        End With

Dim connString As String = “Data Source=*****;Initial Catalog=****;Integrated Security=True”<br /><br /> Dim conn As New SqlConnection(connString)</p><br /><p> Dim strSQL As String = “SELECT * FROM property WHERE (availible=1)”<br /><br /> Dim da As New SqlDataAdapter(strSQL, conn)<br /><br /> Dim ds As New DataSet<br /><br /> da.Fill(ds, “property”)</p><br /><p> With DownList1<br /><br /> .DataSource = ds.Tables(“property”)<br /><br /> .DisplayMember = “propRef”<br /><br /> .ValueMember = “propRef”<br /><br /> .SelectedIndex = 0<br /><br /> End With

the additional columns I want to display are flatNo, houseNo and street

So something like this on the dropdown list change

.DataSource = ds.Tables(“property”)

(Toggle Plain Text)

  If (Not Me.RadDropDownList1.SelectedValue Is Nothing) Then
            Me.TextBox12.Text = "flatNo "+" houseNo "+" street"
      End If

If (Not Me.RadDropDownList1.SelectedValue Is Nothing) Then<br /><br /> Me.TextBox12.Text = “flatNo “+” houseNo “+” street”<br /><br /> End If

anyone have an idea how I can get this to work

thanks

M

http://bit.ly/nLf6Do