private void UpdateHomeBanner()
{
// need to reterive the info from database
string selectSQL = "SELECT * FROM home_banner";
DataTable dt = new DataTable();
MySqlConnection connection = new MySqlConnection(Master.connectionString);
MySqlCommand cmd = new MySqlCommand(selectSQL, connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
try
{
using (connection)
{
// Open database connection
connection.Open();
// Fill the Data to DataAdaptor
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
GridHomeBannerData.DataSource = dt;
GridHomeBannerData.DataBind();
}
}
}
catch (Exception error)
{
LblDatabaseError.Text = error.ToString();
}
}
private void UpdateHomeBanner()
{
// Initialize the Obj
adm = new Admin();
// Set User controls
(this.Master.FindControl("HeaderPanel") as Panel).Visible = false;
(this.Master.FindControl("AdminHeaderPanel") as Panel).Visible = true;
(this.Master.FindControl("FooterPanel") as Panel).Visible = false;
// need to reterive the info from database
string selectSQL = "SELECT * FROM home_banner";
DataTable dt = new DataTable();
MySqlConnection connection = new MySqlConnection(adm.connectionString);
MySqlCommand cmd = new MySqlCommand(selectSQL, connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
try
{
using (connection)
{
// Open database connection
connection.Open();
// Fill the Data to DataAdaptor
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
GridHomeBannerData.DataSource = dt;
GridHomeBannerData.DataBind();
}
}
}
catch (Exception error)
{
LblDatabaseError.Text = error.ToString();
}
}
