if statement with datareader

Question

0.00/5 (No votes)

See more:

Hi,

I am trying to test if the value of a field in my sql table is = 0. it is an integer field and i am using data reader!

HTML

if (DataReader.GetInt32["trials_num"] = 0)

this is wrong so how can i test it?

thanks

Posted 22-Dec-15 21:53pm

3 solutions

See Expressions (C# Programming Guide)[^] and check the difference between = and ==.

Posted 23-Dec-15 3:31am

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Duncan Edwards Jones · Accepted Answer · 2015-12-22T22:00:00

In C# equality is indicated with a double == operator.[^]

if (DataReader.GetInt32["trials_num"] == 0)

Posted 22-Dec-15 22:00pm

deepankarbhatnagar · Accepted Answer · 2015-12-22T23:11:00

You can use:

C#

if (Convert.ToInt32(DataReader["trials_num"]) == 0)

Posted 22-Dec-15 23:11pm

Comments

phil.o 23-Dec-15 5:16am

Convert class is rarely needed, never performant, and in this case the GetInt32 method of DataReader class is the way that should be used.