protected void UpdateViewComputer(Object sender, EventArgs e) { MySqlConnection con = new MySqlConnection("Data Source=localhost;Initial Catalog=sys; User Id=root;password=symbor97;"); MySqlCommand cmd = new MySqlCommand("Select * from computers", con); con.Open(); MySqlDataAdapter adp = new MySqlDataAdapter(cmd); DataTable tab = new DataTable(); adp.Fill(tab); Computer comp = new Computer(); String htmlText = ""; foreach (DataRow row in tab.Rows) { comp.AddAllComponents(row, tab.Columns.Count); htmlText += comp.BuildHtmlComputerItem(row["ConfigurationName"].ToString()); } ComputerComponentContent.Visible = false; computerDisplayList.Visible = true; ContactsPage.Visible = false; FeedbackForm.Visible = false; computerConfigList.InnerHtml = htmlText; con.Close(); ProductsList.DataSource = null; ProductsList.DataBind(); }