C# listBox.SelectedIndex from Database -

in visual studio 2010 (using visual c#),i have form there listbox (named listbox1). user selects 1 of items displayed on listbox , clicks on save button. application saves user's selection database using:

cmd.commandtext = "insert table2 (kat) values ('"+listbox1.selectedindex.tostring()+"')"

(edit)for instance saved 0 or 1 or 2 etc...

and want application use int select same item on listbox,with same items on form.

what have far is:

cmd.commandtext = "select * table1 username='"+textbox1.text+"'";                                 dr = cmd.executereader();                                 if (dr.hasrows)                                 {                                     while (dr.read())                                     {                                         form1.listbox1.selectedindex(dr[0]);                                     }                                  } 

you inserting value string in database, , trying add values integer wrong way

to insert value integer

cmd.commandtext = "insert table1(kat) values(@id)"; cmd.parameters.addwithvalue("@id", listbox1.selectedindex); cmd.executenonquery(); 

the create copy of listbox on other form can using select query.

ex.

cmd.commandtext = "select kat table1";  var reader = cmd.executereader();  while(reader.read()) {     otherlistbox.items.add(reader[0]); } reader.close(); 

---

to sync list , try

int index = listbox1.findstringexact("id find");  if (index > -1) {     listbox1.selectedindex = index; }