hello, i have a problem with combobox to stored in sql database

this is my code

cmbDept.Items.Add("" & dtUser.Rows(i).Item(0) & "/" & dtUser.Rows(i).Item(1) & "")

how to take the first item from combobox "dtUser.Rows(i).Item(0)"
and stored in sql database. ??

no, I mean how to insert to database the first value of combobox

Private Sub LoadDept()
        conn = New SqlConnection("Data Source=EXCO-2B41B5;Initial Catalog=payroll;Integrated Security=True")
        cmdUser = conn.CreateCommand
        cmdUser.CommandText = "select * from department order by number asc"
        daUser.SelectCommand = cmdUser
        daUser.Fill(dsUser, "department")
        dtUser = dsUser.Tables("department")
        For i = 0 To dtUser.Rows.Count - 1
            cmbDept.Items.Add("" & dtUser.Rows(i).Item(0) & "/" & dtUser.Rows(i).Item(1) & "")
        Next i
End Sub

Item(0) = first field is "number"
Item(1) = second field "division"

result in combobox

my question is how to insert database just the fisrt value, that is Item(0) "number"

Any kind of help would be appreciated.

yes. the selected value, but i want to insert first item in combobox, not both.
in my code, the first item is cmbDept.Items.Add("" & dtUser.Rows(i).Item(0) &"")

first item / second item
----------- ------------
1 / Injection
2 / Warehouse
3 / Maintenance

This article has been dead for over six months. Start a new discussion instead.