private void btnAdd_Click(object sender, EventArgs e) { if (mysqlConn.connOpen() == true) { mysqlConn.insertBooking(tbCustomerID.Text, tbFlightID.Text, dtBookingDateTime.Text, tbBookingTotalCost.Text); dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblBooking`").Tables[0]; } mysqlConn.connClose(); }
private void updateInfo() { if (mysqlConn.connOpen() == true) { dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblBooking` where BookinID='" + tbBookingID.Text + "'").Tables[0]; } mysqlConn.connClose(); }
public BookingsForm() { InitializeComponent(); mysqlConn = new BookingsDbConn(); mysqlConn.connect(); if (mysqlConn.connOpen() == true) { dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblBooking`").Tables[0]; } mysqlConn.connClose(); }