private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { arcekle ekle = new arcekle(); ekle.gncid.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString(); ekle.ruhno.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString(); ekle.marka.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString(); ekle.seri.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString(); ekle.model.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString(); ekle.yil.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString(); ekle.cmbyakit.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString(); ekle.cmbvites.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString(); ekle.km.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString(); ekle.kasatipi.Text = dataGridView1.CurrentRow.Cells[9].Value.ToString(); ekle.mhacim.Text = dataGridView1.CurrentRow.Cells[10].Value.ToString(); ekle.mguc.Text = dataGridView1.CurrentRow.Cells[11].Value.ToString(); ekle.cmbcekis.Text = dataGridView1.CurrentRow.Cells[12].Value.ToString(); ekle.renk.Text = dataGridView1.CurrentRow.Cells[13].Value.ToString(); ekle.cmbgaranti.Text = dataGridView1.CurrentRow.Cells[14].Value.ToString(); ekle.cmbuyruk.Text = dataGridView1.CurrentRow.Cells[15].Value.ToString(); ekle.plakano.Text = dataGridView1.CurrentRow.Cells[16].Value.ToString(); ekle.cmbkimden.Text = dataGridView1.CurrentRow.Cells[17].Value.ToString(); ekle.cmbtakas.Text = dataGridView1.CurrentRow.Cells[18].Value.ToString(); ekle.cmbdurum.Text = dataGridView1.CurrentRow.Cells[19].Value.ToString(); ekle.rsmpth.Text = dataGridView1.CurrentRow.Cells[20].Value.ToString(); ekle.rprpth.Text = dataGridView1.CurrentRow.Cells[21].Value.ToString(); ekle.fiyat.Text = dataGridView1.CurrentRow.Cells[22].Value.ToString(); ekle.kcncshp.Text = dataGridView1.CurrentRow.Cells[23].Value.ToString(); ekle.Show(); this.Hide(); }
private void sat_Click(object sender, EventArgs e) { try { arcekle ekle = new arcekle(); if (stcid.Text == "") { MessageBox.Show("Lütfen Aracın ID'sini Giriniz! \nNot : Aracın ID'sini Araçları Listele Kısmından Öğrenebilirsiniz !"); } else { con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BuySellDB.accdb"); cmd = new OleDbCommand(); con.Open(); da = new OleDbDataAdapter("Select *From satilanaraclar", con); cmd.Connection = con; cmd.CommandText = "insert into satilanaraclar (ruhsatno,marka,seri,model,yil,yakit,vites,km,kasatipi,motorhacmi,motorgucu,cekis,renk,garanti,plakauyruk,plakano,kimden,takas,durumu,satistarihi,satansahis,mustis,mustsoyis,musttc,musttel,mustadr,goruntupath,raporpath,fiyat,kacincisahip) values ('" + ruhno.Text + "','" + marka.Text + "','" + seri.Text + "','" + model.Text + "','" + yil.Text + "','" + cmbyakit.Text + "','" + cmbvites.Text + "','" + km.Text + "','" + kasatipi.Text + "','" + mhacim.Text + "','" + mguc.Text + "','" + cmbcekis.Text + "','" + renk.Text + "','" + cmbgaranti.Text + "','" + cmbuyruk.Text + "','" + plakano.Text + "','" + cmbkimden.Text + "','" + cmbtakas.Text + "','" + cmbdurum.Text + "','" + tarih.Text + "','" + stnshs.Text + "','" + muisim.Text + "','" + musoyisim.Text + "','" + mutc.Text + "','" + mutel.Text + "','" + muadr.Text + "','" + rsmpth.Text + "','" + rprpth.Text + "','" + fiyat.Text + "','" + kcncshp.Text + "')"; cmd.ExecuteNonQuery(); con.Close(); con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BuySellDB.accdb"); cmd = new OleDbCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "delete from araceklevegoruntule where arackimlik=" + stcid.Text + ""; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Aracınız Satış Veri Tabanına Eklendi !", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); ruhno.Clear(); marka.Clear(); seri.Clear(); model.Clear(); yil.Clear(); cmbyakit.SelectedIndex = 0; cmbvites.SelectedIndex = 0; km.Clear(); kasatipi.Clear(); mhacim.Clear(); mguc.Clear(); cmbcekis.SelectedIndex = 0; renk.Clear(); cmbgaranti.SelectedIndex = 0; cmbuyruk.SelectedIndex = 0; plakano.Clear(); cmbkimden.SelectedIndex = 0; cmbtakas.SelectedIndex = 0; cmbdurum.SelectedIndex = 0; kcncshp.Clear(); rsmpth.Clear(); rprpth.Clear(); fiyat.Clear(); muisim.Clear(); musoyisim.Clear(); mutc.Clear(); mutel.Clear(); muadr.Clear(); stcid.Clear(); stnshs.Clear(); } } catch { MessageBox.Show("Aracınız Satış Veri Tabanına Eklenemedi !", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void arceklcik_Click(object sender, EventArgs e) { arcekle aracekle = new arcekle(); aracekle.Show(); }