private void accountsGridLoad()
{
try
{
ConnectionClass.OpenConnection();
DataSet AccountsDS = new DataSet();
AccountsDA = new MySqlDataAdapter("SELECT * FROM tblaccounts", ConnectionClass.con);
AccountsDA.Fill(AccountsDS);
grdAccounts.DataSource = AccountsDS.Tables[0];
}
catch (MySqlException e)
{
MessageBox.Show("Error contacting the database. Refresh your connection and try again.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void listContentLoad()
{
try
{
ConnectionClass.OpenConnection();
DataSet ListContentsDS = new DataSet();
ListContentDA = new MySqlDataAdapter("SELECT * FROM collatedlists", ConnectionClass.con);
ListContentDA.Fill(ListContentsDS);
grdListIssues.DataSource = ListContentsDS.Tables[0];
ConnectionClass.CloseConnection();
}
catch (MySqlException e)
{
MessageBox.Show("Error contacting the database. Refresh your connection and try again.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void publishersGridLoad()
{
try
{
ConnectionClass.OpenConnection();
DataSet PublisherDS = new DataSet();
PublisherDA = new MySqlDataAdapter("SELECT * FROM tblpublisher", ConnectionClass.con);
PublisherDA.Fill(PublisherDS);
grdPublisher.DataSource = PublisherDS.Tables[0];
ConnectionClass.CloseConnection();
}
catch (MySqlException e)
{
MessageBox.Show("Error contacting the database. Refresh your connection and try again.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}