Hi, Please Help.
I am writing a program that displays retrieves values from a SQL table and displays it. The Table contains a single column with many rows.
I am able to retrieve the first record, but not the rest.
I understand that I have to use a looping structure to do this.But I do not how to.
My SQL code is as follows:
SELECT COUNT(daily_mon th.card) AS Expr1
FROM daily_month RIGHT OUTER JOIN
daily_dates ON daily_month.ful ldate = daily_dates.Dat e
WHERE (daily_month.pr od_name = 'White') AND (daily_month.ty pe IN (FUTURE_COLOR))
GROUP BY daily_month.ful ldate
ORDER BY daily_month.ful ldate
The query returns a single column containing +- 20 values.
I want the query to return the same values but via a loop so i can access the values through code in C#.
For intersest sake, my C# code to call this query is follows:
string name = this.daily_mont hTableAdapter.G etValue().ToStr ing();
lblvalue1.text = name;
Please Assist ASAP.
Thanks.
I am writing a program that displays retrieves values from a SQL table and displays it. The Table contains a single column with many rows.
I am able to retrieve the first record, but not the rest.
I understand that I have to use a looping structure to do this.But I do not how to.
My SQL code is as follows:
SELECT COUNT(daily_mon th.card) AS Expr1
FROM daily_month RIGHT OUTER JOIN
daily_dates ON daily_month.ful ldate = daily_dates.Dat e
WHERE (daily_month.pr od_name = 'White') AND (daily_month.ty pe IN (FUTURE_COLOR))
GROUP BY daily_month.ful ldate
ORDER BY daily_month.ful ldate
The query returns a single column containing +- 20 values.
I want the query to return the same values but via a loop so i can access the values through code in C#.
For intersest sake, my C# code to call this query is follows:
string name = this.daily_mont hTableAdapter.G etValue().ToStr ing();
lblvalue1.text = name;
Please Assist ASAP.
Thanks.