Start New Discussion within our Software Development Community

Hello programmers!.
Please help me. :(
I have here a combobx1 that has a value of Mr.A and Mr.B. want that if i choose from my combobox1 the selected value will go to my sql database.

this is my code.
Dim con As New SqlConnection()
con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"
Dim da As New SqlDataAdapter("select * from BSIT", con)
Dim table As New DataTable()
comboBox1.DataSource = New BindingSource(table, Nothing)
ComboBox1.DisplayMember = "BSIT"
ComboBox1.ValueMember = "Bernard"

ok you can do like this

dim con as new sqlconnection("connection string")
dim cmd as new sqlcommand
cmd.connection= con
cmd.commandtext="insert into table1 (field1) values ("& combobox1.text &")"

you can use this code at any button click event to save the value of combo in db and also at selected index change event of your grid .
in place of text you can use the selectedvalue .tostring .

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