Beispiel #1
0
        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 = "";
        }
Beispiel #2
0
        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 = "";
        }
Beispiel #3
0
        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;;
        }