Posted on: 2/10/2015 5:32:53 PM | Views : 540

Hey folks, I have a question.  I have a stacked query that gives me results in columns.  Can I take those results and populate label controls with them?  The queries are like this:
SELECT (SELECT COUNT(*) from table where Private = 'Y' AND Var = 'DD'),(SELECT COUNT(column2) from table where Private = 'Y' AND Var = 'BB'),(SELECT COUNT(*) from table where Private = 'Y'AND Var = 'DD') + (SELECT (*) from table where Private = 'Y'AND Var = 'BB') So I would like my label controls to take the values of the returned data sets using code behind c# in web forms.
6542         1000          7542

Go to the complete details ...