protected void Page_Load(object sender, EventArgs e)
    {
        //This code is filling in the Dropdownlist with data from Category table
        string strCategory = "sdp_ViewCategory";
        DataSet dsCategory = new DataSet();
        SqlDataAdapter daCategory = new SqlDataAdapter (strCategory, conn);
        daCategory.Fill(dsCategory, "Categories");
        ddlItems.DataSource = dsCategory;
        ddlItems.DataMember = "Categories";
        ddlItems.DataTextField = "Description";
       // ddlItems.DataSourceID = "CategoryID";
        ddlItems.DataBind();
        ddlItems.Items.Insert(0, "Please select a category");
    }

protected void ddlItems_SelectedIndexChanged(object sender, EventArgs e)
    {
        //Select a category and display datagrid 
        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 ProductName, UnitPrice, UnitsInStock, ProductImage from dbo.Products where CategoryID = "
                + ddlItems.SelectedItem.Value;
            try
            {
                dsItems.Tables.Remove("Products");
            }
            catch (Exception de)
            {
                lblMsg.Text = de.Message;
            }
            daItems.Fill(dsItems, "Products");
            dgItems.DataSource = dsItems;
            dgItems.DataMember = "Products";
            dgItems.DataKeyField = "CategoryID";
            dgItems.DataBind();
            dgItems.Visible = true;
        }
        else
            dgItems.Visible = false;
    }

ddlItems.DataSource = dsCategory;        
ddlItems.DataMember = "Categories";        
ddlItems.DataValueField= "CategoryID"
ddlItems.DataTextField = "Description";       
ddlItems.DataS= "CategoryID";

daItems.SelectCommand.CommandText = "Select ProductName, UnitPrice, UnitsInStock, ProductImage from dbo.Products where CategoryID = "                + ddlItems.SelectedItem.Value;

ddlItems.DataSource = dsCategory;
ddlItems.DataMember = "Categories"; 
ddlItems.DataTextField = "Description";

ddlItems.DataSource = dsCategory;
ddlItems.DataValuefield = "CategoryId"; 
ddlItems.DataTextField = "CategoryName";

protected void Page_Load(object sender, EventArgs e)    
{        
 
         if(!IsPostback)
          {
//This code is filling in the Dropdownlist with data from Category table
               // your complete Dropdown code here
 
       }
}

DataSet dsItems = new DataSet();            daItems.SelectCommand.CommandText = "Select ProductName, UnitPrice, UnitsInStock, ProductImage from dbo.Products where CategoryID = "                + [B]ddlItems.SelectedValue[/B];

/*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;
    }

    protected void Page_Load(object sender, EventArgs e)
    {
 
 
        Response.Write("sql is connected");
        SqlDataAdapter da = new SqlDataAdapter("select countryid,countryname from countryname", cn);
        DataSet ds = new DataSet();
        da.Fill(ds,"countryname");
        ddlcountryname.DataSource = ds.Tables["countryname"];
        ddlcountryname.DataTextField = "countryname";
        ddlcountryname.DataValueField = "countryid";
        ddlcountryname.DataBind();
 
 
    }
    protected void ddlcountryname_SelectedIndexChanged(object sender, EventArgs e)
    {
        string country_id;
        country_id = ddlcountryname.SelectedValue.ToString();
        SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid=' country_id'",cn);
        DataSet ds1 = new DataSet();
        da1.Fill(ds1, "statename");
        ddlstatename.DataSource = ds1.Tables["statename"];
        ddlstatename.DataTextField = "statename";
        ddlstatename.DataValueField = "stateid";
        ddlstatename.DataBind();
    }