Display QueryString value on ASP.Net master page using C#

payalsh

SOLVED CLOSED ACTIVE ANSWERED
User: payalsh
Posted: on Jan 24, 2022 11:05 PM
Forum: ASP.Net Web Forms
Answer: 1
Views: 3730

Hello Sir,

I have login page, using this we can login to admin as well as builder panel. In builder panel I have to show particular login builder id and it firm name should print on label present in master page.

I achieved it though query string, but when i choose another page from menu bar like dashboard page or any other page then i lost that query string as well as label information form master page.

As my content page is connected to master page then think above logic should apply to only master page and i can't do anything in contact page as those labels are not available in content page.

Please find my html and C# coding and help me with this.

public partial class login_Default : System.Web.UI.Page
{
    SqlConnection cn;
    SqlCommand cm;
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        { }
    }
    protected void login_click(object sender, EventArgs e)
    {
        string type;
        register R1 = new register();
        string cs = R1.connection();
        cn = new SqlConnection(cs);
        cn.Open();

        cm = new SqlCommand("login1", cn);
        cm.CommandType = CommandType.StoredProcedure;
        cm.Parameters.AddWithValue("userid1", username.Text);
        cm.Parameters.AddWithValue("password1", password.Text);
        dr = cm.ExecuteReader();
        if (dr.Read())
        {
              type  = dr["role"].ToString();
            if (type == "admin")
            {
                Response.Redirect("../admin/Default.aspx");
            }
            if (type == "BUILDER")
            {
                Response.Redirect("../Builder/Default.aspx?buildid="+password.Text);
            }

        }
        else
        {
            Response.Write("Invalid username & Password");
        }
          
        dr.Close();
    }
}

arjunv

0 4

Reply
ANSWER
User: arjunv
Replied: on Jan 26, 2022 11:42 PM
Report

Please use Session instead of QueryString in below code whenever you want to use for that please refer above provided sample.

Response.Redirect("http://property-master.in/Builder/Default.aspx?build_id=" + Request.QueryString["buildid"]);

Refer below modified code.

public partial class Builder_Builder : System.Web.UI.MasterPage
{
    SqlConnection cn;
    SqlCommand cm;
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    { 
        if (Session["Builder"] != null)
        {
            buildid1.Text = Session["buildid"].ToString();
        }
        if (!IsPostBack)
        {
            allcount();
            printid();             
        }
    }
    protected void allcount()
    {
        register R1 = new register();
        string cs = R1.connection();
        cn = new SqlConnection(cs);
        cn.Open();
 
        //All Posted Property
        string post = "select count(sr) from proppost";
        cm = new SqlCommand(post, cn);
        property.Text = cm.ExecuteScalar().ToString();
 
        //Approved Property
        string postapprove = "select count(sr) from proppost where status='approved'";
        cm = new SqlCommand(postapprove, cn);
        approve.Text = cm.ExecuteScalar().ToString();
    }
    protected void printid() // ye bhi work nahi kar raha hai ha
    {
        register R1 = new register();
        string cs = R1.connection();
        cn = new SqlConnection(cs);
        cn.Open();
 
        string print = "select * from buildreg where build_id=@Id";
        cm = new SqlCommand(print, cn);
        cm.Parameters.AddWithValue("@Id", Session["buildid"]);
        dr = cm.ExecuteReader();
        if (dr.Read())
        {
            
            firmname.Text = dr["firm_name"].ToString();
        }
        dr.Close();
    }
    //protected void dash_click(object sender, EventArgs e)
    //{ 
    ////    Response.Redirect("http://property-master.in/Builder/Default.aspx);
    //}
}

Display QueryString value on ASP.Net master page using C#

Company

Explore

Follow us

Contact Us