private void btnAdd_Click(object sender, EventArgs e)
{
if (mysqlConn.connOpen() == true)
{
mysqlConn.insertFlight(dtDepartureDateTime.Text, dtArrivalDateTime.Text, tbDepartureCity.Text, tbArrivalCity.Text, tbPrice.Text);
dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblFlight`").Tables[0];
}
mysqlConn.connClose();
}
public FlightsForm()
{
InitializeComponent();
mysqlConn = new FlightsDbConn();
mysqlConn.connect();
if (mysqlConn.connOpen() == true)
{
dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblFlight`").Tables[0];
}
mysqlConn.connClose();
}