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();
}
