Click here to Skip to main content
15,067,335 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a gridview in, when i bind that on that time null values from column show's   in gridview.

How can i avoid these values in

Please reply me...!
Sebastian T Xavier 3-Aug-12 2:34am
Null values or the whole column?

1 solution

you have to handle null values using isnull method of sql
select isnull(colName,'') from tablname

now if column contains null value then it return empty string

Best Luck

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900