Rook Question

[Dave S.]

Very new. Need to bind a value from a stored procedure that returns a single
value to a label. I have found lots of examples of how to do this with a
datagrid using .filll and databind but no such methods for a label. Thanks
for the help

[Hans Kesting]

Dave S. wrote:

Very new. Need to bind a value from a stored procedure that returns a single
value to a label. I have found lots of examples of how to do this with a
datagrid using .filll and databind but no such methods for a label. Thanks
for the help

You could just assign the value (maybe with .ToString()) to the Text
property of the label.

--
Hans Kesting

[Eliyahu Goldin]

Something like this (not tested):

<asp:Label" runat=server id=myLabel Text="<%# LabelText %>"></asp:Label>

where LabelText is the name of a property that will return stored procedure
result. If it's just a label, you don't really need to databind. Just run
the sp, get the value and assign it to the label's Text in the code.

Eliyahu

"Dave S." <da**********@colliergov.net> wrote in message
news:OH**************@TK2MSFTNGP10.phx.gbl...

Very new. Need to bind a value from a stored procedure that returns a single value to a label. I have found lots of examples of how to do this with a
datagrid using .filll and databind but no such methods for a label. Thanks
for the help

[Steve C. Orr [MVP, MCSD]]

MyLabel.Text = MySQLCommand.ExecuteScalar()

Here's more info:
http://msdn.microsoft.com/library/de...calartopic.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Dave S." <da**********@colliergov.net> wrote in message
news:OH**************@TK2MSFTNGP10.phx.gbl...

Very new. Need to bind a value from a stored procedure that returns a
single
value to a label. I have found lots of examples of how to do this with a
datagrid using .filll and databind but no such methods for a label. Thanks
for the help

[Dave S.]

At first I didn't get this, but it does work perfectly, thanks!

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:uS*************@TK2MSFTNGP12.phx.gbl...

MyLabel.Text = MySQLCommand.ExecuteScalar()

Here's more info:
http://msdn.microsoft.com/library/de...calartopic.asp
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Dave S." <da**********@colliergov.net> wrote in message
news:OH**************@TK2MSFTNGP10.phx.gbl...

Very new. Need to bind a value from a stored procedure that returns a
single
value to a label. I have found lots of examples of how to do this with a
datagrid using .filll and databind but no such methods for a label. Thanks for the help