Member Avatar for AliQadir

Hi,
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.
Thanks

  • 3 Contributors
  • 2 Replies
  • 117 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by KushMishra
Member Avatar for DeadSoul

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.

Member Avatar for KushMishra

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, networking, learning, and sharing knowledge.