Custom databinding of a text box

[Keith G Hicks]

vwd 2005 express.

when editing the CUSTOM databinding of a text box in a FormViews
"ItemTemplate" I'd like to do this:

Bind("[FirstName] & ' ' & [LastName]")

Or if you prefer, this is the resultant ASP code from setting the property
above:
<asp:Label ID="FirstNameLabel" runat="server" Text="<%#
Bind(&quot;[FirstName] & ' ' & [LastName]&quot;) %>"
Width="312px"></asp:Label>

but that doesn't work. How do I construct the string so that the result is
the concatenation of the FirstName and the LastName?

Thanks,

Keith

[Keith G Hicks]

I should point out that I know I can modify my SQL statement to return a
column of the concatenated values or use a view that does the same. HOWEVER,
one of the things many of the SQL gurus yell at everyone for over and over
and over is DO THE FORMATTING IN THE CLIENT SIDE!!! NOT THE SQL SIDE!!!. I
don't always agree with that philosophy but I'd like to know how to do this
on the ASP side of things if it's possible.

Keith
"Keith G Hicks" <kr*@comcast.netwrote in message
news:OH*************@TK2MSFTNGP02.phx.gbl...

vwd 2005 express.

when editing the CUSTOM databinding of a text box in a FormViews
"ItemTemplate" I'd like to do this:

Bind("[FirstName] & ' ' & [LastName]")

Or if you prefer, this is the resultant ASP code from setting the property
above:
<asp:Label ID="FirstNameLabel" runat="server" Text="<%#
Bind(&quot;[FirstName] & ' ' & [LastName]&quot;) %>"
Width="312px"></asp:Label>

but that doesn't work. How do I construct the string so that the result is
the concatenation of the FirstName and the LastName?

Thanks,

Keith

[Jose A. Fernandez]

Hello Keith
It's posible, just help with String.Concat, and Eval dataitem not use
Bind...
Example:
<asp:FormView ID="FormView1"
....
<ItemTemplate>
....
<asp:Label ID="lblDesc" runat="server" Text='<%#
String.Concat(Eval("CategoryID"), Eval("Description"),
Eval("CategoryID")) %>'>
....
Links:
-----------------
String..Concat Method
Concatenates one or more instances of String, or the String
representations of the values of one or more instances of Object.
http://msdn2.microsoft.com/en-us/lib...ng.concat.aspx

I hope that you will help or guide
______________________
Jose A. Fernandez
blog: http://geeks.ms/blogs/fernandezja


On 9 feb, 21:48, "Keith G Hicks" <[e-mail]:

I should point out that I know I can modify my SQL statement to return a
column of the concatenated values or use a view that does the same. HOWEVER,
one of the things many of the SQL gurus yell at everyone for over and over
and over is DO THE FORMATTING IN THE CLIENT SIDE!!! NOT THE SQL SIDE!!!. I
don't always agree with that philosophy but I'd like to know how to do this
on the ASP side of things if it's possible.

Keith

"Keith G Hicks" <[e-mail] in messagenews:OH*************@TK2MSFTNGP02.phx.gbl.. .

vwd 2005 express.

when editing the CUSTOM databinding of a text box in a FormViews
"ItemTemplate" I'd like to do this:

Bind("[FirstName] & ' ' & [LastName]")

Or if you prefer, this is the resultant ASP code from setting the property
above:
<asp:Label ID="FirstNameLabel" runat="server" Text="<%#
Bind(&quot;[FirstName] & ' ' & [LastName]&quot;) %>"
Width="312px"></asp:Label>

but that doesn't work. How do I construct the string so that the result is
the concatenation of the FirstName and the LastName?

Thanks,

Keith

[Keith G Hicks]

Thank you.

"Jose A. Fernandez" <fe*********@gmail.comwrote in message
news:6f**********************************@v67g2000 hse.googlegroups.com...

Hello Keith
It's posible, just help with String.Concat, and Eval dataitem not use
Bind...
Example:
<asp:FormView ID="FormView1"
....
<ItemTemplate>
....
<asp:Label ID="lblDesc" runat="server" Text='<%#
String.Concat(Eval("CategoryID"), Eval("Description"),
Eval("CategoryID")) %>'>
....
Links:
-----------------
String..Concat Method
Concatenates one or more instances of String, or the String
representations of the values of one or more instances of Object.
http://msdn2.microsoft.com/en-us/lib...ng.concat.aspx

I hope that you will help or guide
______________________
Jose A. Fernandez
blog: http://geeks.ms/blogs/fernandezja


On 9 feb, 21:48, "Keith G Hicks" <[e-mail]:

I should point out that I know I can modify my SQL statement to return a
column of the concatenated values or use a view that does the same.

HOWEVER,

one of the things many of the SQL gurus yell at everyone for over and

over

and over is DO THE FORMATTING IN THE CLIENT SIDE!!! NOT THE SQL SIDE!!!.

I

don't always agree with that philosophy but I'd like to know how to do

this

on the ASP side of things if it's possible.

Keith

"Keith G Hicks" <[e-mail] in

messagenews:OH*************@TK2MSFTNGP02.phx.gbl.. .

vwd 2005 express.

when editing the CUSTOM databinding of a text box in a FormViews
"ItemTemplate" I'd like to do this:

Bind("[FirstName] & ' ' & [LastName]")

Or if you prefer, this is the resultant ASP code from setting the

property

above:
<asp:Label ID="FirstNameLabel" runat="server" Text="<%#
Bind(&quot;[FirstName] & ' ' & [LastName]&quot;) %>"
Width="312px"></asp:Label>

but that doesn't work. How do I construct the string so that the

result is

the concatenation of the FirstName and the LastName?

Thanks,

Keith