Sınav Hatırlatıcı C#.NET

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

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms;</div> namespace sinav_bildir { public partial class Form1 : Form { public Form1() { InitializeComponent(); } OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb"); OleDbCommand kmt = new OleDbCommand(); OleDbDataAdapter adtr = new OleDbDataAdapter(); DataSet dtst = new DataSet(); string[] dersadi = new string[10]; string[] sinav_tarihi = new string[10]; int r, g, b; Random rs = new Random(); //Label[] labelDizi; public void sinavlar() { TimeSpan tfark; int i = 0; string gunfark; try { bag.Open(); kmt.Connection = bag; kmt.CommandText = "Select * from sinavbil"; OleDbDataReader oku; oku = kmt.ExecuteReader(); while (oku.Read()) { tfark = DateTime.Parse(DateTime.Now.ToLongDateString()) - DateTime.Parse(oku[1].ToString()); gunfark = tfark.TotalDays.ToString(); if (int.Parse(gunfark) == -1) {</div> dersadi[i] = oku[0].ToString(); sinav_tarihi[i] = oku[1].ToString(); if (i == 0) { label3.Visible = true; label3.Text = dersadi[i] + "      " + sinav_tarihi[i];</div> } if (i == 1) { label4.Visible = true; label4.Text = dersadi[i] + "      " + sinav_tarihi[i]; } if (i == 2) { label5.Visible = true; label5.Text = dersadi[i] + "      " + sinav_tarihi[i]; } if (i == 3) { label6.Visible = true; label6.Text = dersadi[i] + "      " + sinav_tarihi[i]; }i++; } } bag.Close(); oku.Dispose(); } catch { ; } } private void Form1_Load(object sender, EventArgs e) { label3.Visible = false; label4.Visible = false; label5.Visible = false; label6.Visible = false; sinavlar(); timer1.Enabled = true; timer1.Interval = 100;</div> }</div> private void btnKaydet_Click(object sender, EventArgs e) { try { if (textBox1.Text != "") { bag.Open(); kmt.Connection = bag; kmt.CommandText = "INSERT INTO sinavbil(DersAdi,SinavTarihi) VALUES ('" + textBox1.Text + "','" + dateTimePicker1.Text + "') "; kmt.ExecuteNonQuery(); kmt.Dispose(); bag.Close(); textBox1.Clear(); sinavlar(); MessageBox.Show("Kayıt işlemi tamamlandı !"); } else MessageBox.Show("Boş alanları doldurunuz !"); } catch { ; } }</div> private void timer1_Tick(object sender, EventArgs e) { r = rs.Next(256); g = rs.Next(256); b = rs.Next(256); label3.ForeColor = Color.FromArgb(r, g, b); label4.ForeColor = Color.FromArgb(r, g, b); label5.ForeColor = Color.FromArgb(r, g, b); label6.ForeColor = Color.FromArgb(r, g, b); } } }