private void stocksGridLoad()
{
try
{
ConnectionClass.OpenConnection();
DataSet StockDS = new DataSet();
StockDA = new MySqlDataAdapter("SELECT * FROM tblstock", ConnectionClass.con);
StockDA.Fill(StockDS);
grdStock.DataSource = StockDS.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);
}
}