Loading

How to show message in empty gridview coulmn

Sujit Sahoo

8y752.NET

Here i have a gridview, i have five coulmn Id, Name,Age,Address and Phone no.

when i bind data from database into gridview my datas are bind but i have some query

for id 1 i have only two data means Ex-

Id-1

Name-Sujit

Age-23

Address-null

Phone no-Null

I want to show a message in null coulmn as "No data"

How to do this??

Any suggestion.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sujit Sahoo8y ago
yes i did it by Gridview on row databound event.

My code is working Fine.
0
Sujit Sahoo8y ago
same how to do it in Linq query?

Any idea?
0
Suraj Kumar8y ago
In that case you can write

SELECT
ISNULL(Id, "No Data") AS Id, ISNULL(PhoneNo,'No Data') AS PhoneNo, ISNULL(Name,'No Data') AS EmpName
FROM tblContactInfo

You can write ISNULL for every column in sql server.
0
Sujit Sahoo8y ago
I mentioned the value null will be for id 1 ok.

if for id 2 i got name as null value then how the sql statement work??
0
Suraj Kumar8y ago
Hello Sujit,

You can use select statement in sql server as below for all null values present in the table.

SELECT ISNULL(PhoneNo,'No Data') FROM tblContactInfo

It will automatically display "No data" where ever the data will be NULL in gridview column.

Thanks
Suraj
0