Hi !
I have a table
table1
id (numeric)
...
id_invalid (numeric)
......
Field id_invalid could have 3 values
0 - Normal
1 -Gr.1
2 -Gr.2
This field in no FK,I have no table defined for these values,I use one combobox to select them,combo is bound this way to a temporary source :
vb.net Code:
Dim wDtbl As New DataTable
wDtbl.Columns.Add("id", GetType(Integer))
wDtbl.Columns.Add("exp", GetType(String))
Dim wdrwItem As DataRow
wdrwItem = wDtbl.NewRow
wdrwItem("id") = 0
wdrwItem("exp") = "Normal"
wDtbl.Rows.Add(wdrwItem)
wdrwItem = wDtbl.NewRow
wdrwItem("id") = 1
wdrwItem("exp") = "Gr.1"
wDtbl.Rows.Add(wdrwItem)
................................
comInvl.DisplayMember = "exp"
comInvl.ValueMember = "id"
comInvl.DataSource = wDtbl
I get selected id using SelectedValue and write it to id_invalid field in table1
My problem is : can I bind my combobox to display exp from wDtbl when I navigate into table1 ?
Thanks !