Stupid question - binding an <asp:label> --> stored procedure returning a scalar?

[Homer J. Simpson]

I have the following stored procedure:

ALTER PROCEDURE [dbo].[spGetQuickNoteC ount]
AS
BEGIN
SET NOCOUNT ON;
SELECT COUNT(*) FROM QUICKNOTES
END

....and the following data source in my .aspx file:

<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:csToolbar %>"
SelectCommand=" spGetQuickNoteC ount" SelectCommandTy pe="StoredProce dure">
</asp:SqlDataSour ce>

Now...how do I go about binding an <asp:labelso it simply displays the
scalar returned by the stored procedure? I've used gridviews and repeaters
in the past, but those were always bound to a data source that returned
recordsets, not just a scalar.

I suppose I could write code in Page_Load() to connect to the database, run
the stored procedure and set the label's .Text property to the value
returned, but that's just adding extra code I'd like to avoid.

I'm sure I've missed something obvious here...

[Sherif Elmetainy]

You simply put the label in a repeater, since ExecuteScaler simply returns
the first field in the first record of the result rowset.

"Homer J. Simpson" <ro**@127.0.0.1 wrote in message
news:ue******** *****@TK2MSFTNG P06.phx.gbl...

>I have the following stored procedure:

ALTER PROCEDURE [dbo].[spGetQuickNoteC ount]
AS
BEGIN
SET NOCOUNT ON;
SELECT COUNT(*) FROM QUICKNOTES
END

...and the following data source in my .aspx file:

<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:csToolbar %>"
SelectCommand=" spGetQuickNoteC ount"
SelectCommandTy pe="StoredProce dure">
</asp:SqlDataSour ce>

Now...how do I go about binding an <asp:labelso it simply displays the
scalar returned by the stored procedure? I've used gridviews and
repeaters in the past, but those were always bound to a data source that
returned recordsets, not just a scalar.

I suppose I could write code in Page_Load() to connect to the database,
run the stored procedure and set the label's .Text property to the value
returned, but that's just adding extra code I'd like to avoid.

I'm sure I've missed something obvious here...

[Homer J. Simpson]

You simply put the label in a repeater, since ExecuteScaler simply returns

the first field in the first record of the result rowset.

That's what I thought...but what do you use for the binding expression? I
tried the following:

<asp:Repeater ID="rptNoteCoun t" runat="server"
DataSourceID="S qlDataSource2">
<ItemTemplate >
<asp:Label ID="lblNotes" runat="server"> <%#Eval( ??? ) %></asp:Label>
</ItemTemplate>
</asp:Repeater>

....what are you supposed to use for "???", since the field is unnamed?

[Homer J. Simpson]

...what are you supposed to use for "???", since the field is unnamed?

Never mind. I've named the field by modifying the stored procedure as:

SELECT COUNT(*) AS NUMBER FROM QUICKNOTES

....and then using Eval( "NUMBER" )
I could swear I had tried it already but it still came back blank. I'm as
much of a noob at SQL as I am at ASP.NET. :o)

Thanks "Sherif".