QueryString Problem

Petro Tiburcio

Hi, I have a table tblProfile, which contains fields with Id, Name, Address. I have 2 aspx page, which are Home.aspx and Here.aspx. On my Home.aspx I have used this code to pass the Id in my Here.aspx:

Click here
In code behind Home.aspx.cs:

protected void Page_Load(object sender, EventArgs e)
{
        string bID = Request.QueryString["Id"];
        if (string.IsNullOrEmpty(Id))
        {
                Response.Redirect("Here.aspx?", true);
        }
        ViewState["Id"] = Id;
        link.NavigateUrl = String.Format(link.NavigateUrl, Id);
}
I don't have any problem with passing the Id to url in 2nd page. But what I want right now is, on my Here.aspx, I have 3 textboxes which supposed to be filled by the Id, Name and Address of the certain Id that passed from the Home.aspx. Tried many but had no luck at all. Any help would be appreciated. By the way, I'm using asp.net with c#. Thanks in advance. God Bless

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Pandey13y ago
hello

Click here

pass these three values from textboxes andread all on next page
and do your operation as your need.
Ravi Shekhar13y ago
but i think above code is right.you have to check your data in database . In actual there is any relevant data exists or not.
Petro Tiburcio13y ago
Hi Ravi, Id is already showing up by trying this code:

txtpid.Text = Request.QueryString["id"];

and for the Name and Address, I have tried this code but nothing shows:

SqlConnection con = new SqlConnection("Data Source=GATE-PC\\SQLEXPRESS;Initial Catalog=dbProfiles;Integrated Security=True");
con.Open();
s1 = Request.QueryString["Id"];
str = "select * from tblProfile where Id='" + s1 + "'";
com = new SqlCommand(str, con);
SqlDataReader reader;
reader = com.ExecuteReader();
if (reader.Read())
{
txtid.Text = reader["Id"].ToString();
txtname.Text = reader["Name"].ToString();
txtadd.Text = reader["Address"].ToString();
}
Ravi Shekhar13y ago
in your homepage you have to redirect a page with querystring ID then on the here page load you have to get this querystring by string bID = Request.QueryString["Id"]; . Now by using this bID you can get more information from database like name, address
Sunny Sharma13y ago
I suggest you share your project... will be much easier and quicker to fix that. Thanks.