Hyperlink

Banishah · August 8th, 2009, 10:31 AM

Hi....now i am displaying...all the information in JobPost.aspx table to PostJobList.aspx...usng repeater
after display..how to make the jobtitle hyperlink...so i can go to different page...display it in detail....

This is my code in PostJobList.aspx
SqlConnection con;
SqlCommand cmdDisplay;
string select;
SqlDataReader dtrJob;
string constr = ConfigurationManager.ConnectionStrings["tarStreetConnectionString1"].ConnectionString;
con = newSqlConnection(constr);

select = "Select * From JobPost";
cmdDisplay=newSqlCommand(select,con);
con.Open();
dtrJob = cmdDisplay.ExecuteReader();
Repeater1.DataSource=dtrJob;
Repeater1.DataBind();
dtrJob.Close();
..
In the source(PostJobList.aspx)
<asp:RepeaterID="Repeater1"runat="server">
<ItemTemplate>
<%#"Job Title:"+DataBinder.Eval(Container.DataItem,"Job_Title")+""%>
<%#"Company Name:"+DataBinder.Eval(Container.DataItem,"Job_CmpName")+"" %>
<%#"Specialization:"+DataBinder.Eval(Container.DataItem,"Job_Specialization")+" "%>
<%#"Location:" + DataBinder.Eval(Container.DataItem, "Job_Location") + "" + "----------------------------------------------"%>
</ItemTemplate>
</asp:Repeater>

And the output is

Job Title:CEO--->how to change this into hyperlink and go to another page
Company Name:Sri Sentosa Sdn.Bhd
Specialization:Computer
Location:Penang
----------------------------------------------
Job Title:Auditor
Company Name:Wisma Mahsing Pvt Ltd
Specialization:Accounting
Location:
----------------------------------------------

Only 4 attributes are being displayed above, how to display the other attributes into another page after clicking the hyperlink just like Jobstreet...any idea?

Lee Dumond · August 8th, 2009, 12:13 PM

To make the job title clickable, you would need to use a Hyperlink control in the template. Then, you'd want to set the NavigateUrl property to the page containing the job details, passing the ID of the job post on the querystring.

Code:

<ItemTemplate>
   Job Title: 
   <asp:HyperLink ID="HyperLink1" runat="server" 
      Text='<%# Eval("Job_Title") %>' 
      NavigateUrl='<%# "~/ShowJobDetail.aspx?ID=" + Eval("Job_Id") %>' />
 
   *** other stuff here ***
</ItemTemplate>

Banishah · August 9th, 2009, 12:37 AM

hi....i am still having error...to make a hyperlink...can u correct it?

<ItemTemplate>
<asp:HyperlinkID="Hyperlink1"runat="server">
<%#"Job Title:"+DataBinder.Eval(Container.DataItem,"Job_Ti tle")</asp:Hyperlink>+""%>
<%#"Company Name:"+DataBinder.Eval(Container.DataItem,"Job_Cmp Name")+"" %>
<%#"Specialization:" + DataBinder.Eval(Container.DataItem, "Job_Specialization")+""%>
<%#"Location:" + DataBinder.Eval(Container.DataItem, "Job_Location") + ""%>
<%#"Years of Experience:"+DataBinder.Eval(Container.DataItem,"Y rsOfExperience")+""+"======================================="%>
</ItemTemplate>

Banishah · August 9th, 2009, 12:44 AM

Its okay i solve it...thanks alot

Banishah · August 9th, 2009, 12:56 AM

hi....i want to ask one more thing....after clicking the hyperlink...how to make the page display the other attribute of the jobs....i have design the interface.....

ShowJobDetail.aspx
Company Name:[Label1]
Company Introduction:[Label2]
Requirement:[Label3]
Job Title:[label4]

Banishah · August 9th, 2009, 04:15 AM

hi....i .try to solve it but it is not displaying the job details from the hyperlink that i click...

This code in ShowJobDetail.aspx...after clicking the hyperlink(from JobPost.aspx)...it should direct to this page but it is not displaying the job title that i click....how to display the job_id that i click?Can u correct it?....thanks

SqlConnection con;
SqlCommand cmdSelect;
SqlDataReader dtrJob;
string constr = ConfigurationManager.ConnectionStrings["tarStreetConnectionString1"].ConnectionString;
con = newSqlConnection(constr);
con.Open();
cmdSelect = newSqlCommand("Select * From JobPost", con);
dtrJob = cmdSelect.ExecuteReader();
if (dtrJob.HasRows)
{
while (dtrJob.Read())
{
Label1.Text = Convert.ToString(dtrJob["Job_CmpName"]);
Label3.Text = Convert.ToString(dtrJob["Job_CmpIntroduction"]);
Label5.Text = Convert.ToString(dtrJob["Job_MinQualification"]);
Label4.Text = Convert.ToString(dtrJob["Job_Title"]);
}
}
}

Lee Dumond · August 10th, 2009, 11:25 AM

You have to create a SELECT statement that uses the ID to get the single record that you want to display.

Something like...

SELECT * FROM JobPost WHERE Job_Id = @Job_Id

Banishah · August 10th, 2009, 01:42 PM

Hi....i am still having error....

cmdSelect = newSqlCommand("Select * From JobPost Where Job_Id=@Job_Id", con);

after adding the Where Job_Id=@Job_Id , where to call the @job_Id into the below insert statement...?
cmdSelect.Parameters.Add(Request.QueryString["ID"]);

After the page below...it will direct to the page...where i am having error now
<ItemTemplate>Job Title:
<asp:HyperlinkID="Hyperlink1"runat="server"Text='<%# Eval("Job_Title") %>'NavigateUrl='<%#"~/Employer/PreviewJob.aspx?ID=" +Eval("Job_Id")%>'></asp:Hyperlink>
<%#"Company Name:"+DataBinder.Eval(Container.DataItem,"Job_CmpName")+"" %>
<%#"Specialization:" + DataBinder.Eval(Container.DataItem, "Job_Specialization")+""%>
<%#"Location:" + DataBinder.Eval(Container.DataItem, "Job_Location") + ""%>
<%#"Years of Experience:"+DataBinder.Eval(Container.DataItem,"YrsOfExperience")+""+"======================================="%>
</ItemTemplate>

can u correct me?Thank u....