Müşteri ve Ürün Kayıt Takip Programı C#
Müşteri ve Ürün Kayıt Takip Programı C#
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.
FORM1 İçerisine Yazılacak Kodlar…
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form2 frm2;
public Form3 frm3;
public Form4 frm4;
public Form5 frm5;
public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.frm1 = this;
}
public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=vt1.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();
public int satir;
public Boolean durum = false;
public void ürünlistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", bag);
adtr.Fill(dtst, "ürünbil");
dataGridView1.DataSource = dtst.Tables["ürünbil"];
adtr.Dispose();
bag.Close();
}
public void ürünlistele2()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", bag);
adtr.Fill(dtst, "ürünbil");
frm5.dataGridView1.DataSource = dtst.Tables["ürünbil"];
adtr.Dispose();
bag.Close();
}
public void müsterilistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil ", bag);
adtr.Fill(dtst, "müsteribil");
dataGridView2.DataSource = dtst.Tables["müsteribil"];
adtr.Dispose();
bag.Close();
}
public void müsterilistele2()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil ", bag);
adtr.Fill(dtst, "müsteribil");
frm4.dataGridView1.DataSource = dtst.Tables["müsteribil"];
adtr.Dispose();
bag.Close();
}
public void barkodkontrol()
{
durum = false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select BarkodNo from ürünbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
if (frm2.textBox4.Text == oku[0].ToString()) durum = true;
}
bag.Close();
oku.Dispose();
}
public void tckontrol()
{
durum = false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select TcKimlik from müsteribil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
if (frm3.textBox1.Text == oku[0].ToString()) durum = true;
}
bag.Close();
oku.Dispose();
}
private void Form1_Load(object sender, EventArgs e)
{
ürünlistele();
müsterilistele();
dataGridView1.Columns[0].HeaderText = "Barkod No";
dataGridView1.Columns[1].HeaderText = "Ürün Adı";
dataGridView1.Columns[2].HeaderText = "Fiyat";
dataGridView1.Columns[3].HeaderText = "Ürün Türü";
dataGridView1.Columns[4].HeaderText = "Üretim Tarihi";
dataGridView1.Columns[5].HeaderText = "Tüketim Tarihi";
dataGridView1.Columns[6].HeaderText = "Alım Miktarı";
dataGridView2.Columns[0].HeaderText = "Adı Soyadı";
dataGridView2.Columns[1].HeaderText = "TcKimlik";
dataGridView2.Columns[2].HeaderText = "Telefon";
dataGridView2.Columns[3].HeaderText = "E-posta";
dataGridView2.Columns[4].HeaderText = "Cinsiyet";
}
private void button1_Click(object sender, EventArgs e)
{
frm2.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
frm3.ShowDialog();
}
private void button3_Click(object sender, EventArgs e)
{
frm4.ShowDialog();
}
private void button4_Click(object sender, EventArgs e)
{
frm5.ShowDialog();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil", bag);
if (textBox1.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from müsteribil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "müsteribil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * Form müsteribil" +
" where(TcKimlik like '%" + textBox1.Text + "%' )";
dtst.Tables["müsteribil"].Clear();
adtr.Fill(dtst, "müsteribil");
bag.Close();
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil", bag);
if (textBox2.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from müsteribil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "müsteribil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From müsteribil" +
" where(AdiSoyadi like '%" + textBox2.Text + "%' )";
dtst.Tables["müsteribil"].Clear();
adtr.Fill(dtst, "müsteribil");
bag.Close();
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil", bag);
if (textBox3.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from müsteribil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "müsteribil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From müsteribil" +
" where(Telefon like '%" + textBox3.Text + "%' )";
dtst.Tables["müsteribil"].Clear();
adtr.Fill(dtst, "müsteribil");
bag.Close();
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", bag);
if (textBox4.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "ürünbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(BarkodNo like '%" + textBox4.Text + "%' )";
dtst.Tables["ürünbil"].Clear();
adtr.Fill(dtst, "ürünbil");
bag.Close();
}
private void textBox5_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", bag);
if (textBox5.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "ürünbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(ÜrünAdi like '%" + textBox5.Text + "%' )";
dtst.Tables["ürünbil"].Clear();
adtr.Fill(dtst, "ürünbil");
bag.Close();
}
private void textBox6_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", bag);
if (textBox6.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "ürünbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(BarkodNo like '%" + textBox6.Text + "%' )";
dtst.Tables["ürünbil"].Clear();
adtr.Fill(dtst, "ürünbil");
bag.Close();
}
private void button5_Click(object sender, EventArgs e)
{
Application.Exit();
}
}
}
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.
FORM1 İçerisine Yazılacak Kodlar…
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.barkodkontrol();
if (frm1.durum == false)
{
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO ürünbil(BarkodNo,ÜrünAdi,Fiyat,ÜrünTürü,ÜretimTarihi,TüketimTarihi,AlimMiktari) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "') ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
for (int i = 0; i < this.Controls.Count; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}
frm1.dtst.Tables["ürünbil"].Clear();
frm1.ürünlistele();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
else MessageBox.Show("Girmiş olduğunuz Barkod No kullanılmış");
}
}
}
FORM1 İçerisine Yazılacak Kodlar…
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.tckontrol();
if (frm1.durum == false)
{
if (textBox1.Text != "" &amp;amp;amp;&amp;amp;amp; textBox2.Text != "" &amp;amp;amp;&amp;amp;amp; textBox3.Text != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO müsteribil(TcKimlik,AdiSoyadi,Telefon,Eposta,Cinsiyet) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "') ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
for (int i = 0; i < this.Controls.Count; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}
frm1.dtst.Tables["müsteribil"].Clear();
frm1.müsterilistele();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
else MessageBox.Show("Kayıtlı Tc Kimlik veya Müşteri Adı girdiniz!");
}
}
}
FORM1 İçerisine Yazılacak Kodlar…
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form4 : Form
{
public Form1 frm1;
public Form4()
{
InitializeComponent();
}
private void Form4_Load(object sender, EventArgs e)
{
frm1.dtst.Tables["müsteribil"].Clear();
frm1.müsterilistele2();
}
private void button2_Click(object sender, EventArgs e)
{
frm1.dtst.Tables["müsteribil"].Clear();
frm1.müsterilistele();
this.Close();
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil", frm1.bag);
if (textBox2.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from müsteribil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "müsteribil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From müsteribil" +
" where(AdiSoyadi like '%" + textBox2.Text + "%' )";
frm1.dtst.Tables["müsteribil"].Clear();
adtr.Fill(frm1.dtst, "müsteribil");
frm1.bag.Close();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil", frm1.bag);
if (textBox1.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from müsteribil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "müsteribil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From müsteribil" +
" where(TcKimlik like '%" + textBox1.Text + "%' )";
frm1.dtst.Tables["müsteribil"].Clear();
adtr.Fill(frm1.dtst, "müsteribil");
frm1.bag.Close();
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil", frm1.bag);
if (textBox3.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from müsteribil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "müsteribil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From müsteribil" +
" where(Telefon like '%" + textBox3.Text + "%' )";
frm1.dtst.Tables["müsteribil"].Clear();
adtr.Fill(frm1.dtst, "müsteribil");
frm1.bag.Close();
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil", frm1.bag);
if (textBox4.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from müsteribil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "müsteribil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From müsteribil " +
" where(Eposta like '%" + textBox4.Text + "%' )";
frm1.dtst.Tables["müsteribil"].Clear();
adtr.Fill(frm1.dtst, "müsteribil");
frm1.bag.Close();
}
private void textBox5_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From müsteribil", frm1.bag);
if (textBox5.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from müsteribil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "müsteribil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From müsteribil" +
" where(Cinsiyet like '%" + textBox5.Text + "%' )";
frm1.dtst.Tables["müsteribil"].Clear();
adtr.Fill(frm1.dtst, "müsteribil");
frm1.bag.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string silinecek;
try
{
int row = 0;
for (row = 0; row <= dataGridView1.Rows.Count; row++)
{
if (dataGridView1.Rows[row].Cells[0].Selected == true || dataGridView1.Rows[row].Cells[1].Selected == true || dataGridView1.Rows[row].Cells[2].Selected == true || dataGridView1.Rows[row].Cells[3].Selected == true || dataGridView1.Rows[row].Cells[4].Selected == true)
{
break;
}
}
silinecek = dataGridView1.Rows[row].Cells[0].Value.ToString();
DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden eminmisiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from müsteribil WHERE TcKimlik='" + silinecek + "'";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["müsteribil"].Clear();
frm1.müsterilistele2();
}
}
catch
{ ;}
}
}
}
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.
FORM1 İçerisine Yazılacak Kodlar…
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form5 : Form
{
public Form1 frm1;
public Form5()
{
InitializeComponent();
}
private void Form5_Load(object sender, EventArgs e)
{
frm1.dtst.Tables["ürünbil"].Clear();
frm1.ürünlistele2();
}
private void label6_Click(object sender, EventArgs e)
{
}
private void label4_Click(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
frm1.dtst.Tables["ürünbil"].Clear();
frm1.ürünlistele();
this.Close();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", frm1.bag);
if (textBox1.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "ürünbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(BarkodNo like '%" + textBox1.Text + "%' )";
frm1.dtst.Tables["ürünbil"].Clear();
adtr.Fill(frm1.dtst, "ürünbil");
frm1.bag.Close();
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", frm1.bag);
if (textBox2.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "ürünbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(ÜrünAdi like '%" + textBox2.Text + "%' )";
frm1.dtst.Tables["ürünbil"].Clear();
adtr.Fill(frm1.dtst, "ürünbil");
frm1.bag.Close();
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", frm1.bag);
if (textBox3.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "ürünbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(Fiyat like '%" + textBox3.Text + "%' )";
frm1.dtst.Tables["ürünbil"].Clear();
adtr.Fill(frm1.dtst, "ürünbil");
frm1.bag.Close();
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", frm1.bag);
if (textBox4.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "ürünbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(ÜrünTürü like '%" + textBox4.Text + "%' )";
frm1.dtst.Tables["ürünbil"].Clear();
adtr.Fill(frm1.dtst, "ürünbil");
frm1.bag.Close();
}
private void textBox5_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", frm1.bag);
if (textBox5.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "ürünbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(ÜretimTarihi like '%" + textBox5.Text + "%' )";
frm1.dtst.Tables["ürünbil"].Clear();
adtr.Fill(frm1.dtst, "ürünbil");
frm1.bag.Close();
}
private void textBox6_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ürünbil", frm1.bag);
if (textBox6.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from ürünbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "ürünbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From ürünbil" +
" where(TüketimTarihi like '%" + textBox6.Text + "%' )";
frm1.dtst.Tables["ürünbil"].Clear();
adtr.Fill(frm1.dtst, "ürünbil");
frm1.bag.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string silinecek;
try
{
int row = 0;
for (row = 0; row <= dataGridView1.Rows.Count; row++)
{
if (dataGridView1.Rows[row].Cells[0].Selected == true || dataGridView1.Rows[row].Cells[1].Selected == true || dataGridView1.Rows[row].Cells[2].Selected == true || dataGridView1.Rows[row].Cells[3].Selected == true || dataGridView1.Rows[row].Cells[4].Selected == true || dataGridView1.Rows[row].Cells[5].Selected == true || dataGridView1.Rows[row].Cells[6].Selected == true)
{
break;
}
}
silinecek = dataGridView1.Rows[row].Cells[0].Value.ToString();
DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden eminmisiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from ürünbil WHERE BarkodNo='" + silinecek + "'";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["ürünbil"].Clear();
frm1.ürünlistele2();
}
}
catch
{ ;}
}
}
}
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.
