4 replies to this topic

[Imless]

Need help:


Sub combofill()
Dim dat As SqlDataAdapter = New SqlDataAdapter("select lname + ' ' + fname + ' ' + mname as store_forcom from tblaccount", con)
dat.Fill(dats, "tblaccount")
Me.ComboBox1.Items.Clear()
Me.ComboBox1.DisplayMember = "store_forcom"
Me.ComboBox1.ValueMember = "account_id"
Me.ComboBox1.DataSource = dats.Tables("tblaccount").DefaultView
End Sub

I binded the columns lname,fname,mname to the combobox and what I want is to get the ID everytime the combobox's index changes.


Heres the code for the combobox index change:

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
Label1.Text = ComboBox1.SelectedValue.ToString()
End Sub

It gives 'System.Data.DataRowView'. It works if only one column.

[kernelcoder]

You set the CombBox's ValueMember to 'account_id'. Does the default DataView from DataTable tblaccount has the account_id property in it?

Also, please check for 'Nothing' of the SelectedValue property/column in ComboBox SelectedIndexChanged event as follows.

System.EventArgs) Handles ComboBox1.SelectedIndexChanged
 If (ComboBox1.SelectedValue <> Nothing) 
    Label1.Text = ComboBox1.SelectedValue.ToString()
End Sub

[lespauled]

1) Run your query in SSMS to verify what is coming back from the query.

2) Put a breakpoint on the ComboFill routine and step through it, once again verifying what is coming back from the DB, etc.

Your code doesn't show a declaration for the variable: dats

I'm also assuming that con is open?

Why aren't you declaring a DataTable variable and filling that?

Dim dt as DataTable = New DataTable()
Dim dat As SqlDataAdapter = New SqlDataAdapter("select lname + ' ' + fname + ' ' + mname as store_forcom from tblaccount", con)
dat.Fill(dt, "tblaccount")
Me.ComboBox1.Items.Clear()
Me.ComboBox1.DataSource = dt
Me.ComboBox1.DisplayMember = "store_forcom"
Me.ComboBox1.ValueMember = "account_id" <== This field is not in your query

[Imless]

how to put a breakpoint?

[lespauled]

you can either click in the lefthand side of the line and a breakpoint (red symbol) will toggle on/off. You can also right click on a line and select insert breakpoint. But your problem is that account_id is not in your sql query. Add it, check my answer above, and it should work.