private void button3_Click(object sender, EventArgs e)
{
listele = new Listele();
SqlConnection con = new SqlConnection(conString);
string sorgu;
sorgu = " Delete from Users where UseId = '" + textBox9.Text + "' and UsName = '" + textBox10.Text + "'";
listele.DbSil(sorgu);
MessageBox.Show(textBox9.Text + ", " + textBox10.Text + " kişi silindi");
textBox9.Text = "";
textBox10.Text = "";
}
private void button2_Click(object sender, EventArgs e)
{
listele = new Listele();
SqlConnection con = new SqlConnection(conString);
string sorgu;
sorgu = " Delete from Books where ISBN = '" + textBox6.Text + "' and BookTitle = '" + textBox7.Text + "' and Publisher='" + textBox8.Text + "'";
listele.DbSil(sorgu);
MessageBox.Show(textBox6.Text + ", " + textBox7.Text + ", " + textBox8.Text + " kitabı silindi");
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
}
private void button7_Click(object sender, EventArgs e)
{
listele = new Listele();
//kitap listele
groupBox3.Visible = true;
groupBox2.Visible = true;
groupBox1.Visible = false;
groupBox4.Visible = false;
groupBox5.Visible = false;
sorgu = "SELECT [ISBN],[BookTitle],[BookAuthor],[YearOfPublication],[Publisher] ,[ImageURLM] FROM Books";
table = listele.DbListele(sorgu);
dataGridView1.DataSource = table;;
}