more than one field bind to hyperlink datatextfield

[mimi]

Is there a way to set hyperlink's datatextfield bind to more than one field

for ex:
<asp:HyperLinkColumn DataNavigateUrlField="CustomerID"
DataNavigateUrlFormatString="Customer.aspx?ID={0}"
DataTextField="CustomerID,CustomerType" DataTextFormatString="Customer:
{0} - Type: {1}"

It gave me error "A field or property with the name
'CustomerID,CustomerType' was not found on the selected datasource"

[Lars Netzel]

No you can't, not that way.... But you can always in your SELECT Statement
put the two columns together so the Datasource returns one more Column that
is ready to bind with this information.

SELECT (CustomerID + ', ' + CustomerType) as 'Customertext' FROM ...

/Lars Netzel

"mimi" <mh****@hotmail.com> wrote in message
news:O5**************@TK2MSFTNGP15.phx.gbl...

Is there a way to set hyperlink's datatextfield bind to more than one
field

for ex:
<asp:HyperLinkColumn DataNavigateUrlField="CustomerID"
DataNavigateUrlFormatString="Customer.aspx?ID={0}"
DataTextField="CustomerID,CustomerType" DataTextFormatString="Customer:
{0} - Type: {1}"

It gave me error "A field or property with the name
'CustomerID,CustomerType' was not found on the selected datasource"

[mimi]

thanks. That is an easy solution

"Lars Netzel" <ui****@adf.se> wrote in message
news:uJ**************@TK2MSFTNGP09.phx.gbl...

No you can't, not that way.... But you can always in your SELECT Statement
put the two columns together so the Datasource returns one more Column that is ready to bind with this information.

SELECT (CustomerID + ', ' + CustomerType) as 'Customertext' FROM ...

/Lars Netzel

"mimi" <mh****@hotmail.com> wrote in message
news:O5**************@TK2MSFTNGP15.phx.gbl...

Is there a way to set hyperlink's datatextfield bind to more than one
field

for ex:
<asp:HyperLinkColumn DataNavigateUrlField="CustomerID"
DataNavigateUrlFormatString="Customer.aspx?ID={0}"
DataTextField="CustomerID,CustomerType" DataTextFormatString="Customer:
{0} - Type: {1}"

It gave me error "A field or property with the name
'CustomerID,CustomerType' was not found on the selected datasource"