-kaydet- int ort = 0; int not1, not2; not1 = Convert.ToInt32(textBox4.Text); not2 = Convert.ToInt32(textBox5.Text); ort = (not1 + not2) / 2; OleDbCommand cmd = new OleDbCommand(); cmd.Connection = baglan; cmd.CommandText = "INSERT INTO Tablo1(id,ad,soyad,not1,not2,ort,ktarihi) VALUES (@id,@ad,@soyad,@not1,@not2,@ort,@ktarihi)"; cmd.Parameters.AddWithValue("@id", textBox1.Text.Trim()); cmd.Parameters.AddWithValue("@ad", textBox2.Text.Trim()); cmd.Parameters.AddWithValue("@soyad", textBox3.Text.Trim()); cmd.Parameters.AddWithValue("@not1", textBox4.Text.Trim()); cmd.Parameters.AddWithValue("@not2", textBox5.Text.Trim()); cmd.Parameters.AddWithValue("@ort", ort); cmd.Parameters.AddWithValue("@ktarihi", dateTimePicker1.Value); baglan.Open(); cmd.ExecuteNonQuery(); baglan.Close(); MessageBox.Show("kayıt başarılı"); -güncelle- int ort = 0; int not1, not2; not1 = Convert.ToInt32(textBox4.Text); not2 = Convert.ToInt32(textBox5.Text); ort = (not1 + not2) / 2; OleDbCommand cmd = new OleDbCommand(); cmd.Connection = baglan; cmd.CommandText = "UPDATE Tablo1 SET id=@id,ad=@ad,soyad=@soyad,not1=@not1,not2=@not2 WHERE id=@id"; cmd.Parameters.AddWithValue("@id", textBox1.Text.Trim()); cmd.Parameters.AddWithValue("@ad", textBox2.Text.Trim()); cmd.Parameters.AddWithValue("@soyad", textBox3.Text.Trim()); cmd.Parameters.AddWithValue("@not1", textBox4.Text.Trim()); cmd.Parameters.AddWithValue("@not2", textBox5.Text.Trim()); cmd.Parameters.AddWithValue("@ort", ort); baglan.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("başarılı"); baglan.Close(); -silme- OleDbCommand cmd = new OleDbCommand(); cmd.Connection = baglan; cmd.CommandText = "DELETE * FROM Tablo1 WHERE id=@a"; cmd.Parameters.AddWithValue("@a", textBox1.Text); baglan.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("kayıt silindi"); baglan.Close(); -listele- listView1.Items.Clear(); baglan.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = baglan; cmd.CommandText = "SELECT * FROM Tablo1"; OleDbDataAdapter adp = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); adp.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { listView1.Items.Add(dt.Rows["id"].ToString()); listView1.Items.SubItems.Add(dt.Rows["ad"].ToString()); listView1.Items.SubItems.Add(dt.Rows["soyad"].ToString()); listView1.Items.SubItems.Add(dt.Rows["not1"].ToString()); listView1.Items.SubItems.Add(dt.Rows["not2"].ToString()); listView1.Items.SubItems.Add(dt.Rows["ort"].ToString()); listView1.Items.SubItems.Add(dt.Rows["ktarihi"].ToString()); } baglan.Close();