Help with ExecuteScalar

[daimous]

hi guyz!!! can anybody please help me...CUrrently, i have this code below

string qryStr = "Select Max(id) from users";
sqlCOmmand sqlCmd = new SqlCommand (qryStr, sqlConn);
int max_number = (int)sqlCmd.ExecuteScalar ();
sqlConn.Close ();
return max_number;

as you can see i dont have a way if '(int)sqlCmd.ExecuteScalar ();' really returns a value or should i say had retrieved a value from my users table. My question is, how will check if '(int)sqlCmd.ExecuteScalar ();' method had retrieve or has a value. THanks in advance!!

[sevenhalo]

If the table exists and it's a valid field name, how can it not return a value? (btw, ID should be in [] as it's a reserved word).

If you want to check if it has a value, use a simple if/then/else and return what you would preffer as a default. Or, in the transact statement, use:

"Select isnull(Max([id]), 0) from users"

Change the 0 to whatever default value you want to return.

[jmcilhinney]

object result = sqlCmd.ExecuteScalar();

if (result is int)
{
    // The query returned an integer value.
}

[daimous]

If the table exists and it's a valid field name, how can it not return a value?

users table and field name exist and they both have valid name, is just that i dont have any rows from my users tables

object result = sqlCmd.ExecuteScalar();

if (result is int)
{
    // The query returned an integer value.
}

Since I assigned the return value to result which is in type object how can i convert it to int type? i already tried the

int.parse(result)

but it won't work.