Return number of rows from table to textbox

Posted by Anonymous June 10, 2009 - 12:12pm

I need to count how many rows are there in a table, and then I need to return that value to a textbox on a web form. I didn't find anything online that helped with this problem.

I guess, I really need is to get the number of rows via a query like:
SELECT Count(*)
FROM Events

But then how do I store that value into a variable?
Any ideas?

Thanks

software application development | offshore software development | flash game development