SQL İLE HEPSİ

SİLME

protected void Button3_Click(object sender, EventArgs e)

    {

        SqlConnection bag = new SqlConnection(@"Data Source=.\SQLEXPRESS; Initial Catalog=personelbilg; Integrated Security=True;");

        bag.Open();

        SqlCommand co = new SqlCommand();

        co.Connection = bag;

        String S1, S2, S3, S4, S5, S6, S7, S8;

        S1 = TextBox1.Text;

        S2 = TextBox2.Text;

        S3 = TextBox3.Text;

        S4 = TextBox4.Text;

        S5 = TextBox5.Text;

        S6 = TextBox6.Text;

        S7 = TextBox7.Text;

        S8 = TextBox8.Text;

        co.CommandText = "DELETE from personeltbl where pertc=\'" + S1 + "\' or ad=\'" + S2 + "\' or soyad=\'" + S3 + "\' or tel=\'" + S4 + "\' or adres=\'" + S5 + "\' or dogtar=\'" + S6 + "\' or boy=\'" + S7 + "\' or maas=\'" + S8 + "\'";

        co.ExecuteNonQuery();

        TextBox1.Text = "";

        TextBox2.Text = "";

        TextBox3.Text = "";

        TextBox4.Text = "";

        TextBox5.Text = "";

        TextBox6.Text = "";

        TextBox7.Text = "";

        TextBox8.Text = "";

        co.CommandText = "Select * from personeltbl";

        SqlDataAdapter ad = new SqlDataAdapter();

        ad.SelectCommand = co;

        DataSet ds = new DataSet();

        ad.Fill(ds, "personeltbl");

        ListBox1.Items.Clear();

        foreach (DataTable table in ds.Tables)

            foreach (DataRow kyt in table.Rows)

                ListBox1.Items.Add(kyt["pertc"] + " "

                    + kyt["ad"] + " " + kyt["soyad"] + " " + kyt["tel"] + " " + kyt["adres"] + " " + kyt["dogtar"] + " " + kyt["boy"] + " " + kyt["maas"]);

        bag.Close();

    }

 

 

 

 

 

 

KAYIT YAPMA

protected void Button1_Click(object sender, EventArgs e)

    {

 

        SqlConnection bag = new SqlConnection(@"Data Source=.\SQLEXPRESS; Initial Catalog=personelbilg; Integrated Security=True;");

        bag.Open();

        SqlCommand co = new SqlCommand();

        co.Connection =bag;

        String S1, S2, S3, S4, S5, S6, S7, S8;

        S1 = TextBox1.Text;

        S2 = TextBox2.Text;

        S3 = TextBox3.Text;

        S4 = TextBox4.Text;

        S5 = TextBox5.Text;

        S6 = TextBox6.Text;

        S7 = TextBox7.Text;

        S8 = TextBox8.Text;

        co.CommandText = "INSERT INTO personeltbl(pertc,ad,soyad,tel,adres,dogtar,boy,maas)"

                     + "VALUES (\'" + S1 + "\',\'" + S2 + "\',\'" + S3 + "\',\'" + S4 + "\',\'" + S5 + "\',\'" + S6 + "\',\'" + S7 + "\',\'" + S8 + "\')";

        co.ExecuteNonQuery();

        TextBox1.Text = "";

        TextBox2.Text = "";

        TextBox3.Text = "";

        TextBox4.Text = "";

        TextBox5.Text = "";

        TextBox6.Text = "";

        TextBox7.Text = "";

        TextBox8.Text = "";

        co.CommandText = "Select * from personeltbl";

        SqlDataAdapter ad = new SqlDataAdapter();

        ad.SelectCommand = co;

        DataSet ds = new DataSet();

        ad.Fill(ds, "personeltbl");

        ListBox1.Items.Clear();

        foreach (DataTable table in ds.Tables)

            foreach (DataRow kyt in table.Rows)

                ListBox1.Items.Add(kyt["pertc"] + " "

                    + kyt["ad"] + " " + kyt["soyad"] + " " + kyt["tel"] + " " + kyt["adres"] + " " + kyt["dogtar"] + " " + kyt["boy"] + " " + kyt["maas"]);

        bag.Close();

       

    }

 

 

 

 

 

ARAMA

protected void Button2_Click(object sender, EventArgs e)

    {

        SqlConnection bag = new SqlConnection(@"Data Source=.\SQLEXPRESS; Initial Catalog=personelbilg; Integrated Security=True;");

        bag.Open();

        SqlCommand co = new SqlCommand();

        co.Connection = bag;

        String S1;

        S1 = TextBox1.Text;

        TextBox1.Text = ""; // ARAMADA OR KULLANILIR

        TextBox2.Text = "";

        TextBox3.Text = "";

        TextBox4.Text = "";

        TextBox5.Text = "";

        TextBox6.Text = "";

        TextBox7.Text = "";

        TextBox8.Text = "";

 

        co.CommandText = "Select * from personeltbl where pertc=\'" + S1 + "\'";

        SqlDataAdapter ad = new SqlDataAdapter();

        ad.SelectCommand = co;

        DataSet ds = new DataSet();

        ad.Fill(ds, "personeltbl");

        ListBox1.Items.Clear();

        foreach (DataTable table in ds.Tables)

            foreach (DataRow kyt in table.Rows)

                ListBox1.Items.Add(kyt["pertc"] + " "

                    + kyt["ad"] + " " + kyt["soyad"] + " " + kyt["tel"] + " " + kyt["adres"] + " " + kyt["dogtar"] + " " + kyt["boy"] + " " + kyt["maas"]);

        bag.Close();

    }

LİSTELEME

protected void Button5_Click(object sender, EventArgs e)

    {

        SqlConnection bag = new SqlConnection(@"Data Source=.\SQLEXPRESS; Initial Catalog=personelbilg; Integrated Security=True;");

        bag.Open();

        SqlCommand co = new SqlCommand();

        co.Connection = bag;

        co.CommandText = "Select * from personeltbl";

        SqlDataAdapter ad = new SqlDataAdapter();

        ad.SelectCommand = co;

        DataSet ds = new DataSet();

        ad.Fill(ds, "personeltbl");

        ListBox1.Items.Clear();

        foreach (DataTable table in ds.Tables)

            foreach (DataRow kyt in table.Rows)

                ListBox1.Items.Add(kyt["pertc"] + " "

                    + kyt["ad"] + " " + kyt["soyad"] + " " + kyt["tel"] + " " + kyt["adres"] + " " + kyt["dogtar"] + " " + kyt["boy"] + " " + kyt["maas"]);

        bag.Close();

    }

 

GÜNCELLEME

protected void Button4_Click(object sender, EventArgs e)

    {

        SqlConnection bag = new SqlConnection(@"Data Source=.\SQLEXPRESS; Initial Catalog=personelbilg; Integrated Security=True;");

        bag.Open();

        SqlCommand co = new SqlCommand();

        co.Connection = bag;

        String S1, S2, S3, S4, S5, S6, S7, S8;

 

        S1 = TextBox1.Text;

        S2 = TextBox2.Text;

        S3 = TextBox3.Text;

        S4 = TextBox4.Text;

        S5 = TextBox5.Text;

        S6 = TextBox6.Text;

        S7 = TextBox7.Text;

        S8 = TextBox8.Text;

       

       

        if (S2 != "")

        {

            co.CommandText = "UPDATE personeltbl SET ad=\'" + S2 + "\' where pertc=\'" + S1 + "\'";

            co.ExecuteNonQuery();

        }

        if (S3 != "")

        {

            co.CommandText = "UPDATE personeltbl SET soyad=\'" + S3 + "\' where pertc=\'" + S1 + "\'";

            co.ExecuteNonQuery();

        }

        if (S4 != "")

        {

            co.CommandText = "UPDATE personeltbl SET tel=\'" + S4 + "\' where pertc=\'" + S1 + "\'";

            co.ExecuteNonQuery();

        }

        if (S5 != "")

        {

            co.CommandText = "UPDATE personeltbl SET adres=\'" + S5 + "\' where pertc=\'" + S1 + "\'";

            co.ExecuteNonQuery();

        }

        if (S6 != "")

        {

            co.CommandText = "UPDATE personeltbl SET dogtar=\'" + S6 + "\' where pertc=\'" + S1 + "\'";

            co.ExecuteNonQuery();

        }

        if (S7 != "")

        {

            co.CommandText = "UPDATE personeltbl SET boy=\'" + S7 + "\' where pertc=\'" + S1 + "\'";

            co.ExecuteNonQuery();

        }

        if (S8 != "")

        {

            co.CommandText = "UPDATE personeltbl SET maas=\'" + S8 + "\' where pertc=\'" + S1 + "\'";

            co.ExecuteNonQuery();

        }

        TextBox1.Text = "";

             TextBox2.Text = "";

             TextBox3.Text = "";

             TextBox4.Text = "";

              TextBox5.Text = "";

              TextBox6.Text = "";

              TextBox7.Text = "";

              TextBox8.Text = "";

              co.CommandText = "Select * from personeltbl";

              SqlDataAdapter ad = new SqlDataAdapter();

        ad.SelectCommand = co;

        DataSet ds = new DataSet();

        ad.Fill(ds, "personeltbl");

        ListBox1.Items.Clear();

        foreach (DataTable table in ds.Tables)

                  foreach (DataRow kyt in table.Rows)

                ListBox1.Items.Add(kyt["pertc"] + " "

                    + kyt["ad"] + " " + kyt["soyad"] + " " + kyt["tel"] + " " + kyt["adres"] + " " + kyt["dogtar"] + " " + kyt["boy"] + "    " + kyt["maas"]);

             bag.Close();

    }