Zero Check

Question

Sorry for such a simple question.

How can I check this for zeros?

obj.DivisionNotes = (string)row["DivisionNotes"];

I think something like this.

obj.DivisionNotes = (string)row["DivisionNotes"]?null:"No notes";

I'm right.

Any help is greatly appreciated.

Answer 1

Your null rejection will cause a problem, you can use a command aswith a null coalescing operator to solve your problems.

obj.DivisionNotes = (row["DivisionNotes"] as string) ?? "No notes";

Answer 2

You can use the ISNULL function in the original T-SQL query by changing this query:

SELECT ID, Name, DivisionNotes FROM tblWHATEVER

to

SELECT ID, Name, ISNULL(DivisionNotes, 'No notes') AS 
    DivisionNotes FROM tblWHATEVER

I'm not saying that this is better than checking for zero in the code, but sometimes a simple change in the request can save you from changing the code in a bunch of different places.

Answer 3

datarow. , , .