when i execute a "select" command,then i want to check
weather there is any record or not.
i.e i want go in a " if " clouse,only if there is any record
fached from the database.
if someresult then
'''some operation
end if

so whats the solution?

abhinavjain

__________________
abhinavjain

at Transact-SQL level you can use a built-in function in SQL-Server like
@@rowcount
HTH.

--------------------------------------------
Mehdi.:)

There is also an @@error property, which checks for errors if that is what you are looking for. If no errors occur, value should be zero.

Brian