private void button2_Click(object sender, EventArgs e) { int index = kelimeview.CurrentRow.Index; string a = kelimeview.Rows[index].Cells[3].Value.ToString(); string kayit = "update kelime set tipi=1,test_tipi=1 where id=" + a; baglan.update(kayit); baglan.kayitGetir("select Turkce,Ing,turu,id from kelime where tipi=1", ogrenilenview); }
private void button2_Click(object sender, EventArgs e) { string trkelime = tr.Text; string enkelime = en.Text; string tur = turbox.Text; string tip = "0"; string testtip = "0"; DateTime dt = DateTime.Today; string tarih = dt.ToString("yyyy-MM-dd"); string kayit = "insert into kelime(Turkce, Ing,turu,Tipi,test_tipi,tarih) values('" + trkelime + "', '" + enkelime + "', '" + tur + "', '" + tip + "','" + testtip + "', '" + tarih + "' )"; MessageBox.Show(kayit); baglan.insert(kayit); baglan.kayitGetir("select Turkce,Ing,turu,id from kelime ", dataGridView1); }
private void UserControl1_Load(object sender, EventArgs e) { baglan = new baglanti(); baglan.kayitGetir("select Turkce,Ing,turu,id from kelime ", kelimeview); baglan.kayitGetir("select Turkce,Ing,turu,id from kelime where tipi=1", ogrenilenview); }