Пример #1
0
        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();
        }