[Firebird-net-provider] Getting a single value from the database in C#

[Fabio G. <fab...@gm...>]

Hi guys, i m trying to do a very simple thing here but i cant find a simple
way to do this.

I m doing a login window, and i want to just make a select like this:

SELECT ID FROM TABLE WHERE USERNAME=3D'USERNAME'

This seens very simple, my query is ok, but what i m missing, is a simple
method to know if this SELECT returned true or false.. i m used to code PHP
and it is easy to know if a select found one or more rows or didnt find any
in PHP.

I tryied with cmd.ExecuteNonQuery(), but it seens that it just returns the
number of affected rows with a DELETE, UPDATE or INSERT, it aways returned
-1 with my select.

I m out of ideas, i even tryied to use a reader.read(), but it didnt work, =
i
dont know why.


Thanx for any help,

-F=E1bio