How to use NavigateURL for HyperLink to transfer data to another page using C# and VB.Net in ASP.Net

Hi yinyang205,

I have checked your code and modified it. Refer the below sample code.

HTML

CS.aspx

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Id" HeaderText="Id" />
        <asp:BoundField DataField="CompanyName" HeaderText="Company Name" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:HyperLink ID="Details1" Text="Details" runat="server" NavigateUrl='<%# "~/CustomerDetails.aspx?CompanyName=" + Server.UrlEncode(Eval("CompanyName").ToString()) %>' />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

CS.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[] { new DataColumn("Id", typeof(int)), new DataColumn("CompanyName", typeof(string)) });
        dt.Rows.Add(1, "Company A - 12");
        dt.Rows.Add(2, "Company B");
        dt.Rows.Add(3, "Company C 12-33");
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

CustomerDetails.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
    if (!string.IsNullOrEmpty(Request.QueryString["CompanyName"]))
    {
        Response.Write("<b>Company Name : </b>" + Server.UrlDecode(Request.QueryString["CompanyName"]));
        Response.Write("<br/><br/><b>Encoded URL : </b>" + Request.Url.AbsoluteUri);
        Response.Write("<br/><br/><b>Decoded URL : </b>" + Server.UrlDecode(Request.Url.AbsoluteUri));
    }
}

Screenshot

Thanks so much for your code. I think your code works great.

But my design is diferent from yours and I am sorry for not being specific in my first message.

I have the following pages:

Customer.aspx This page has Gridview that displays several columns including the Details link below.

<asp:TemplateField>
      <ItemTemplate>
           <asp:HyperLink ID="Details1" Text="Details" runat="server" NavigateUrl='<%# Eval("CompanyName", "~/CustomerDetails.aspx?CompanyName=" + Server.UrlEncode(Eval("CompanyName").ToString())) %>' />
      </ItemTemplate>
</asp:TemplateField>

Customer.aspx.cs

This page displays the SQL source code to show a list of columns on Gridview.

============================================

CustomerDetails.aspx page This page has DetailsView to display more detail on a particular record from Customer.aspx page.

On this page I have something like this:

<asp:DetailsView>
List columns I want to display...
</asp:DetailsView>

<asp:SqlDataSource
...
SelectComman"Select ID, CompanyName From table Name WHERE CompanyName = @CompanyName"


<SelectParameters>
<asp:QueryStringParameter Name="CompanyName" QueryStringField="CompanyName"/>
</SelectParameters>

</asp:SqlDataSource>

Remember my code works fine if I put CompanyID instead of CompanyName. 

This is my code (that works) for CompanyID for that link on Customer.aspx page

<asp:TemplateField>
     <ItemTemplate>
          <asp:HyperLink ID="Details1" Text="Details" runat="server"
                NavigateUrl='<%# Eval("CompanyID", "~/CustomerDetails.aspx?CompanyID={0}") %>' />
     </ItemTemplate>
</asp:TemplateField>

CustomerDetails.aspx.cs

No special code goes into this page.

I look at the data for CompanyID and data for CompanyName. They are different. Here are some samples of it:

CompanyID:

1234xxaa2122

CompanyName:

A 12-3

B 2

C 34

Thanks so much again.

Hi yinyang205,

Since you are passing Encoded value as QueryString parameter. So inorder to filter the record you need to pass Decoded QueryString value to the SqlDataSource SelectParameters. For this you have to take a hiddenfield and assign value to hiddenfield on page load and pass the ControlParameter to the SqlDataSource SelectParameters instead of QueryStringParameter.

Refer the below sample.

CS.aspx

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Id" HeaderText="Id" />
        <asp:BoundField DataField="CompanyName" HeaderText="Company Name" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:HyperLink ID="Details1" Text="Details" runat="server" NavigateUrl='<%# string.Format("~/CustomerDetails.aspx?CompanyName={0}", HttpUtility.UrlEncode(Eval("CompanyName").ToString())) %>' />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

CS.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[] { new DataColumn("Id", typeof(int)), new DataColumn("CompanyName", typeof(string)) });
        dt.Rows.Add(1, "Company A - 12");
        dt.Rows.Add(2, "Company B");
        dt.Rows.Add(3, "Company C 12-33");
        dt.Rows.Add(3, "B's Beverages");
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

CustomerDetails.aspx

<asp:HiddenField ID="hfQueryValue" runat="server" />
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"
    DataKeyNames="CustomerID">
    <Fields>
        <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />
        <asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" />
    </Fields>
</asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:constr %>"
    SelectCommand="SELECT [CustomerID], [CompanyName] FROM [Customers] WHERE ([CompanyName] = @CompanyName)">
    <SelectParameters>
        <asp:ControlParameter ControlID="hfQueryValue" Name="CompanyName" PropertyName="Value"
            Type="String" />
    </SelectParameters>
</asp:SqlDataSource>

CustomerDetails.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
    if (!string.IsNullOrEmpty(Request.QueryString["CompanyName"]))
    {
        hfQueryValue.Value = HttpUtility.UrlDecode(Request.QueryString["CompanyName"]);
    }
}

Thanks so much for your code.

I am scratching my head of why something simple like this is not working.  Sorry I haven't tried your code because my code works fine using ID as a parameter. When I replace CompanyName with ID then it's not working. If it works correctly, then when I click a company on page 1 then it should display the details of that company on page 2 but so far it only displays blank page. ID column has data like '1233xxy', CompanyName column has space and special characters such as 'Company A 22-33', 'Company B 33'.

In summary, I have a page that displays Company records in GridView and I have a link, when clicked takes the user to another page, where it displays detailed information of that company.

The code below works fine with it.

<asp:TemplateField HeaderText="Company"> <ItemTemplate> <asp:Hyperlink ID="ID2" runat="server" Text="Company" target="_xmlwindow" NavigateURL='<%# Eval("ID", "~/folderA/folderb/CompanyDetails.aspx?ID={0}) %'> </asp:Hyperlink> </ItemTemplate> </asp:TemplateField>

If I replace "CompanyName" with "ID" then my code wouldn't work. I realize that the CompanyName has space and special characters and so I use Server.UrlEncode but it still didn't work. I look at the querystring parameter URL is like this: URL?CompanyName=AA+12

In other words, it would put replace a space with a plus sign in the URL on web page.

<asp:TemplateField HeaderText="Company"> <ItemTemplate> <asp:Hyperlink ID="ID2" runat="server" Text="Company" target="_xmlwindow" NavigateURL='<%# Eval("ID", "~/folderA/folderb/CompanyDetails.aspx?ID=" + Server.UrlEncode(Eval("CompanyName").ToString())) %'> </asp:Hyperlink> </ItemTemplate> </asp:TemplateField>

Please look at my code and tell me what I did wrong. Thanks so much.

Sorry, I forgot to replace ID with CompanyName.

It should be like this but still, it didn't work :(

<asp:TemplateField HeaderText="Company"> <ItemTemplate> <asp:Hyperlink ID="ID2" runat="server" Text="Company" target="_xmlwindow" NavigateURL='<%# Eval("CompanyName", "~/folderA/folderb/CompanyDetails.aspx?CompanyName=" + Server.UrlEncode(Eval("CompanyName").ToString())) %'> </asp:Hyperlink> </ItemTemplate> </asp:TemplateField>