Hyperlink Column not displaying

[William LaMartin]

I have a gridview (with no properties set) on an aspx page which I populate
from an XML file with the code below.

The data in the XML file looks like this

<description>Na tional Trust for Historic Preservation</description>
<URL>http://www.nthp.org/</URL>
<category>Archi tecture</category>

Can anyone tell me why the other two columns are displayed, but the
hyperlink column does not display in the grid?

The code:

Dim DS As New Data.DataSet
DS.ReadXml(Serv er.MapPath(".") & "\data\Links.xm l")
Dim dt As New Data.DataTable
Dim dr As Data.DataRow
Dim hl As New HyperLink
Dim i As Integer

dt.Columns.Add( New Data.DataColumn ("Descriptio n", GetType(String) ))
dt.Columns.Add( New Data.DataColumn ("URL", GetType(HyperLi nk)))
dt.Columns.Add( New Data.DataColumn ("Category", GetType(String) ))

For i = 0 To DS.Tables(0).Ro ws.Count - 1

dr = dt.NewRow
dr("Description ") = DS.Tables(0).Ro ws.Item(i).Item (0) 'The link's
description
hl.NavigateUrl = DS.Tables(0).Ro ws.Item(i).Item (1) 'the link's URL
hl.Text = DS.Tables(0).Ro ws.Item(i).Item (0) 'description
hl.Target = "_Blank"
dr("URL") = hl
dr("Category") = DS.Tables(0).Ro ws.Item(i).Item (2) 'The link's category
dt.Rows.Add(dr)
Next

Me.GridView1.Da taSource = dt
Me.GridView1.Da taBind()

[Martin CLAVREUIL]

Why don't you do this in design mode ?

"William LaMartin" <la******@tampa bay.rr.comwrote in :
Og************* *@TK2MSFTNGP03. phx.gbl...

>I have a gridview (with no properties set) on an aspx page which I populate
from an XML file with the code below.

The data in the XML file looks like this

<description>Na tional Trust for Historic Preservation</description>
<URL>http://www.nthp.org/</URL>
<category>Archi tecture</category>

Can anyone tell me why the other two columns are displayed, but the
hyperlink column does not display in the grid?

The code:

Dim DS As New Data.DataSet
DS.ReadXml(Serv er.MapPath(".") & "\data\Links.xm l")
Dim dt As New Data.DataTable
Dim dr As Data.DataRow
Dim hl As New HyperLink
Dim i As Integer

dt.Columns.Add( New Data.DataColumn ("Descriptio n", GetType(String) ))
dt.Columns.Add( New Data.DataColumn ("URL", GetType(HyperLi nk)))
dt.Columns.Add( New Data.DataColumn ("Category", GetType(String) ))

For i = 0 To DS.Tables(0).Ro ws.Count - 1

dr = dt.NewRow
dr("Description ") = DS.Tables(0).Ro ws.Item(i).Item (0) 'The link's
description
hl.NavigateUrl = DS.Tables(0).Ro ws.Item(i).Item (1) 'the link's URL
hl.Text = DS.Tables(0).Ro ws.Item(i).Item (0) 'description
hl.Target = "_Blank"
dr("URL") = hl
dr("Category") = DS.Tables(0).Ro ws.Item(i).Item (2) 'The link's category
dt.Rows.Add(dr)
Next

Me.GridView1.Da taSource = dt
Me.GridView1.Da taBind()

[William LaMartin]

Because for some reason when I try to add my XML file as an XMLDataSource in
design mode I receive the following message:

There was an error rendering the control.
The data source for GridView with id 'GridView1' did not have any properties
or attributes from which to generate columns. Ensure that your data source
has content.

In researching this, I have read that instead of the structure my XML file
has, what is wanted is for each item to have attributes instead of elements.
I haven't looked into doing this, though.

Furthermore, I have found it more flexible to generate data connections in
code. And I am sure there is a way to get the hyperlink column to display
this way--I just haven't found it.
"Martin CLAVREUIL" <az****@azerty. comwrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

Why don't you do this in design mode ?

"William LaMartin" <la******@tampa bay.rr.comwrote in :
Og************* *@TK2MSFTNGP03. phx.gbl...

>>I have a gridview (with no properties set) on an aspx page which I
populate from an XML file with the code below.

The data in the XML file looks like this

<description>N ational Trust for Historic Preservation</description>
<URL>http://www.nthp.org/</URL>
<category>Arch itecture</category>

Can anyone tell me why the other two columns are displayed, but the
hyperlink column does not display in the grid?

The code:

Dim DS As New Data.DataSet
DS.ReadXml(Ser ver.MapPath("." ) & "\data\Links.xm l")
Dim dt As New Data.DataTable
Dim dr As Data.DataRow
Dim hl As New HyperLink
Dim i As Integer

dt.Columns.Add (New Data.DataColumn ("Descriptio n", GetType(String) ))
dt.Columns.Add (New Data.DataColumn ("URL", GetType(HyperLi nk)))
dt.Columns.Add (New Data.DataColumn ("Category", GetType(String) ))

For i = 0 To DS.Tables(0).Ro ws.Count - 1

dr = dt.NewRow
dr("Description ") = DS.Tables(0).Ro ws.Item(i).Item (0) 'The link's
description
hl.NavigateUrl = DS.Tables(0).Ro ws.Item(i).Item (1) 'the link's URL
hl.Text = DS.Tables(0).Ro ws.Item(i).Item (0) 'description
hl.Target = "_Blank"
dr("URL") = hl
dr("Category") = DS.Tables(0).Ro ws.Item(i).Item (2) 'The link's category
dt.Rows.Add(dr)
Next

Me.GridView1.D ataSource = dt
Me.GridView1.D ataBind()

[William LaMartin]

The solution was to do a little hand coding on the source page of the aspx
file containing the GridView as below to create the hyperlink column. Then
create a dataset from the XML file as a datasource for the GridView and
importantly set AutoGenerateCol umns=False to keep from getting redundant
data. (The field names in the XML file are and dataset are description, URL
and Category)

<asp:GridView ID="GridView1" runat="server" Style="z-index: 100; left: 17px;
position: absolute;
top: 82px">

<Columns>
<asp:HyperLinkF ield
HeaderText="Sit e"
DataTextField=" description"
DataTextFormatS tring="{0}"
DataNavigateUrl Fields="URL"
DataNavigateUrl FormatString="{ 0}"
Target="_Blank"
/>
<asp:BoundFie ld DataField="Cate gory" HeaderText="Cat egory">
</Columns>
</asp:GridView>
"William LaMartin" <la******@tampa bay.rr.comwrote in message
news:Og******** ******@TK2MSFTN GP03.phx.gbl...

>I have a gridview (with no properties set) on an aspx page which I populate
from an XML file with the code below.

The data in the XML file looks like this

<description>Na tional Trust for Historic Preservation</description>
<URL>http://www.nthp.org/</URL>
<category>Archi tecture</category>

Can anyone tell me why the other two columns are displayed, but the
hyperlink column does not display in the grid?

The code:

Dim DS As New Data.DataSet
DS.ReadXml(Serv er.MapPath(".") & "\data\Links.xm l")
Dim dt As New Data.DataTable
Dim dr As Data.DataRow
Dim hl As New HyperLink
Dim i As Integer

dt.Columns.Add( New Data.DataColumn ("Descriptio n", GetType(String) ))
dt.Columns.Add( New Data.DataColumn ("URL", GetType(HyperLi nk)))
dt.Columns.Add( New Data.DataColumn ("Category", GetType(String) ))

For i = 0 To DS.Tables(0).Ro ws.Count - 1

dr = dt.NewRow
dr("Description ") = DS.Tables(0).Ro ws.Item(i).Item (0) 'The link's
description
hl.NavigateUrl = DS.Tables(0).Ro ws.Item(i).Item (1) 'the link's URL
hl.Text = DS.Tables(0).Ro ws.Item(i).Item (0) 'description
hl.Target = "_Blank"
dr("URL") = hl
dr("Category") = DS.Tables(0).Ro ws.Item(i).Item (2) 'The link's category
dt.Rows.Add(dr)
Next

Me.GridView1.Da taSource = dt
Me.GridView1.Da taBind()