return number of rows in table to textbox 1

[chilly442]

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

I guess what 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?

Help gets stars!
Thanks,
Chilly442

 

[jbenson001]

You can use a command object's ExecutScalar() method with the SQL you have written.

ex. Dimi x as integer = cmd.ExecuteNonScalar(...)

 

[chilly442]

That worked perfect. Thanks for the help!!!

Chilly442

 

[jbenson001]

Glad to help!