hyperlink in grid view not populating values in another page when clicked

Question

0.00/5 (No votes)

See more:

Hello ,please help me with this hyperlink thing.. i got a grid view where one of the column contains hyperlink say ViewDetails. upon clicking ViewDetails it should get navigate to another page called as Reports.aspx where the page should display the grid row value of selectd column in grid view in labels. i have used row data bound event .. im getting blank labels if i click the hyperlink . i have written stored procedure to get the row values. and im calling it through KEY.. its TaskID which is an auto generated column which is invisible. depending on the key value i need to display the row values.

here are the codes

XML

<asp:GridView ID="GrdViewMyTasks" runat="server" AllowSorting="True"
           AutoGenerateColumns="False" BackColor="White" BorderColor="#0061C1"
           BorderStyle="None" CaptionAlign="Bottom" EmptyDataText="No Records Found"
           Font-Names="Verdana" Font-Size="X-Small" ForeColor="#0061C1"
           Height="179px" OnRowDataBound="GrdViewMyTasks_RowDataBound"
           ShowFooter="True" ShowHeaderWhenEmpty="True" Width="99%"
           onselectedindexchanged="GrdViewMyTasks_SelectedIndexChanged"
           OnRowCreated="GrdViewMyTasks_RowCreated" >

             <Columns>
             <asp:BoundField DataField="TaskID" HeaderText="SL No" Visible="False" ReadOnly="True">
          <FooterStyle BackColor="#0061C1" />
          <HeaderStyle BackColor="#0061C1" HorizontalAlign="Center" VerticalAlign="Middle" />
          <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
          </asp:BoundField>
          <asp:TemplateField HeaderText="Task Name">
          <ItemTemplate>
          <asp:Label ID="TaskName" runat="server"
          Font-Names="Verdana" Font-Size="X-Small" Height="24px"
          Text='<%# Eval("TaskName")%>' Width="70px"></asp:Label>
          </ItemTemplate>
          <FooterStyle BackColor="#0061C1" />
          <HeaderStyle BackColor="#0061C1" ForeColor="White" />
          <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
          </asp:TemplateField>
          <asp:TemplateField HeaderText="Due Date">
          <ItemTemplate>
          <asp:Label ID="DueDate" runat="server" Font-Names="Verdana" Font-Size="X-Small"
          Height="20px" Width="70px" Text='<%# Eval("DueDate","{0:dd/MM/yyyy}")%>' DataFormatString="{0:dd/MM/yyyy}"></asp:Label>
          </ItemTemplate>
          <FooterStyle BackColor="#0061C1" />
          <HeaderStyle BackColor="#0061C1" ForeColor="White" />
          <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
          </asp:TemplateField>
          <asp:TemplateField HeaderText="Description">
          <ItemTemplate>
          <asp:Label ID="Description" runat="server" Font-Names="Verdana" Font-Size="X-Small" Height="20px" Width="90px" Text='<%# Eval("Description")%>'></asp:Label>
          </ItemTemplate>
          <FooterStyle BackColor="#0061C1" />
          <HeaderStyle BackColor="#0061C1" ForeColor="White" />
          <ItemStyle HorizontalAlign="Left" VerticalAlign="Middle" />
          </asp:TemplateField>
          <asp:TemplateField HeaderText="Assign By">
          <ItemTemplate>
          <asp:Label ID="AssignBy" runat="server" Font-Names="Verdana" Font-Size="X-Small" Height="20px" Width="90px" Text='<%# Eval("AssignBy")%>'></asp:Label>
          </ItemTemplate>
          <FooterStyle BackColor="#0061C1" />
          <HeaderStyle BackColor="#0061C1" ForeColor="White" />
          <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
          </asp:TemplateField>
          <asp:TemplateField HeaderText="Status">
          <ItemTemplate>
          <asp:Label ID="Status" runat="server" Font-Names="Verdana" Font-Size="X-Small" Height="20px" Width="90px" Text='<%# Eval("Status")%>'></asp:Label>
          </ItemTemplate>
          <FooterStyle BackColor="#0061C1" />
          <HeaderStyle BackColor="#0061C1" ForeColor="White" />
          <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
          </asp:TemplateField>
          <asp:TemplateField HeaderText="% Complete">
          <ItemTemplate>
          <asp:Label ID="PercentageComplete" runat="server" Font-Names="Verdana" Font-Size="X-Small" Height="20px" Width="50px" Text='<%# Eval("PercentageComplete")%>'></asp:Label>
          </ItemTemplate>
          <FooterStyle BackColor="#0061C1" />
          <HeaderStyle BackColor="#0061C1" ForeColor="White" />
          <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
          </asp:TemplateField>
          <asp:TemplateField HeaderText="View Details">
          <ItemTemplate>
          <asp:HyperLink ID="ViewDetails" runat="server" Font-Names="Verdana" Font-Size="X-Small" Height="24px" Width="70px" ForeColor="#0061C1" Text="ViewDetails" NavigateUrl="Reports.aspx">View</asp:HyperLink>
          </ItemTemplate>
          <FooterStyle BackColor="#0061C1" />
          <HeaderStyle BackColor="#0061C1" ForeColor="White" />
          <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
        </asp:TemplateField>
        </Columns>
     </asp:GridView>

aspx.cs code

C#

protected void GrdViewMyTasks_RowDataBound(object sender, GridViewRowEventArgs e)
   {
       if (e.Row.RowType == DataControlRowType.DataRow)
       {
           HyperLink ViewDetails = e.Row.FindControl("ViewDetails") as HyperLink;
           ViewDetails.NavigateUrl = "Reports.aspx?TaskID=" + e.Row.Cells[0].Text;
       }
   }

code in reports.aspx.cs

C#

protected void Page_Load(object sender, EventArgs e)
{
MTMSService obj = new MTMSService();
DBAccess db = new DBAccess();
{
MTMSDTO objc = new MTMSDTO();
{
 int ID = 0;
 int.TryParse(Request.QueryString["TaskID"], out ID);
objc.TaskID = Convert.ToInt32(Request.QueryString["TaskID"]);
DataSet rep = obj.GetReports();
DataView Rprts = new DataView();
Rprts.Table = rep.Tables[0];


var table = rep.Tables[0];

if (table.Rows.Count > 0)
{
LblTaskID.Text = rep.Tables[0].Rows[0]["TaskID"].ToString();
LblTaskName.Text = rep.Tables[0].Rows[0]["TaskName"].ToString();
LblDueDate.Text = rep.Tables[0].Rows[0]["DueDate"].ToString();
LblDescription.Text = rep.Tables[0].Rows[0]["Description"].ToString();
LblAssignBy.Text = rep.Tables[0].Rows[0]["AssignBy"].ToString();
LblStatus.Text = rep.Tables[0].Rows[0]["Status"].ToString();
LblPercentageComplete.Text = rep.Tables[0].Rows[0]["PercentageComplete"].ToString();
}

else
{

}


LblTaskName.Visible = true;
LblAssignBy.Visible = true;
LblDescription.Visible = true;
LblDueDate.Visible = true;
LblStatus.Visible = true;
LblPercentageComplete.Visible = true;
LblAssignTo.Visible = false;
}
}
}

SQL

and this is my stored procedure

<pre lang="sql">ALTER PROCEDURE [dbo].[GetReports]

        @TaskID int

        AS

        Select TaskName, DueDate, Description, AssignBy, Status, PercentageComplete, TaskID

        From dbo.Task

        Where TaskID = @TaskID;</pre>

Posted 30-Jun-13 21:18pm

s_rao88

Updated 1-Jul-13 1:38am

v5

Add a Solution

Comments

jaideepsinh 2-Jul-13 0:50am

Saw you code which is on MTMSService obj = new MTMSService(); cs file i think problem is on that code.

s_rao88 2-Jul-13 1:50am

yeah got to knw ... tht shuldnt hav been inside page load... i made it prpr nw bt no change in result...:(

s_rao88 2-Jul-13 6:56am

thnks evrybdy i gt d solution.... was missing TaskID in gridview...

2 solutions

Solution 1

<asp:hyperlink id="ViewDetails" runat="server" font-names="Verdana" font-size="X-Small" height="24px" width="70px" forecolor="#0061C1" text="ViewDetails" navigateurl="<%# " ~="" incidentreports.aspx?taskid=" + Eval(" taskid").tostring()="" %>"="" xmlns:asp="#unknown">

Posted 30-Jun-13 21:43pm

jaideepsinh

Comments

s_rao88 1-Jul-13 5:52am

im getting output in the d Reports page now but if i click on 2nd r 3rd task its displayng only 1st task.. plz help me...

prblm is wid my code behind in reports.aspx.cs... i have updated my thread please go through wid it...

jaideepsinh 1-Jul-13 6:47am

Sorry,But i am not understand clearly what you want to do.So please tell me clearly what you want to do in which page.

s_rao88 1-Jul-13 7:04am

i got a grid view where one of the column contains hyperlink say ViewDetails. upon clicking ViewDetails it should get navigate to another page called as Reports.aspx where the page should display the grid row value of selectd column in grid view through labels. i have used row data bound event ..i have written stored procedure to get the row values. and im calling it through KEY.. its TaskID which is an auto generated column which is invisible. depending on the key value i need to display the row values. im getting output in the d Reports page now but if i click on 2nd r 3rd task its displayng only 1st task.. plz help me...
prblm is wid my code behind in reports.aspx.cs... i have updated my thread please go through wid it...

jaideepsinh 1-Jul-13 7:14am

Ok, I understand. Have you tried my code which i posted. Remove you RowDataBound code and try my code.I think it should work if not then tell me what problem going on.
And check this line
objc.TaskID = Convert.ToInt32(Session["TaskID"]);
what you get at objc.TaskID every time you get same id of different.

s_rao88 1-Jul-13 8:51am

i get same id

jaideepsinh 1-Jul-13 12:52pm

This id must be different for different hpyerlink.

s_rao88 2-Jul-13 1:53am

yeah i knw... im getting different id's for different rows in my sql server wen i execute it... bt in code behind its nt displayng d values

jaideepsinh 2-Jul-13 6:08am

Is your problem solve or not.
Please mark as answer if solve your problem.

s_rao88 2-Jul-13 7:19am

i gt d solution i acceptd d answer too

jaideepsinh 2-Jul-13 7:25am

Thank's for giving 1* vote and -2 points.

s_rao88 2-Jul-13 7:31am

sorry i didnt giv u -2 points

s_rao88 2-Jul-13 7:34am

can u plz look in to this link

http://www.codeproject.com/Questions/612954/Stored-procedure-executing-but-not-able-to-populat

jaideepsinh 2-Jul-13 7:38am

Your another problem.
Where you from and where you work?

s_rao88 2-Jul-13 7:57am

frm blore...

jaideepsinh 2-Jul-13 8:02am

then why your profile see U.S. as your country. what is your age?
I paste some suggestion on that link try it.

s_rao88 2-Jul-13 8:05am

i dnt knw abt tht... well i tried it ...its same as tht wat i have written

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Accepted Answer · 2013-07-01T01:26:00

Solution 3

I think if you pass TaskID then you have to use querystrig here ...
I dont unserstand how can you get values in session

YOu can use Querystring as below...

C#

int ID=0;
int.TryParse(Request.QueryString["TaskID"], out ID);

then by this ID you can retrieve data from database with sp.

Posted 1-Jul-13 1:26am

Nirav Prabtani

Comments

s_rao88 1-Jul-13 7:36am

i tried ur code .. but it wasnt wrkin... im getting error nw as input string is not in correct format....

s_rao88 1-Jul-13 7:40am

look at my code i have updated it again... in reports.cs file i have italicized and bold line which gets error sayng input string is not in correct format

Nirav Prabtani 1-Jul-13 7:45am

try this...:)
.
.
int ID = 0;
int.TryParse(Request.QueryString["TaskID"], out ID);
objc.TaskID = ID;
DataSet rep = obj.GetReports();
DataView Rprts = new DataView();
Rprts.Table = rep.Tables[0];
.
.

s_rao88 1-Jul-13 7:51am

thnks no error nw but if i click on othr rows in grid view im getting 1st row values in reports.cs file

Nirav Prabtani 1-Jul-13 7:53am

OK ...you have to pass ID for getting specific data...

Try this...
.
.
int ID = 0;
int.TryParse(Request.QueryString["TaskID"], out ID);
objc.TaskID = ID;
DataSet rep = obj.GetReports(ID);
DataView Rprts = new DataView();
Rprts.Table = rep.Tables[0];
.
.

s_rao88 1-Jul-13 8:07am

i tried ur code but its nt displayng othr row values... its shwing only 1st row values evrytime if i select othr rows

Nirav Prabtani 1-Jul-13 8:12am

plese provide @TaskID to the SP instead of ID......
like this..
.
.
int TaskID = 0;
int.TryParse(Request.QueryString["TaskID"], out TaskID);
objc.TaskID = TaskID;
DataSet rep = obj.GetReports(TaskID);
DataView Rprts = new DataView();
Rprts.Table = rep.Tables[0];
.
.
@TaskID of storedProcedure must get value from here....

s_rao88 1-Jul-13 8:29am

tried ths .. but its nt displayng nethng nw... plz checek ths part... do i need to change nethng here ?

var table = rep.Tables[0];

if (table.Rows.Count > 0)
{
LblTaskID.Text = rep.Tables[0].Rows[0]["TaskID"].ToString();
LblTaskName.Text = rep.Tables[0].Rows[0]["TaskName"].ToString();
LblDueDate.Text = rep.Tables[0].Rows[0]["DueDate"].ToString();
LblDescription.Text = rep.Tables[0].Rows[0]["Description"].ToString();
LblAssignBy.Text = rep.Tables[0].Rows[0]["AssignBy"].ToString();
LblStatus.Text = rep.Tables[0].Rows[0]["Status"].ToString();
LblPercentageComplete.Text = rep.Tables[0].Rows[0]["PercentageComplete"].ToString();
}

Nirav Prabtani 1-Jul-13 8:33am

I think @TaskID is not passed to SP therefor you cannot getting needed data.....

s_rao88 1-Jul-13 8:37am

u can see in d above post .. my SP is thr in it... @TaskID is mentioned in tht... im using the same SP nw

Nirav Prabtani 1-Jul-13 8:41am

ya i know have you passed @TaskID properly????

s_rao88 1-Jul-13 8:48am

yes sir...

Nirav Prabtani 2-Jul-13 1:29am

ok...i think your store pro. didnt get TaskID which have you passed there!!!

s_rao88 2-Jul-13 1:51am

wen i execute my sp in sql server its takin task id as parameter and once i put task id i get result of particular task id ...

Nirav Prabtani 2-Jul-13 1:58am

ya therefor i said that u made mistake whenever u pass TaskID to SP...Just Checkit... :)

s_rao88 2-Jul-13 2:02am

can u plz check this...
say me wat shuld i change

if (table.Rows.Count > 0)
{
LblTaskID.Text = rep.Tables[0].Rows[1]["TaskID"].ToString();
LblTaskName.Text = rep.Tables[0].Rows[1]["TaskName"].ToString();
LblDueDate.Text = rep.Tables[0].Rows[1]["DueDate"].ToString();
LblDescription.Text = rep.Tables[0].Rows[1]["Description"].ToString();
LblAssignBy.Text = rep.Tables[0].Rows[1]["AssignBy"].ToString();
LblStatus.Text = rep.Tables[0].Rows[1]["Status"].ToString();
LblPercentageComplete.Text = rep.Tables[0].Rows[1]["PercentageComplete"].ToString();

}

Nirav Prabtani 2-Jul-13 2:13am

why did you take Rows[1]...???

s_rao88 2-Jul-13 2:18am

i made it 0 first but its nt displayng anythng.... wat shuld i place in Rows[] ? 0 or sum othr num ?

Nirav Prabtani 2-Jul-13 2:20am

if you put 0 then it display the first row of datatable....if you put 1 then it display second row of datatable......if there is only one row in datatable then you have to put 0 ....

s_rao88 2-Jul-13 2:21am

i got many rows... what shuld i put thr nw

s_rao88 2-Jul-13 2:24am

if my sp is like ths

ALTER PROCEDURE [dbo].[GetReports]

AS

Select TaskName, DueDate, Description, AssignBy, Status, PercentageComplete, TaskID

From dbo.Task;
thn im gettin values of particular row wen i put 0 r 1 r 2 in Rows[]

n if i use TaskID int
TaskID = @TaskID in my SP its not displayng nethng.. only blank labels r displayng

s_rao88 2-Jul-13 2:53am

sir i applied break point for
if (table.Rows.Count > 0)

it isnt getting into loop atall... it directly goes to the labels... so im nt able to execute

LblTaskID.Text = rep.Tables[0].Rows[1]["TaskID"].ToString();
LblTaskName.Text = rep.Tables[0].Rows[1]["TaskName"].ToString();
LblDueDate.Text = rep.Tables[0].Rows[1]["DueDate"].ToString();
LblDescription.Text = rep.Tables[0].Rows[1]["Description"].ToString();
LblAssignBy.Text = rep.Tables[0].Rows[1]["AssignBy"].ToString();
LblStatus.Text = rep.Tables[0].Rows[1]["Status"].ToString();
LblPercentageComplete.Text = rep.Tables[0].Rows[1]["PercentageComplete"].ToString();

this .. plz let me knw wat shuld i do...

im getting false value here
if (table.Rows.Count > 0)

Nirav Prabtani 2-Jul-13 7:15am

it means you got count =0 , datatable does not contain any data,,,,,: )

s_rao88 2-Jul-13 7:18am

sir i gt d solution.... its wrkin fine nw... thnks alot for ur valuable time n reply..

Nirav Prabtani 2-Jul-13 7:23am

ok please upvote it if u are satisfied with it....thnx...:)

s_rao88 2-Jul-13 7:31am

sir kindly look into this link.. i gt another question...

http://www.codeproject.com/Questions/612954/Stored-procedure-executing-but-not-able-to-populat