executescalar() method - check for zero rows

[DotNetGnat]

Hi guys...

i am doing something like this...(below is a dummy code)

int val;
sql = "Select field1 from mytable where Id = 2 ";
---
---
val = (int)dbCmd.ExecuteScalar();

works fine and i get the val if the record exists...but what if the record doesnt exist...i mean how to check for the zero rows using ExecuteScalar??

am i missing something simple here...

-DNG

 

[jbenson001]

Run it and see what happens. I would assume the value "va" would be NULL.

Jim

 

[DotNetGnat]

i tried this...

if (val == NULL)
{
val = -1;
}

doesnt seem to work...

-DNG

 

[DotNetGnat]

ok i got it working...

object val;

val = dbCmd.ExecuteScalar();

if (val !=null) --> works...

-DNG