Thanks much...

Thanks for the reply,

Do u think it is needed to use the loop, I want to use the rows.count()

I have no problem using the count(*), but still I have the same problem.

I want to just count the row which satisfy with WHERE clause.

I like to count all those rows where username = 'xxx'

not others.

How can I do that?

Hi.
I am using Visual Studio 2008, and Sql Server 2000, and I have the following code:



'Load connection module
connection()

cmd = con.CreateCommand...