/*Filling up the dropdownlist with each category. I used a procedure which select everything from Category which only have CategoryID and categoryDescription*/
protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            string strCategory = "sdp_ViewCategory";
            DataSet dsCategory = new DataSet();
            SqlDataAdapter daCategory = new SqlDataAdapter(strCategory, conn);
            daCategory.Fill(dsCategory, "Categories");
            ddlItems.DataSource = dsCategory;
            ddlItems.DataValueField = "CategoryID";
            ddlItems.DataTextField = "Description";
            ddlItems.DataBind();
            ddlItems.Items.Insert(0, "Please select a category");
 
        }
    }
 
/*Selecting a category from dropdownlist(DDL) and desplay the details of all the available product on that category depending on what I have selected on the DDL*/
protected void ddlItems_SelectedIndexChanged(object sender, EventArgs e)
    {
 
        dgItems.Visible = true;
        string strItems = "sdp_ViewCartAndProduct";
 
        SqlDataAdapter daItems = new SqlDataAdapter(strItems, conn);
        if (ddlItems.SelectedIndex > 0)
        {
            DataSet dsItems = new DataSet();
            daItems.SelectCommand.CommandText = "Select ProductID, ProductName, PictureName, UnitsInStock from dbo.Products where CategoryID = " + 
                ddlItems.SelectedValue; 
 
 
            try
            {
                dsItems.Tables.Remove("Products");
            }
            catch (Exception de)
            {
                lblMsg.Text = de.Message;
            }
            daItems.Fill(dsItems, "Products");
            dgItems.DataSource = dsItems;
            dgItems.DataMember = "Products";
            dgItems.DataBind();
            dgItems.Visible = true;
            //dgItems.SelectedItem.Cells[4].Visible = false;
           foreach(DataGridColumn col in dgItems.Columns)
           {
               if (col.HeaderText == "PictureName")
                   col.Visible = false;
 
           }
        }
        else
            dgItems.Visible = false;
    }
 
/*Im clicking button select which I added on my 1st datagrid and named it to add to cart then I add what the user select on the 1st datagrid using the select button*/
protected void dgItems_SelectedIndexChanged(object sender, EventArgs e)
    {
 
        imgItems.Visible = true;
        imgItems.ImageUrl = "Pictures/" + dgItems.SelectedItem.Cells[4].Text;
        string strDetails = "sdp_ViewProducts";
        DataSet dsDetails = new DataSet();
        SqlDataAdapter daDetails = new SqlDataAdapter(strDetails, conn);
        daDetails.SelectCommand.CommandText = "Select ProductID, ProductName, UnitPrice from dbo.Products where ProductID = " +
              dgItems.SelectedItem.Cells[2].Text;
 
        daDetails.Fill(dsDetails, "Products");
        dgDetails.DataSource = dsDetails;
        dgDetails.DataMember = "Products";
        dgDetails.DataKeyField = "ProductID";
        dgDetails.DataBind();
        dgDetails.Visible = true;
    }