Combobox doesnot update valuemember??

[al]

Greetings,

As I understands it, SelectedValud of combobox reads its value from
ValueMember property of the combobox. This doesn't work with me. What
happens is just randome update. This is the code,
'Here I set connectin and commands

Dim cn As SqlConnection = New SqlConnection(s tr)
Dim cmd As SqlCommand = New SqlCommand("SEL ECT E1.EmployeeID,
E1.Title," & _
"E2.FirstNa me + ' ' + E2.LastName AS ReportsTo,E1.Fi rstName," &
_
"E1.LastNam e FROM Northwind..Empl oyees AS E1 LEFT OUTER JOIN" &
_
" Northwind..Empl oyees AS E2 ON E2.EmployeeID = E1.ReportsTo",
cn)
Dim ds As New DataSet
Dim da As New SqlDataAdapter( cmd)
'This fills dataset and initializes combobox values

da.Fill(ds, "employees" )
cboreportsto.Da taSource = ds.Tables("empl oyees")
cboreportsto.Di splayMember = "ReportsTo"
cboreportsto.Va lueMember = "EmployeeID "
txtid.DataBindi ngs.Add("text", ds, "employees.empl oyeeid")
txtfirstname.Da taBindings.Add( "text", ds,
"employees.firs tname")
txtlastname.Dat aBindings.Add(" text", ds,
"employees.last name")
cboreportsto.Da taBindings.Add( "text", ds,
"employees.Repo rtsTo")

'Here I do update to database, but no update real happens, just
randome one

cmd = cn.CreateComman d
cmd.CommandText = "updateemployee s"
cmd.CommandType = CommandType.Sto redProcedure
AddHandler cboreportsto.Te xtChanged, AddressOf cbochanged
With cmd.Parameters
.Add(New SqlParameter("@ employeeid", SqlDbType.NVarC har, 50)).Value =
txtid.Text
.Add(New SqlParameter("@ lastname", SqlDbType.NVarC har,
10)).Value = txtlastname.Tex t
.Add(New SqlParameter("@ firstname", SqlDbType.NVarC har,
10)).Value = txtfirstname.Te xt
.Add(New SqlParameter("@ Reportsto", SqlDbType.Int, 40)).Value =
cboreportsto.Se lectedValue

End With
Try
cmd.ExecuteNonQ uery()
MTIA,
Grawsha

[William Ryan]

You're binding to the Text Property, try SelectedValue. I can't remember if
it's SelectedValue or SelectedIndex, but I'm 99% sure it's the first one.

HTH,

Bill
"al" <gr*********@ya hoo.com> wrote in message
news:66******** *************** ***@posting.goo gle.com...

Greetings,

As I understands it, SelectedValud of combobox reads its value from
ValueMember property of the combobox. This doesn't work with me. What
happens is just randome update. This is the code,
'Here I set connectin and commands

Dim cn As SqlConnection = New SqlConnection(s tr)
Dim cmd As SqlCommand = New SqlCommand("SEL ECT E1.EmployeeID,
E1.Title," & _
"E2.FirstNa me + ' ' + E2.LastName AS ReportsTo,E1.Fi rstName," &
_
"E1.LastNam e FROM Northwind..Empl oyees AS E1 LEFT OUTER JOIN" &
_
" Northwind..Empl oyees AS E2 ON E2.EmployeeID = E1.ReportsTo",
cn)
Dim ds As New DataSet
Dim da As New SqlDataAdapter( cmd)
'This fills dataset and initializes combobox values

da.Fill(ds, "employees" )
cboreportsto.Da taSource = ds.Tables("empl oyees")
cboreportsto.Di splayMember = "ReportsTo"
cboreportsto.Va lueMember = "EmployeeID "
txtid.DataBindi ngs.Add("text", ds, "employees.empl oyeeid")
txtfirstname.Da taBindings.Add( "text", ds,
"employees.firs tname")
txtlastname.Dat aBindings.Add(" text", ds,
"employees.last name")
cboreportsto.Da taBindings.Add( "text", ds,
"employees.Repo rtsTo")

'Here I do update to database, but no update real happens, just
randome one

cmd = cn.CreateComman d
cmd.CommandText = "updateemployee s"
cmd.CommandType = CommandType.Sto redProcedure
AddHandler cboreportsto.Te xtChanged, AddressOf cbochanged
With cmd.Parameters
.Add(New SqlParameter("@ employeeid", SqlDbType.NVarC har, 50)).Value =
txtid.Text
.Add(New SqlParameter("@ lastname", SqlDbType.NVarC har,
10)).Value = txtlastname.Tex t
.Add(New SqlParameter("@ firstname", SqlDbType.NVarC har,
10)).Value = txtfirstname.Te xt
.Add(New SqlParameter("@ Reportsto", SqlDbType.Int, 40)).Value =
cboreportsto.Se lectedValue

End With
Try
cmd.ExecuteNonQ uery()
MTIA,
Grawsha

[Bo Diddly]

Yes, it is SelectedValue.

I just went through this with my program!

Good luck,

Gary

[al]

"Bo Diddly" <hd******@hotma il.com> wrote in message news:<OJ******* *******@tk2msft ngp13.phx.gbl>. ..

Yes, it is SelectedValue.

I just went through this with my program!

Good luck,

Gary

Thanks Guyes! The randome assignment of combobox is gone after I had
changed text property to SelectedValue. But now there is another
problem. When I load the form and navigate with next and prev. it
works fine, but the problem is when I change the vaule in the combobox
to another one. That is, When I select a value from the list, then
the previous selected value becomes the default in the combobox's
selected value for all records when I move next or prev. It seems to
me that the ValueMember of the combobox becomes out-of-synch and does
not change as the selected value in combobox changes, thusly affecting
the SelectedValue of the combobox.

Any feedback is greatly apprciated!!!

[Didymus]

Grawsha,

Try setting the ComboBox.Select edItem and ComboBox.Select edValue to the same
value.

Gary
(was Bo Diddly but now is Didymus)