By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,534 Members | 2,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,534 IT Pros & Developers. It's quick & easy.

programmatically access an SQL claculated value

P: n/a
Hi Guys,
I have this SqlDataSource, that counts some records and sets it in
"NotStartedBugs".
How do I retrive "NotStartedBugs" programmatically?
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT (SELECT COUNT(*) AS Expr1 FROM tickets WHERE
(TicketType = 'Bug') AND (TicketStatus = 'Not Started')) AS
NotStartedBugs"></asp:SqlDataSource>

Jan 10 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.