NYP-2 2016 5. Hafta Uygulamaları
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 |
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 { // } } } } } |
1 2 3 4 5 6 |
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ı