public void UpdateTable() { con = new BDConnection("Students", "127.0.0.1", "3306", "root", ""); con.OpenConnection(); conMy = con.returnCell(); ds = new DataSet(); adapter = new MySqlDataAdapter("SELECT * FROM students", conMy); adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; ds.Tables.Clear(); con.CloseConnection(); }
private void button1_Click(object sender, EventArgs e) { con = new BDConnection("Students", "127.0.0.1", "3306", "root", ""); con.OpenConnection(); conMy = con.returnCell(); ds = new DataSet(); adapter = new MySqlDataAdapter("INSERT INTO students.students(data, name, surname, otch) " + "VALUES(" + "'" + DateTime.Now.ToShortDateString() + "'" + ", " + "'" + textName.Text.ToString() + "'" + ", " + "'" + textSurname.Text.ToString() + "'" + ", " + "'" + textOtch.Text.ToString() + "'" + ")", conMy); adapter.Fill(ds); ds.Tables.Clear(); con.CloseConnection(); Spisok spisok = new Spisok(); spisok.UpdateTable(); }
private void btnDel_Click(object sender, EventArgs e) { try { con = new BDConnection("Students", "127.0.0.1", "3306", "root", ""); con.OpenConnection(); conMy = con.returnCell(); ds = new DataSet(); adapter = new MySqlDataAdapter("DELETE FROM students WHERE idStudents=" + textNumberDel.Text.ToString(), conMy); adapter.Fill(ds); ds.Tables.Clear(); con.CloseConnection(); UpdateTable(); textNumberDel.Text = ""; } catch { MessageBox.Show("Введите номер строки, которую необходимо удалить!", "Ошибка!"); } }