make hyperlink in gridview

Question

0.00/5 (No votes)

See more:

Hi
How can I merge between three columns and the same time make the result as link in gridview

the code for merg is

XML

<asp:TemplateField HeaderText="Name" >
                    <ItemTemplate>

                            <%# Eval("FIRST_NAME") +""+  Eval("FATHER_NAME") +"" + Eval("FAMILY_NAME")%>

                    </ItemTemplate>



                </asp:TemplateField>

the code for hyperlink is:

<asp:HyperLinkField DataNavigateUrlFields="Name" HeaderText="Name" DataNavigateUrlFormatString="sch.aspx?ID={0}"  DataTextField="Name" Target="_blank"> </asp:HyperLinkField>

In another word, there is no field called (Name ) in the database. because it is a new coulmn appear after merged (firstName,fatherName and familyName)

Thanks

Posted 11-Apr-11 0:38am

at all

Updated 11-Apr-11 0:40am

Prerak Patel

v2

Add a Solution

5 solutions

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)

jim lahey · Answer 1 · 2011-04-11T00:44:00

Solution 1

Use an ASP.net HyperLink control in the TemplateField's ItemTemplate

XML

<asp:TemplateField HeaderText="Name" >
<ItemTemplate>
        <asp:HyperLink ID="hypSomeLink" runat="server" Text='<%# Eval("FIRST_NAME") %>' />                 
</ItemTemplate>
</asp:TemplateField>

Posted 11-Apr-11 0:44am

jim lahey

Comments

at all 11-Apr-11 6:53am

But you put just First name, I want the whole name
Thanks

jim lahey 11-Apr-11 9:01am

I know, I assumed you'd be able to work it out from the example..

at all 11-Apr-11 9:46am

as I understand from you I put it as following:

<asp:TemplateField HeaderText="Name">

<itemtemplate>

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("Name", "sch.aspx?ID={0}") %>'

Target="_blank" Text='<%# Eval("FIRST_NAME") +""+ Eval("FATHER_NAME") +"" + Eval("FAMILY_NAME")%>'>

But it gave this error again:

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'Name'

What is the problem now?

jim lahey 11-Apr-11 10:08am

It means exactly what your error message says: the DataBinder is looking for a column called "Name" where there isn't one

at all 11-Apr-11 9:49am

Sorry , the site hidden the closing tag

Mahendra.p25 · Answer 2 · 2011-04-11T00:47:00

Solution 2

XML

Use Name Instead Of

select FIRST_NAME+FATHER_NAME+FAMILY_NAME as Name from table


<asp:HyperLink ID="hyp_Isfresher" NavigateUrl='<%#"Your Link %>'
                                                Text='<%#Eval("Name")%>' runat="server"></asp:HyperLink>


<ItemTemplate>
<%# Eval("Name")%>
 </ItemTemplate>

Posted 11-Apr-11 0:47am

Mahendra.p25

Updated 11-Apr-11 0:59am

v2

Comments

at all 11-Apr-11 6:54am

Did you mean that put the sql statment inside hyperlink tag?

Mahendra.p25 11-Apr-11 6:58am

No, In Your SqlQuery when You are returning your values

select FIRST_NAME+FATHER_NAME+FAMILY_NAME as Name,Col2,Col3,Col4 from table

at all 11-Apr-11 7:03am

Is there any soultion other than SqlQuery ,because I did not deal with it ?
thanks

Mahendra.p25 11-Apr-11 7:04am

Just want to ask from where your are getting
FIRST_NAME , FATHER_NAME ,FAMILY_NAME

at all 11-Apr-11 7:11am

Yes it is from SqlQuery , I know simple information about it not in advance

Rakesh From Patna · Answer 3 · 2011-04-11T00:52:00

Solution 3

You use the datalist control:-
Now same as your

<ItemTemplate>
                            <%# Eval("FIRST_NAME") +""+  Eval("FATHER_NAME") +"" + Eval("FAMILY_NAME")%>
                    
e>
<a target="_balank" style="color:#0000FF;" href='<%# "sch.aspx?ID="+ DataBinder.Eval(Container.DataItem,"ID").Tostring() %>' shape="rect">View full size</a> 
</ItemTemplat>

Posted 11-Apr-11 0:52am

Rakesh From Patna

Updated 11-Apr-11 1:26am

v3

Comments

at all 11-Apr-11 6:56am

Where is the hyperlink tag here?
Thanks

at all 11-Apr-11 6:58am

ok sorry, I think there is problem in site the code not clear

Rakesh From Patna 11-Apr-11 7:02am

i am use the anchor tag for hyperlink. now my tag is start form < a....

at all 11-Apr-11 7:16am

Did you mean use tag a inesated of <hyperlinktag?>

Rakesh From Patna 11-Apr-11 7:17am

You use the "< a" tag ...
this tag is use for hyperlink in html.

at all 11-Apr-11 7:21am

It's gave me an error

Rakesh From Patna 11-Apr-11 7:24am

send the error region

Rakesh From Patna 11-Apr-11 7:27am

Now i see my solution,some error in now i improve my solution now try this

at all 11-Apr-11 7:26am

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'Name'

Rakesh From Patna 11-Apr-11 7:32am

Now you use the sql query like:
"select as FIRST_NAME+FATHER_NAME+FAMILY_NAME as 'Name' from cUser

at all 11-Apr-11 7:28am

(Name) is not in a database it is a coulmn of the result of three coulmns

Rakesh From Patna 11-Apr-11 7:34am

Now i send sql query :-
"select as FIRST_NAME+FATHER_NAME+FAMILY_NAME as 'Name' from table_name

at all 11-Apr-11 7:34am

Put it in aspx or c# page ?

Rakesh From Patna 11-Apr-11 7:36am

In above query is use for select statement for sqldataadpter and fill dataset now you add to datalist

at all 11-Apr-11 7:39am

Should I delete the previous code I posted it ? or just adding the query?

Rakesh From Patna 11-Apr-11 7:45am

where you write select statement, put my sqlcode
select FIRST_NAME,FATHER_NAME,FAMILY_NAME, FIRST_NAME+FATHER_NAME+FAMILY_NAME as 'Name' form table_Name

at all 11-Apr-11 7:49am

I wrote it in aspx

Rakesh From Patna 11-Apr-11 8:10am

now i re submitt the solution

at all 11-Apr-11 7:52am

Give me other error

is not allowed within a 'System.Web.UI.WebControls.DataControlFieldCollection'.

Rakesh From Patna 11-Apr-11 8:21am

No idea for this error.
but i submit the solution which work successfully in my computer.

Mathews Davis · Answer 4 · 2011-04-11T01:57:00

Solution 4

This is very much possible.Insert a gridview and take gridviewTasks..Then take Edit Colums in that. Disable autogenerate field in that and add some bondfields..Then click on edit template and add hyperlink

Posted 11-Apr-11 1:57am

Mathews Davis

Comments

Mathews Davis 11-Apr-11 8:02am

This is just basics..Sorry i didnt get ur que..

at all 11-Apr-11 9:54am

the problem not in how make the hyperlink
the problem how can merg between tag of hyperlink and tag of ItemTemplate

Rakesh From Patna · Answer 5 · 2011-04-11T02:14:00

sql query structure:-
Create table Detail
(
FIRST_NAME varchar(50),
FATHER_NAME varchar(50),
FAMILY_NAME varchar(50)
)

Insert into detail values('Prince','Rakesh','adkk')

//Default2.aspx page is

<pre lang="xml"><%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:DataList ID="DataList1" runat="server">
        <ItemTemplate>
        <%# DataBinder.Eval(Container.DataItem,"FIRST_NAME" ).ToString()%> + <%# DataBinder.Eval(Container.DataItem,"FATHER_NAME").ToString() %>
        + <%# DataBinder.Eval(Container.DataItem,"FAMILY_NAME").ToString() %>
        <a href= '<%# "default3.aspx?vID="+ DataBinder.Eval(Container.DataItem,"Name") %>'>Name</a>
        </ItemTemplate>
        </asp:DataList>
    </div>
    </form>
</body>
</html

>

Now default2.aspx.cs is

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(//connection string);
        SqlDataAdapter adapter = new SqlDataAdapter("Select FIRST_NAME,FATHER_NAME,FAMILY_NAME,FIRST_NAME+FATHER_NAME+FAMILY_NAME as 'Name' from Detail", con);
        DataSet ds=new DataSet();
        adapter.Fill(ds);
        DataList1.DataSource = ds.Tables[0];
        DataList1.DataBind();
    }
}

now default3.aspx is

<pre lang="xml"><%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    </div>
    </form>
</body>
</html

>

NOw default3.aspx.cs is

C#

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //your code for reterive query string
    }
}

I hope your problem is solve. because above code is work successfully in my computer