Example #1
0
        private void ComboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            lstbxRows.Items.Clear();
            lblDetail1.Visible   = false;
            lblDetail2.Visible   = false;
            lblDetail3.Visible   = false;
            lblDetail4.Visible   = false;
            rchbxDetail1.Visible = false;
            rchbxDetail2.Visible = false;
            rchbxDetail3.Visible = false;
            rchbxDetail4.Visible = false;

            SqlConnection cnn = new SqlConnection(@"server=.\MSSQLSERVER01;database=Northwnd;trusted_connection=true");

            cnn.Open();

            if (cmbbxTables.SelectedItem.ToString() == "Suppliers")
            {
                SqlCommand cmd = new SqlCommand("select SupplierID,CompanyName,ContactName,Phone from Suppliers", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Suppliers supp = new Suppliers(rdr.GetInt32(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1),
                                                   rdr.IsDBNull(2) ? "" : rdr.GetString(2), rdr.IsDBNull(3) ? "" : rdr.GetString(3));

                    lstbxRows.Items.Add(supp);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Orders")
            {
                SqlCommand cmd = new SqlCommand("select OrderID,CustomerID,EmployeeID,ShipName from Orders", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Orders order = new Orders(rdr.GetInt32(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1), rdr.GetInt32(2), rdr.IsDBNull(3) ? "" : rdr.GetString(3));

                    lstbxRows.Items.Add(order);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Categories")
            {
                SqlCommand cmd = new SqlCommand("select CategoryID,CategoryName from Categories", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Categories category = new Categories(rdr.GetInt32(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1));

                    lstbxRows.Items.Add(category);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Customers")
            {
                SqlCommand cmd = new SqlCommand("select CustomerID,CompanyName,Phone from Customers", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Customers customer = new Customers(rdr.IsDBNull(0) ? "" : rdr.GetString(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1), rdr.IsDBNull(2) ? "" : rdr.GetString(2));

                    lstbxRows.Items.Add(customer);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "CustomerCustomerDemo")
            {
                SqlCommand cmd = new SqlCommand("select CustomerID,CustomerTypeID from CustomerCustomerDemo", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    CustomerCustomerDemo cust = new CustomerCustomerDemo(rdr.IsDBNull(0) ? "" : rdr.GetString(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1));

                    lstbxRows.Items.Add(cust);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "CustomerDemographics")
            {
                SqlCommand cmd = new SqlCommand("select CustomerTypeID,CustomerDesc from CustomerDemographics", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    CustomerDemographics cd = new CustomerDemographics(rdr.IsDBNull(0) ? "" : rdr.GetString(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1));

                    lstbxRows.Items.Add(cd);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Employees")
            {
                SqlCommand cmd = new SqlCommand("select EmployeeID,FirstName,LastName,BirthDate from Employees", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Employees emp = new Employees(rdr.GetInt32(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1), rdr.IsDBNull(2) ? "" : rdr.GetString(2), rdr.GetDateTime(3));

                    lstbxRows.Items.Add(emp);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "EmployeeTerritories")
            {
                SqlCommand cmd = new SqlCommand("select EmployeeID,TerritoryID from EmployeeTerritories", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    EmployeeTerritories empt = new EmployeeTerritories(rdr.GetInt32(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1));

                    lstbxRows.Items.Add(empt);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "OrderDetails")
            {
                SqlCommand cmd = new SqlCommand("select OrderID,ProductID from [Order Details]", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    OrderDetails orderd = new OrderDetails(rdr.GetInt32(0), rdr.GetInt32(1));

                    lstbxRows.Items.Add(orderd);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Products")
            {
                SqlCommand cmd = new SqlCommand("select ProductID,ProductName from Products", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Products product = new Products(rdr.GetInt32(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1));

                    lstbxRows.Items.Add(product);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Region")
            {
                SqlCommand cmd = new SqlCommand("select RegionID from Region", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Region region = new Region(rdr.GetInt32(0));

                    lstbxRows.Items.Add(region);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Shippers")
            {
                SqlCommand cmd = new SqlCommand("select ShipperID,CompanyName from Shippers", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Shippers ship = new Shippers(rdr.GetInt32(0), rdr.IsDBNull(1) ? "" : rdr.GetString(1));

                    lstbxRows.Items.Add(ship);
                }
                rdr.Close();
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Territories")
            {
                SqlCommand cmd = new SqlCommand("select TerritoryID,RegionID from Territories", cnn);

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    Territories terr = new Territories(rdr.IsDBNull(0) ? "" : rdr.GetString(0), rdr.GetInt32(1));

                    lstbxRows.Items.Add(terr);
                }
                rdr.Close();
            }
            cnn.Close();
        }
Example #2
0
        private void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            lblDetail1.Visible   = false;
            lblDetail2.Visible   = false;
            lblDetail3.Visible   = false;
            lblDetail4.Visible   = false;
            rchbxDetail1.Visible = false;
            rchbxDetail2.Visible = false;
            rchbxDetail3.Visible = false;
            rchbxDetail4.Visible = false;

            if (cmbbxTables.SelectedItem.ToString() == "Suppliers")
            {
                lblDetail1.Text    = "SupplierID";
                lblDetail2.Text    = "Company Name";
                lblDetail3.Text    = "Contact Name";
                lblDetail4.Text    = "Phone";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                lblDetail3.Visible = true;
                lblDetail4.Visible = true;
                Suppliers supp = (Suppliers)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = supp.SupplierID.ToString();
                rchbxDetail2.Text    = supp.CompanyName;
                rchbxDetail3.Text    = supp.ContactName;
                rchbxDetail4.Text    = supp.Phone;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
                rchbxDetail3.Visible = true;
                rchbxDetail4.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Orders")
            {
                lblDetail1.Text    = "OrderID";
                lblDetail2.Text    = "CustomerID";
                lblDetail3.Text    = "EmployeeID";
                lblDetail4.Text    = "ShipName";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                lblDetail3.Visible = true;
                lblDetail4.Visible = true;
                Orders ord = (Orders)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = ord.OrderID.ToString();
                rchbxDetail2.Text    = ord.CustomerID;
                rchbxDetail3.Text    = ord.EmployeeID.ToString();
                rchbxDetail4.Text    = ord.ShipName;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
                rchbxDetail3.Visible = true;
                rchbxDetail4.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Categories")
            {
                lblDetail1.Text    = "CategoryID";
                lblDetail2.Text    = "Category Name";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                Categories cat = (Categories)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = cat.CategoryID.ToString();
                rchbxDetail2.Text    = cat.CategoryName;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Customers")
            {
                lblDetail1.Text    = "CustomerID";
                lblDetail2.Text    = "Company Name";
                lblDetail3.Text    = "Phone";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                lblDetail3.Visible = true;
                Customers cust = (Customers)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = cust.CustomerID;
                rchbxDetail2.Text    = cust.CompanyName;
                rchbxDetail3.Text    = cust.Phone;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
                rchbxDetail3.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "CustomerCustomerDemo")
            {
                lblDetail1.Text    = "CustomerID";
                lblDetail2.Text    = "CustomerTypeID";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                CustomerCustomerDemo ccd = (CustomerCustomerDemo)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = ccd.CustomerID;
                rchbxDetail2.Text    = ccd.CustomerTypeID;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "CustomerDemographics")
            {
                lblDetail1.Text    = "CustomerTypeID";
                lblDetail2.Text    = "Customer Desc";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                CustomerDemographics cd = (CustomerDemographics)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = cd.CustomerTypeID;
                rchbxDetail2.Text    = cd.CustomerDesc;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Employees")
            {
                lblDetail1.Text    = "EmployeeID";
                lblDetail2.Text    = "First Name";
                lblDetail3.Text    = "Last Name";
                lblDetail4.Text    = "BirthDate";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                lblDetail3.Visible = true;
                lblDetail4.Visible = true;
                Employees emp = (Employees)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = emp.EmployeeID.ToString();
                rchbxDetail2.Text    = emp.FirstName;
                rchbxDetail3.Text    = emp.LastName;
                rchbxDetail4.Text    = emp.BirthDate.ToString();
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
                rchbxDetail3.Visible = true;
                rchbxDetail4.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "EmployeeTerritories")
            {
                lblDetail1.Text    = "EmployeeID";
                lblDetail2.Text    = "TerritoryID";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                EmployeeTerritories empt = (EmployeeTerritories)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = empt.EmployeeID.ToString();
                rchbxDetail2.Text    = empt.TerritoryID;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "OrderDetails")
            {
                lblDetail1.Text    = "OrderID";
                lblDetail2.Text    = "ProductID";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                OrderDetails od = (OrderDetails)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = od.OrderID.ToString();
                rchbxDetail2.Text    = od.ProductID.ToString();
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Products")
            {
                lblDetail1.Text    = "ProductID";
                lblDetail2.Text    = "Product Name";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                Products pro = (Products)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = pro.ProductID.ToString();
                rchbxDetail2.Text    = pro.ProductName;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Shippers")
            {
                lblDetail1.Text    = "ShipperID";
                lblDetail2.Text    = "Company Name";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                Shippers ship = (Shippers)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = ship.ShipperID.ToString();
                rchbxDetail2.Text    = ship.CompanyName;
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
            }
            else if (cmbbxTables.SelectedItem.ToString() == "Territories")
            {
                lblDetail1.Text    = "TerritoryID";
                lblDetail2.Text    = "RegionID";
                lblDetail1.Visible = true;
                lblDetail2.Visible = true;
                Territories terr = (Territories)lstbxRows.SelectedItem;
                rchbxDetail1.Text    = terr.TerritoryID;
                rchbxDetail2.Text    = terr.RegionID.ToString();
                rchbxDetail1.Visible = true;
                rchbxDetail2.Visible = true;
            }
        }