label as dynamic navigation
        Posted  
        
            by KareemSaad
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by KareemSaad
        
        
        
        Published on 2010-04-10T09:34:50Z
        Indexed on 
            2010/04/10
            9:43 UTC
        
        
        Read the original article
        Hit count: 482
        
c#
I Made label to had value from database and linked it . but the problem was it had only one value and i want it keep value when navigation thought site as.
x>y>z>....
this is my code
<
if (Request.QueryString["Category_Id"] != null) {
        Banar.ImageUrl = "Handlers/Banner.ashx?Category_Id=" + Request.QueryString["Category_Id"] + "";
        using
    (SqlConnection conn = Connection.GetConnection())
        {
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "Navcategory";
            cmd.Parameters.Add(Parameter.NewInt("@Category_Id", Request.QueryString["Category_Id"]));
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                    LblNavigaton.Visible = true;
                    LblNavigaton.Text = dr[i].ToString();
                    NavHref.HRef = "ListView.aspx?Category_Id=" + Request.QueryString["Category_Id"] + "";
            }
        }
    }
    else if (Request.QueryString["ProductCategory_Id"] != null)
    {
        Banar.ImageUrl = "Handlers/ProCatBanner.ashx?ProductCategory_Id=" + Request.QueryString["ProductCategory_Id"] + "";
        using
        (SqlConnection conn = Connection.GetConnection())
        {
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "NavProductcategory";
            cmd.Parameters.Add(Parameter.NewInt("@ProductCategory_Id", Request.QueryString["ProductCategory_Id"]));
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                LblNavigaton.Visible = true;
                LblNavigaton.Text = dr["Name"].ToString();
                NavHref.HRef = "ListView.aspx?ProductCategory_Id=" + Request.QueryString["ProductCategory_Id"] + "";
            }
            else
            {
                LblNavigaton.Visible = true;
                LblNavigaton.Text = Page.Title;
            }
        }
        © Stack Overflow or respective owner