Shops loading error

[Jaiz]

The last question and all done. Thank you very much @2 Also here: 

MySqlCommand dbCmd = new MySqlCommand("Update test_table SET test_column3=" + textBox1.Text + "WHERE test_column1 =" + dt.Rows[row]["test_column1"] + ";", dbCon);

i want update the table: t_shop -> a_keeper_idx

This code where i write 

MySqlCommand dbCmd = new MySqlCommand("Update t_shop SET a_keeper_idx=" + textBox_id.Text+ "WHERE (IDK what here) =" + dt.Rows[row]["(idk what here)"] + ";", dbCon);

What is the column 1? 

[someone]

you need the condition to which  row to apply it:

Update t_shop SET a_keeper_idx=New ID WHERE a_keeper_idx =Old ID;"

[Jaiz]

The Update code seems to dont work. Its update it but if i reload the listBox i see my old ID.

[soryjero]

The Update code seems to dont work. Its update it but if i reload the listBox i see my old ID.

 

you see your old list because you have to erase listbox before reload it

[Jaiz]

You mean i have to erase it? How to do? (sorry im noob on listbox with mysql config, im trying to learn it)

 

Regards Jaiz

[soryjero]

You mean i have to erase it? How to do? (sorry im noob on listbox with mysql config, im trying to learn it)

 

Regards Jaiz

 

before add items in listbox, you have to do:

listBox1.Items.Clear();

[Jaiz]

listBox1.Items.Clear();
After adding and reloading error.

[soryjero]

when you write what i have posted, you have to reload npcs before select some of them.