Hyperlink problem

andrew sargent · Jun 28, 2004

I am sure that there is a simple answer to this, but i have not been able to
find it.

I have a hyperlink column to send the user to an external webpage.
But when it is clicked it appends the URL to the current URL

i.e

http://www.mywebsite.com/datapage.aspx#http://www.externalwebsite.com

Thanks for any help you can give

Andrew

Ken Cox [Microsoft MVP] · Jun 28, 2004

Hi Andrew,

It sounds like you are binding to the wrong field or concatenating
something. Perhaps you could post the troublesome code? Here's some example
code:

Dim dt As DataTable
Private Sub Page_Load _
(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles MyBase.Load
If Not IsPostBack Then
DataGrid1.DataSource = CreateDataSource()
DataGrid1.DataBind()
End If
End Sub

Function CreateDataSource() As ICollection

' Create sample data for the DataList control.
dt = New DataTable
Dim dr As DataRow

' Define the columns of the table.
dt.Columns.Add(New DataColumn("Item", GetType(String)))
dt.Columns.Add(New DataColumn("Qty", GetType(Int32)))
dt.Columns.Add(New DataColumn("Price", GetType(Double)))

' Populate the table with sample values.
Dim i As Integer

For i = 0 To 8
dr = dt.NewRow()
dr(0) = "http://mydomain/Item" & i.ToString & ".aspx"
dr(1) = i * 2
dr(2) = 1.23 * (i + 1)
dt.Rows.Add(dr)
Next i

Dim dv As DataView = New DataView(dt)
Return dv
End Function

<form id="Form1" method="post" runat="server">
<asp

ataGrid id="DataGrid1" runat="server">
<Columns>
<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="Item"
DataTextField="Price" HeaderText="Link"></asp:HyperLinkColumn>
</Columns>
</asp

ataGrid>
<P> </P>
<P>
<asp:Label id="Label1" runat="server">Label</asp:Label></P>
</form>

Ken
Microsoft MVP [ASP.NET]
Toronto

andrew sargent · Jun 29, 2004

OK, here goes:

<%@ Page Language="VB" %>
<script runat="server">

Sub Page_Load (sender As Object, e As EventArgs)

dgNews.Datasource = GetNews()
dgNews.DataBind()

End Sub

Function GetNews() As System.Data.IDataReader
Dim connectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data
Source=xxxxxxxxxxxxxxxxxxxxxx"
Dim dbConnection As System.Data.IDbConnection = New
System.Data.OleDb.OleDbConnection(connectionString)

Dim queryString As String = "SELECT [news].[Title],
[news].[Text], [news]., [news].[Date] FROM [news]" Dim db...y help you can give Andrew [/QUOTE] [/QUOTE]

Ken Cox [Microsoft MVP] · Jun 29, 2004

Hi Andrew,

Hi had to rejig your code to use the Nwind database. You seem to be using
some strange interfaces which I changed. Not sure what's the reason.

Try this to see how you do?

Ken
Microsoft MVP [ASP.NET]

<%@ Page Language="VB" %>
<%@ import namespace="system.data" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<script runat="server">
Sub Page_Load(ByVal sender As Object, _
ByVal e As System.EventArgs)
If Not IsPostBack Then
dgNews.DataSource = GetNews()
dgNews.DataBind()
End If
End Sub

Function GetNews() As _
System.Data.OleDb.OleDbDataReader
Dim connectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("data/nwind.mdb")
Dim dbConnection As System.Data.OleDb.OleDbConnection = _
New System.Data.OleDb.OleDbConnection(connectionString)
Dim queryString As String = "SELECT * from employees "
' Dim queryString As String = "SELECT [news].[Title],
[news].[Text], [news]., [news].[Date] FROM [news] " Dim d...asp:datagrid> </div> </form> </body> </html>

andrew sargent · Jun 29, 2004

The code was generated with webmatrix which may explain why it differs from
your code.

I seem to have the same problem with this codde too. so i am not sure what
is going wrong!

Ken Cox said:
Hi Andrew,

Hi had to rejig your code to use the Nwind database. You seem to be using
some strange interfaces which I changed. Not sure what's the reason.

Try this to see how you do?

Ken
Microsoft MVP [ASP.NET]

<%@ Page Language="VB" %>
<%@ import namespace="system.data" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<script runat="server">
Sub Page_Load(ByVal sender As Object, _
ByVal e As System.EventArgs)
If Not IsPostBack Then
dgNews.DataSource = GetNews()
dgNews.DataBind()
End If
End Sub

Function GetNews() As _
System.Data.OleDb.OleDbDataReader
Dim connectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("data/nwind.mdb")
Dim dbConnection As System.Data.OleDb.OleDbConnection = _
New System.Data.OleDb.OleDbConnection(connectionString)
Dim queryString As String = "SELECT * from employees "
' Dim queryString As String = "SELECT [news].[Title],
[news].[Text], [news]., [news].[Date] FROM [news] " Dim d...style> <itemstyle forecolor="#4A3C8C"[/QUOTE]

andrew sargent · Jul 2, 2004

OK, I have figured out where i was going wrong. The data type in the
database was set to Hyperlink.
I changed it to Text and...bob's your mother's brother ;-)

Andrew

andrew sargent said:
The code was generated with webmatrix which may explain why it differs from
your code.

I seem to have the same problem with this codde too. so i am not sure what
is going wrong!

Ken Cox said:

Hi Andrew,

Hi had to rejig your code to use the Nwind database. You seem to be using
some strange interfaces which I changed. Not sure what's the reason.

Try this to see how you do?

Ken
Microsoft MVP [ASP.NET]

<%@ Page Language="VB" %>
<%@ import namespace="system.data" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<script runat="server">
Sub Page_Load(ByVal sender As Object, _
ByVal e As System.EventArgs)
If Not IsPostBack Then
dgNews.DataSource = GetNews()
dgNews.DataBind()
End If
End Sub

Function GetNews() As _
System.Data.OleDb.OleDbDataReader
Dim connectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("data/nwind.mdb")
Dim dbConnection As System.Data.OleDb.OleDbConnection = _
New System.Data.OleDb.OleDbConnection(connectionString)
Dim queryString As String = "SELECT * from employees "
' Dim queryString As String = "SELECT [news].[Title],
[news].[Text], [news]., [news].[Date] FROM [news] " Dim d...iv> </form> </body> </html> [/QUOTE] [/QUOTE]

Click to expand...

Ken Cox [Microsoft MVP] · Jul 3, 2004

Thanks for reporting back.

That's another weird one for someone else to find in a Google search some
day!

Timing problem	4	May 1, 2023
Problem with KMKfw libraries	1	May 11, 2023
Turtle.onclick problem	7	Feb 16, 2022
HyperLink trouble	2	Apr 12, 2009
Hyperlink	1	Nov 24, 2003
Click on a hyperlink to open text	8	Oct 20, 2011
Python discord bot problem	1	Jan 11, 2023
Partially completed coding of loop script, need help finishing.	0	Oct 7, 2022

Hyperlink problem

andrew sargent

Ken Cox [Microsoft MVP]

andrew sargent

Ken Cox [Microsoft MVP]

andrew sargent

andrew sargent

Ken Cox [Microsoft MVP]

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads