tablo da auto inc içeren herhangi bir id vs yok. Mesela aynı shop_vnum dan 10-15 girdi olabiliyor.Sadece 3 sütundan oluşuyor. Shop_vnum,item_vnum,count şeklinde.
data gride bilgileri çektiriyorum. insert ve delete komutlarını sorunsuz kullanabiliyorum ama ne yaptıysam update komutunu geçiremedim..
Kod satırı aşağıda yardımlarınızı bekliyorum şimdiden teşekkürler
private void button16_Click(object sender, EventArgs e)
{
try
{
BindingSource bs1 = new BindingSource();
table1 = new DataTable();
bs1.DataSource = table1;
this.dataGridView2.DataSource = bs1;
MySqlConnection conn1 = new MySqlConnection(ThePRNCE.Form1.cs);
conn1.Open();
string s1 = "select *from player.shop_deneme";
MySqlCommand cmd1 = new MySqlCommand(s1, conn1);
da1 = new MySqlDataAdapter();
da1.SelectCommand = new MySqlCommand(s1, conn1);
//There is issue in below sytax of insert command.
MySqlCommand insertcommand1 = new MySqlCommand("insert into player.shop_deneme(shop_vnum,item_vnum,count) values(@shop_vnum, @item_vnum, count)", conn1);
insertcommand1.Parameters.Add("@shop_vnum", MySqlDbType.Int32, 50, "shop_vnum");
insertcommand1.Parameters.Add("@item_vnum", MySqlDbType.Int32, 50, "item_vnum");
insertcommand1.Parameters.Add("@count", MySqlDbType.Int32, 50, "count");
da1.InsertCommand = insertcommand1;
MySqlCommand updatecommand1 = new MySqlCommand("update player.shop_deneme set shop_vnum=@shop_vnum,item_vnum=@item_vnum,count=@count where (shop_vnum=@shop_vnum) and (item_vnum=@item_vnum) and (count=@count)", conn1);
updatecommand1.Parameters.Add("@shop_vnum", MySqlDbType.Int32, 50, "shop_vnum");
updatecommand1.Parameters.Add("@item_vnum", MySqlDbType.Int32, 50, "item_vnum");
updatecommand1.Parameters.Add("@count", MySqlDbType.Int32, 50, "count");
da1.UpdateCommand = updatecommand1;
MySqlCommand deletecommand1 = new MySqlCommand("delete from player.shop_deneme where shop_vnum=@shop_vnum and item_vnum=@item_vnum", conn1);
deletecommand1.Parameters.Add("@shop_vnum", MySqlDbType.Int32, 50, "shop_vnum");
deletecommand1.Parameters.Add("@item_vnum", MySqlDbType.Int32, 50, "item_vnum");
da1.DeleteCommand = deletecommand1;
da1.Fill(table1);
conn1.Close();
}
catch (Exception err) { MessageBox.Show(err.Message); }
}
private void button13_Click_1(object sender, EventArgs e)
{
da1.Update(table1);
}