How to set null value from SQL query to empty string in C#? [duplicate]

Question

I have to query array of strings from SQL using this code:

defaultMail = getDefaultMailList(requester);

and the sql query string is

SELECT * FROM dbo. ....

Then, I get array of string from the getDefaultMailList method:

string toEmail = defaultMail[0];
string ccEmail = defaultMail[1];

Then, I use the value of SQL query to make a condition of if else like this.

if (ccEmail != "")
{
    do something
}

Now, I met the problem when SQL query returns null value. The ccList != "" still returns TRUE, but I want to make it return FALSE.

How to handle with this problem?

Thank you.

use isnull funtion in your column. Like select isnull(Somecolumn,'') Somecolumn from sometable — Nagib Mahfuz
– Nagib Mahfuz, Commented Oct 8, 2020 at 6:21

IndieGameDev · Accepted Answer · 2020-10-08 06:27:47Z

2

To check if it's empty or null you can use the IsNullOrEmpty Function. This function will both check if the variable is null or empty.

If you want to check user input you could also use IsNullOrWhitespace, which additionally checks if the string consists of only whitespace characters.

// Check if the string is either empty or null.
if (string.IsNullOrEmpty(ccList))
{
    // do something
}

edited Oct 8, 2020 at 6:27

answered Oct 8, 2020 at 6:23

IndieGameDev

2,9843 gold badges19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Beingnin Over a year ago

string.IsNullOrWhiteSpace(ccList) also can be used and this will check for whitespaces too

IndieGameDev Over a year ago

Just wanted to add that :D.

Collectives™ on Stack Overflow

How to set null value from SQL query to empty string in C#? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related