Пример #1
0
 private void BindListView()
 {
     using (SqlCommand cmd = new SqlCommand())
     {
         if (DisplayCoffee == "All")
         {
             cmd.CommandText = "SELECT * FROM Coffee;";
         }
         else if (DisplayCoffee == "Mild")
         {
             cmd.CommandText = "SELECT * FROM Coffee WHERE CoffeeStrength Between 0 AND 4 ;";
         }
         else if (DisplayCoffee == "Medium")
         {
             cmd.CommandText = "SELECT * FROM Coffee WHERE CoffeeStrength Between 5 AND 7;";
         }
         else if (DisplayCoffee == "Strong")
         {
             cmd.CommandText = "SELECT * FROM Coffee WHERE CoffeeStrength Between 8 AND 10;";
         }
         else
         {
             cmd.CommandText = "SELECT * FROM Coffee WHERE CoffeeType LIKE '%" + DisplayCoffee + "';";
         }
         cmd.Connection = conn;
         using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
         {
             DataTable dt = new DataTable();
             sda.Fill(dt);
             LVcoffees.DataSource = dt;
             LVcoffees.DataBind();
         }
     }
 }
Пример #2
0
        protected void ddl_SortBy_SelectedIndexChanged(object sender, EventArgs e)
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                if (ddl_SortBy.SelectedValue == "A-Z")
                {
                    cmd.CommandText = "SELECT * FROM Coffee ORDER BY CoffeeName;";
                }
                else if (ddl_SortBy.SelectedValue == "Z-A")
                {
                    cmd.CommandText = "SELECT * FROM Coffee ORDER BY CoffeeName Desc;";
                }
                else if (ddl_SortBy.SelectedValue == "Low-High")
                {
                    cmd.CommandText = "SELECT * FROM Coffee ORDER BY CoffeePrice;";
                }
                else if (ddl_SortBy.SelectedValue == "High-Low")
                {
                    cmd.CommandText = "SELECT * FROM Coffee ORDER BY CoffeePrice Desc;";
                }
                else if (ddl_SortBy.SelectedValue == "Mild-Strong")
                {
                    cmd.CommandText = "SELECT * FROM Coffee ORDER BY CoffeeStrength;";
                }
                else if (ddl_SortBy.SelectedValue == "Strong-Mild")
                {
                    cmd.CommandText = "SELECT * FROM Coffee ORDER BY CoffeeStrength Desc;";
                }
                else if (ddl_SortBy.SelectedValue == "Origin")
                {
                    cmd.CommandText = "SELECT * FROM Coffee GROUP BY CoffeeOrigin;";
                }

                cmd.Connection = conn;
                using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    sda.Fill(dt);
                    LVcoffees.DataSource = dt;
                    LVcoffees.DataBind();
                }
            }
        }