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 asp.net, when i bind that on that time null values from column show's   in gridview.

How can i avoid these values in asp.net

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

1 solution

hi,
you have to handle null values using isnull method of sql
e.g
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