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]

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.

 

[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

 

[Steve C. Orr [MVP, MCSD]]

MyLabel.Text = MySQLCommand.ExecuteScalar()

Here's more info:
http://msdn.microsoft.com/library/d...qlclientsqlcommandclassexecutescalartopic.asp

 

[Dave S.]

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