private void textBox5_TextChanged(object sender, EventArgs e) { DatabaseIslem di = new DatabaseIslem(); string sorguara = $"select *from Urunler where Adi like '%{textBox5.Text}%'"; DataTable dt = Sorgu.SQLSorguCalistir(sorguara); dataGridView1.DataSource = di.UrunListe(dt); }
private void button3_Click(object sender, EventArgs e) { DatabaseIslem di = new DatabaseIslem(); string stoksorgusu = $"select * from Urunler where Stok=0"; DataTable dt = Sorgu.SQLSorguCalistir(stoksorgusu); dataGridView1.DataSource = di.UrunListe(dt); textBox3.BackColor = Color.Black; textBox2.BackColor = Color.White; textBox1.BackColor = Color.White; }
private void button2_Click(object sender, EventArgs e) { DatabaseIslem di = new DatabaseIslem(); string sorgustok = $"select * from Urunler"; DataTable dt = Sorgu.SQLSorguCalistir(sorgustok); dataGridView1.DataSource = di.UrunListe(dt); dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView1.Columns[0].DefaultCellStyle.BackColor = Color.Black; dataGridView1.Columns[2].DefaultCellStyle.BackColor = Color.Black; dataGridView1.Columns[0].DefaultCellStyle.ForeColor = Color.White; dataGridView1.Columns[2].DefaultCellStyle.ForeColor = Color.White; dataGridView1.RowsDefaultCellStyle.Font = new Font("Comic Sans", 12, FontStyle.Bold); dataGridView1.DefaultCellStyle.SelectionBackColor = Color.Red; dataGridView1.DefaultCellStyle.SelectionForeColor = Color.White; }