<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>"

SelectCommand="SELECT [Week], [Hours] FROM [WeekSummary] WHERE ([TaskGroup] = @TaskGroup);
SELECT @Team=[TeamName] FROM [TaskGroups] WHERE ([TaskGroup]=@TaskGroup)">

<SelectParameters>
  <asp:QueryStringParameter DefaultValue="*" Name="TaskGroup"  QueryStringField="TaskGroup" Type="String" />
  <asp:ControlParameter ControlID="lblTeam" Name="Team" PropertyName="Text" Direction="Output" Type="String" />
</SelectParameters>

You will see that I am trying to fill an ASP Label in my web page.  Is this the right way to go about doing it?  Well, it didn't work for me.  My lblTeam still retain its original value.

Thanks.

hc1:

I am trying to get a scalar value from a SELECT statement back into an ASP control on my web page.  I tried:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>"

SelectCommand="SELECT [Week], [Hours] FROM [WeekSummary] WHERE ([TaskGroup] = @TaskGroup);
SELECT @Team=[TeamName] FROM [TaskGroups] WHERE ([TaskGroup]=@TaskGroup)">

<SelectParameters>
  <asp:QueryStringParameter DefaultValue="*" Name="TaskGroup"  QueryStringField="TaskGroup" Type="String" />
  <asp:ControlParameter ControlID="lblTeam" Name="Team" PropertyName="Text" Direction="Output" Type="String" />
</SelectParameters>

</asp:SqlDataSource>

You will see that I am trying to fill an ASP Label in my web page.  Is this the right way to go about doing it?  Well, it didn't work for me.  My lblTeam still retain its original value.

Thanks.

 

Hi hc1,

Base on my experience, you can use following line to solve your problem:

<asp:Label ID="BalanceLabel" runat="server" Text='<%# Eval("Balance") %>' />

Let me know if I have misunderstood what you mean. Thanks.

Hope it helps,

Hong Gang
 

Hong Gang, thanks for answering.

What I am trying to do is to capture the result from a SQL query statement.  Web Developer allows a parameter to be Input or Output.  How do I make use of the Output capability?  How do I transfer a value from the SQlDataSource object back to the ASP.NET page?

 Thanks

hc1:

Hong Gang, thanks for answering.

What I am trying to do is to capture the result from a SQL query statement.  Web Developer allows a parameter to be Input or Output.  How do I make use of the Output capability?  How do I transfer a value from the SQlDataSource object back to the ASP.NET page?

Hi hc1,

Base on my experience, you can refer this link,  

http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/repeater.aspx

Hope it helps,

Hong Gang