+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Programmers Gateway (https://lckb.dev/forum/forumdisplay.php?fid=196)
+---- Forum: Coders Talk (https://lckb.dev/forum/forumdisplay.php?fid=192)
+---- Thread: Shops loading error (/showthread.php?tid=2281)
Pages:
1
2
- Jaiz - 07-28-2013
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 - 07-29-2013
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 - 07-29-2013
The Update code seems to dont work. Its update it but if i reload the listBox i see my old ID.
- soryjero - 07-29-2013
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 - 07-30-2013
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 - 07-30-2013
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 - 07-31-2013
listBox1.Items.Clear();
After adding and reloading error.
- soryjero - 07-31-2013
when you write what i have posted, you have to reload npcs before select some of them.