Populating textboxes

[greymonkey]

Hi,

I have a couple of combo boxes pulling data from an Access Database.

The second combo is running off a DataView which filters the results:

        Dim tempTable As DataTable = DataSet_Ticket1.Tables(0)
        Dim tempDataView As DataView = New DataView(tempTable, "TicketGroupRef = " + cmb_Group.SelectedValue.ToString, "TicketDiscription", DataViewRowState.CurrentRows)
        cmb_Ticket.DataSource = tempDataView

I now want to fill in some text boxes with the fields of the row selected in the second combo box but cant find a command to select the feild in the database.

Am looking for something like:

txt_textBox.text = [i]DB_Table_ref[/i]([i]coloum_Name[/i])

The text boxes are not bound to anything.

Any Ideas,

Cheers.

 

[jebenson]

Try this:

txt_textBox.text = tempDataView(cmb_Ticket.SelectedIndex).Item("ColumnName")

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira