ASP.NET

ASP.NET RSS

pass id wont work

Please support our ASP.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jun 2009

Posts: 14

Reputation: missbeginner is an unknown quantity at this point

Solved Threads: 0

missbeginner missbeginner is offline

Offline

Newbie Poster

pass id wont work

Jul 6th, 2009

Please help me, i tried to pass information from detailed view and to another detailed view in another page. I put this code in the first page

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
        protected void ViewRemuneration_Click(object sender, EventArgs e)
        {
            //Button ViewRemuneration = (Button)sender;
            //string sendID = ViewRemuneration.ID;
            Response.Redirect("Remuneration.aspx?employeeId=" + DetailsView1.SelectedValue);
        }
        protected void ViewRemuneration_Click(object sender, EventArgs e)
        {
            //Button ViewRemuneration = (Button)sender;
            //string sendID = ViewRemuneration.ID;
            Response.Redirect("Remuneration.aspx?employeeId=" + DetailsView1.SelectedValue);
        }

and to the second page

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
        protected void Page_Load(object sender, EventArgs e)
        {
            if (null == Session["UserId"])
            {
                Response.Redirect("login.aspx");
            }
            string employeeId = Request["employeeId"].ToString();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (null == Session["UserId"])
            {
                Response.Redirect("login.aspx");
            }
            string employeeId = Request["employeeId"].ToString();
        }

but this second page won't show the id i select at the first detailed view, it only shows the first record in the database. If i pass it to gridview, it will show every record in the database.. please help me,thanks very much

•

Join Date: Jun 2009

Posts: 14

Reputation: missbeginner is an unknown quantity at this point

Solved Threads: 0

missbeginner missbeginner is offline

Offline

Newbie Poster

Re: pass id wont work

Jul 6th, 2009

oh and one more, in the website it displays like this :
http://localhost:1193/ViewReports.aspx?employeeId=4

so it has read which Id i select, but won't show the particular detail i need. thanks again

•

Join Date: Feb 2009

Posts: 3,215

Reputation: sknake has much to be proud of

Solved Threads: 572

sknake

Offline

.NET Enthusiast

Re: pass id wont work

Jul 6th, 2009

You're passing the employee ID in the query string but checking a session variable? That doesn't make any sense.

First page is OK:

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
        protected void ViewRemuneration_Click(object sender, EventArgs e)
        {
            //Button ViewRemuneration = (Button)sender;
            //string sendID = ViewRemuneration.ID;
            Response.Redirect("Remuneration.aspx?employeeId=" + DetailsView1.SelectedValue);
        }
        protected void ViewRemuneration_Click(object sender, EventArgs e)
        {
            //Button ViewRemuneration = (Button)sender;
            //string sendID = ViewRemuneration.ID;
            Response.Redirect("Remuneration.aspx?employeeId=" + DetailsView1.SelectedValue);
        }

Change the second page to:

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
        protected void Page_Load(object sender, EventArgs e)
        {
            string employeeId = Convert.ToString(Request["employeeId"]);
            if (string.IsNullOrEmpty(employeeId))
            {
                Response.Redirect("login.aspx");
            }
            else
            {
               //Set your session variable here
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            string employeeId = Convert.ToString(Request["employeeId"]);
            if (string.IsNullOrEmpty(employeeId))
            {
                Response.Redirect("login.aspx");
            }
            else
            {
               //Set your session variable here
            }
        }

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Jun 2009

Posts: 14

Reputation: missbeginner is an unknown quantity at this point

Solved Threads: 0

missbeginner missbeginner is offline

Offline

Newbie Poster

Re: pass id wont work

Jul 7th, 2009

hi thanks for the reply, i have tried but now it displays nothing.
the code in the second page looks like this

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
        protected void Page_Load(object sender, EventArgs e)
        {
            if (null == Session["UserId"])
            {
                Response.Redirect("login.aspx");
            }
            string employeeId = Convert.ToString(Request["employeeId"]);
            string reportsSql = string.Format(
                "SELECT Performance.PerformanceID, Employee.LastName, Employee.FirstName, Performance.DateofRemark, Performance.MyPerformance, Performance.EmployeePerformance, Performance.RemarkedBy "
                 + "FROM Employee INNER JOIN Performance ON Employee.ID = Performance.ID "
                 + "WHERE Employee.ID = " + employeeId);
            AccessDataSource accessDataSource1 = new AccessDataSource();
            accessDataSource1.DataFile = "~/App_Data/Copy of elog.mdb";
            GridView1.DataSource = accessDataSource1;
            accessDataSource1.SelectCommand = reportsSql;
            GridView1.DataBind();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (null == Session["UserId"])
            {
                Response.Redirect("login.aspx");
            }
            string employeeId = Convert.ToString(Request["employeeId"]);
            string reportsSql = string.Format(
                "SELECT Performance.PerformanceID, Employee.LastName, Employee.FirstName, Performance.DateofRemark, Performance.MyPerformance, Performance.EmployeePerformance, Performance.RemarkedBy "
                 + "FROM Employee INNER JOIN Performance ON Employee.ID = Performance.ID "
                 + "WHERE Employee.ID = " + employeeId);
            AccessDataSource accessDataSource1 = new AccessDataSource();
            accessDataSource1.DataFile = "~/App_Data/Copy of elog.mdb";
            GridView1.DataSource = accessDataSource1;
            accessDataSource1.SelectCommand = reportsSql;
            GridView1.DataBind();

•

Join Date: Jun 2009

Posts: 14

Reputation: missbeginner is an unknown quantity at this point

Solved Threads: 0

missbeginner missbeginner is offline

Offline

Newbie Poster

Re: pass id wont work

Jul 7th, 2009

hey i found the mistake!
it's not just in the code behind, but i have to change the "autogenerate columns" in .aspx page to "TRUE".
thanks a lot sksnake, your post really helps, now it's working!