Populated results from combobox to textbox ?

dibblm

I'll start this hopefully simple and add code where needed or requested.

Im using a combobox that bound to a DataSet. The Dataset retreives it's values from SQL.

I can retreive the values fine. However only displaying (1) Column. Which is fine.

Here's where it gets complicated for me. The dataset has 2 other columns that get filled. I need the resulting columns to be sent to text boxes when I select a value from the combobox.

Basically:

Expand|Select|Wrap|Line Numbers

 
 txtbox1.text = combobox.column(2).selectedvalue

 txtbox2.text = combobox.column(3).selectedvalue

However. using the method of course doesnt work and that's what I need to figure out.

dibblm

OK. For anyone looking for this in the future let me tell you how I went about this.

I filled the DataSet with Data From SQL. Bound a ComboBox to the DataSet.

Expand|Select|Wrap|Line Numbers

 
 txtbox1.text = dataset.tables("table name here").Rows(cbox1.selectedindex).Item("Column name here")
 
 txtbox2.text = dataset.tables("table name here").Rows(cbox1.selectedindex).Item("Column name here")

First issue I ran into was VB sending errors because the first column was yet to be populated so I had to set the index of cbox1 to 0

Expand|Select|Wrap|Line Numbers

cbox1.selectedindex = 0

Then for the selected index chage event

Expand|Select|Wrap|Line Numbers

 
If cbox1.selectedindex = -1 then

  cbox1.selectedindex = 0

end if
 
txtbox1.text = dataset.tables("table name here").Rows(cbox1.selectedindex).Item("Column name here")
 
txtbox2.text = dataset.tables("table name here").Rows(cbox1.selectedindex).Item("Column name here")

Thats all there was too it. being a novice I was actually trying to get the data from the Column instead of the Row. "STUPID. Yes.."

If anyone wants to modify and tell of any other way we can make this better I would appreciate it.

Xennex

Seems like you were able to solve your problem well.. I tend to favor using the "With" statement when I have long object strings since each '.' is basically telling an object traversal.. I would just change the following like so:

Expand|Select|Wrap|Line Numbers

 
With dataset.tables("table name here").Rows(cbox1.selectedindex)

   txtbox1.text = .Item("Column name here")

   txtbox2.text = .Item("Column name here")

End With

Populated results from combobox to textbox ?

re: Populated results from combobox to textbox ?

re: Populated results from combobox to textbox ?

Similar Visual Basic .NET bytes

/bytes/development

/bytes/it

/bytes/about