NYP-2 2016 5. Hafta Uygulamaları

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace depo
{
    public partial class Form1 : Form
    {
        MySqlDataAdapter da;
        DataTable dt;

        public Form1()
        {
            InitializeComponent();

            MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();
            bag.Server = "localhost";
            bag.UserID = "root";
            bag.Password = "123456";
            bag.Database = "hafta5_16_1";

            MySqlConnection conn = new MySqlConnection(bag.ToString());
            MySqlCommand cmd_sel = new MySqlCommand("select id,isim,miktar from depo;", conn);
            MySqlCommand cmd_ins = new MySqlCommand("insert into depo(isim,miktar) values (@isim,@miktar);",conn);
            cmd_ins.Parameters.Add("@isim", MySqlDbType.VarChar, 45, "isim");
            cmd_ins.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

            MySqlCommand cmd_del = new MySqlCommand("delete from depo where id=@id", conn);
            cmd_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

            MySqlCommand cmd_upd = new MySqlCommand("update depo set isim=@isim, miktar=@miktar where id=@id",conn);
            cmd_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");
            cmd_upd.Parameters.Add("@isim", MySqlDbType.VarChar, 45, "isim");
            cmd_upd.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

            da = new MySqlDataAdapter();
            da.SelectCommand = cmd_sel;
            da.InsertCommand = cmd_ins;
            da.DeleteCommand = cmd_del;
            da.UpdateCommand = cmd_upd;

            verigetir();
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            int miktar;
            bool kontrol = Int32.TryParse(tmiktar.Text, out miktar);

            if (kontrol && turun.Text.Length > 0)
            {

                try
                {
                    DataRow dr = dt.NewRow(); // mevcut tablodan yeni bir satir turettik
                    dr["isim"] = turun.Text;
                    dr["miktar"] = miktar;
                    dt.Rows.Add(dr); // olusturulan yeni satir tabloya eklendi
                    da.Update(dt);
                    turun.Clear();
                    tmiktar.Clear();

                }
                catch
                { 
                }

                verigetir();
            }



        }


        private void verigetir()
        {
            try
            {
                dt = new DataTable();
                da.Fill(dt);
                lurun.Items.Clear();
                lmiktar.Items.Clear();

                int satirsay = dt.Rows.Count;
                for (int i = 0; i < satirsay; i++)
                {
                    lurun.Items.Add(dt.Rows[i]["isim"]);
                    lmiktar.Items.Add(dt.Rows[i]["miktar"]);
                }
            }
            catch { 
            
            }
        
        
        }

        private void bsil_Click(object sender, EventArgs e)
        {

            int index = lurun.SelectedIndex;
            if (index > -1)
            {
                try
                {
                    dt.Rows[index].Delete();
                    da.Update(dt);
                }
                catch
                { 
                 
                }
                verigetir();
            }



        }

        private void bguncelleme_Click(object sender, EventArgs e)
        {
            int index = lurun.SelectedIndex;
             int miktar;
            bool kontrol = Int32.TryParse(tmiktar.Text, out miktar);

            if (kontrol && index>-1 && turun.Text.Length > 0)
            {

                try
                {
                    DataRow dr = dt.Rows[index]; // mevcut satiri getirdik
                    dr["isim"] = turun.Text;
                    dr["miktar"] = miktar;
                    da.Update(dt);
                    turun.Clear();
                    tmiktar.Clear();
                    verigetir();
                }
                catch
                { 
                    //
                }
            }


        }

    }
}

CREATE SCHEMA `hafta5_16_1` DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci ;
CREATE TABLE `hafta5_16_1`.`depo` (
  `id` INT NOT NULL AUTO_INCREMENT COMMENT '',
  `isim` VARCHAR(45) NULL COMMENT '',
  `miktar` INT NULL COMMENT '',
  PRIMARY KEY (`id`)  COMMENT '');

 

NYP-2 2016 5. Hafta Uygulamaları