Exemple #1
0
        public updateStudents()
        {
            InitializeComponent();
            MySQLi           sql    = new MySQLi();
            SQLiteDataReader reader = sql.query("SELECT * FROM `students`");
            int i = 0;

            foreach (DbDataRecord record in reader)
            {
                students[0, i] = record["fio"].ToString();
                comboBox1.Items.Add(record["fio"].ToString());
                students[1, i] = record["b_day"].ToString();
                students[2, i] = record["mobile"].ToString();
                students[3, i] = record["address"].ToString();
                students[4, i] = record["fio_parent"].ToString();
                students[5, i] = record["fio_mobile"].ToString();
                i++;
            }

            /*try
             * {
             *  today = monthCalendar1.TodayDate;
             * }
             * catch(NullReferenceException)
             * {
             *
             * }
             * /*monthCalendar1.MinDate = new DateTime(today.Year - 60, today.Month, today.Day);
             * monthCalendar1.MaxDate = today;*/
        }
Exemple #2
0
 private void button1_Click(object sender, EventArgs e)
 {
     if ((textBox1.Text == "") || (textBox4.Text == "") || (textBox5.Text == "") ||
         (textBox1.Text == " ") || (textBox4.Text == " ") || (textBox5.Text == " ") ||
         (maskedTextBox1.Text == "") || (maskedTextBox2.Text == "") ||
         (maskedTextBox3.Text == ""))
     {
         MessageBox.Show("Введите все данные с форм");
     }
     else
     {
         string[] data = new string[10];
         data[0] = textBox1.Text;
         data[1] = maskedTextBox1.Text;
         data[2] = maskedTextBox2.Text;
         data[3] = textBox4.Text;
         data[4] = textBox5.Text;
         data[5] = maskedTextBox3.Text;
         MySQLi sql   = new MySQLi();
         string query = "INSERT INTO `students` VALUES(null, \"" + data[0] + "\", \"" + data[1] + "\", \"" + data[2] + "\", \"" + data[3] + "\", \"" + data[4] + "\", \"" + data[5] + "\");";
         sql.query(query);
         MessageBox.Show("Запись добавлена");
         this.DialogResult = DialogResult.OK;
         this.Close();
     }
 }
Exemple #3
0
        private void addRowsFromDB()
        {
            MySQLi           sql    = new MySQLi();
            SQLiteDataReader reader = sql.query("SELECT * FROM `students`");

            string[] data = new string[10];
            foreach (DbDataRecord record in reader)
            {
                data[0] = record["fio"].ToString();
                data[1] = record["b_day"].ToString();
                data[2] = record["mobile"].ToString();
                data[3] = record["address"].ToString();
                data[4] = record["fio_parent"].ToString();
                data[5] = record["fio_mobile"].ToString();
                dataGridView1.Rows.Add(data);
            }
        }