How to show NULL value using GridView in asp.net?

Question

I am using gridview to fetch the data from sqlserver. there are few values which are NULL. How to show these values using Gridview?

in sql server you can do something like SELECT ISNULL(ColumnName, 'no value') — M.Ali
– M.Ali, Commented Aug 10, 2015 at 11:54
how do you want to display them? as the word "NULL", a blank, etc? — psoshmo
– psoshmo, Commented Aug 10, 2015 at 11:56
Do you want handle nulls on sql server side or in c#? if either one is fine, Ali's comment is answer. — Sateesh Pagolu
– Sateesh Pagolu, Commented Aug 10, 2015 at 11:57

Sateesh Pagolu · Accepted Answer · 2015-08-10 11:58:36Z

2

As per your feedback in comments, use this..

SELECT ISNULL(ColumnName, 'NULL')

answered Aug 10, 2015 at 11:58

Sateesh Pagolu

9,6563 gold badges32 silver badges49 bronze badges

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

Comments

Neeraj Sharma · Accepted Answer · 2015-08-10 12:44:57Z

0

May be this will help you,

 <asp:GridView ID="id" runat="server" CellPadding="4">
            <Columns>
                <asp:TemplateField>
                    <ItemTemplate>                          
                            <%# Convert.ToString(Eval("columnName")) == null ? 'any text you want to write' : Eval("columnName") %>                         
                    </ItemTemplate>                     
                </asp:TemplateField>
</asp:GridView>

edited Aug 10, 2015 at 12:44

answered Aug 10, 2015 at 12:08

Neeraj Sharma

5886 silver badges18 bronze badges

1 Comment

Sateesh Pagolu Over a year ago

you are converting it to string and comparing with keyword Null. dont you see an issue?

Collectives™ on Stack Overflow

How to show NULL value using GridView in asp.net?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related