How to handle null value while executing the query

Question

suppose there 5 column in my table info(id,loginid,pagename,pagecount,detail). I am executing the query like, select the pagename when loginid=somthing and id =something.But in column that is pagecount(int) and pagename(varchar),I am not putting any thing ,so it consider as null.When execute the query,result shows the column with null value.Query's result move to else part.How to handle with that null value.

if(table.Rows.count == 0)
{
}
else
{
Actually coding.
}

your question isn't clear, are you looking for how to check if columns value is null or what? — Waqas
– Waqas, Commented Jul 27, 2011 at 10:05
When I am running the query ,geeting output in sql one row with null value.If the value is null still it take one row.So my code move to else part.So how to check the column value is null. — Komal
– Komal, Commented Jul 27, 2011 at 10:12

Waqas · Accepted Answer · 2011-07-27 10:22:09Z

1

This is how you check if the column's value is null

if (table.Rows.Count > 0) // if table is not empty
{
       if (Convert.IsDBNull(table.Rows[0]["columnName"])) // It's checking null value for columnName 'columnName' of first row
       {
                    //This column's value is null
       }
       else
       {
                    //column has value other than null
       }
}

answered Jul 27, 2011 at 10:22

Waqas

6,7903 gold badges36 silver badges53 bronze badges

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

4 Comments

Komal Over a year ago

Thanks Waqas,Shadow for your reply.Now it is working with [0]["columnname"].I would like to asked u one more that instead of null suppose there is nothing in that column.The column is empty.Then how to handle with that.If I am executing the query empty cell comes,then?I don't know how to handle that.

Waqas Over a year ago

its even simpler, use table.Rows[0]["columnName"].toString().trim() != string.empty.. but keep in mind that this piece of code will throw exception if the column value is null

Waqas Over a year ago

and also please mark this as your accepted answer if it helped you in finding what you were looking for....

Waqas Over a year ago

@Komal, welcome, between would you mind marking my answer as accepted by clicking the 'tick mark' on the left?

Collectives™ on Stack Overflow

How to handle null value while executing the query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related