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(); } }