private void UpdateInvoiceDataTable()
{
try {
string connectionString = ConfigurationManager.ConnectionStrings["db-connection"].ConnectionString;
using (MySqlConnection connection = new MySqlConnection(connectionString)) {
connection.Open();
using (MySqlCommand command = new MySqlCommand("SELECT * FROM invoice")) {
using (MySqlDataAdapter invoiceDataAdapter = new MySqlDataAdapter()) {
command.Connection = connection;
invoiceDataAdapter.SelectCommand = command;
using (DataTable table = new DataTable()) {
invoiceDataAdapter.Fill(table);
InvoiceDataTable.DataSource = table;
InvoiceDataTable.DataBind();
InvoiceDataTable.HeaderRow.Cells[0].Text = "Invoice ID";
InvoiceDataTable.HeaderRow.Cells[1].Text = "Ordered";
InvoiceDataTable.HeaderRow.Cells[2].Text = "Shipped";
InvoiceDataTable.HeaderRow.Cells[3].Text = "Total Amount";
InvoiceDataTable.HeaderRow.Cells[4].Text = "Customer ID";
InvoiceDataTable.HeaderRow.Cells[5].Text = "Status";
}
}
}
connection.Close();
}
} catch (MySqlException err) {
Response.Write("<script>alert('Connection was interrupted.');</script>");
}
}
