I have GridView on my asp.net Page I want to validate the Gridview.
I want that in my Grid , Records with Null Value do not be displayed,Like I have some Null values In second column rows So I need to Hide those Null Values, In fact Entire row with a single null value shouldn't be displayed and I have imported the data in grid from excel.

Recommended Answers

All 2 Replies

Hi AliQadir,

One option for this is you can first store the excel values in datatable and then check the columns rows for null values before binding the data in gridview and once you get the null value eliminate that particular row.

Hey AliQadir,

Have you tried filtering the excel coloumns and then tried querying the data ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.