Member Avatar for Doc Holiday

Hi All,

I have a datagrid that that get populated from a SQL store procedure and I need to hide the row(s) that are blank. Any idea how I can force the datagrid not to show blank row(s)?


Thanks
Doc Holiday

  • 2 Contributors
  • 1 Reply
  • 55 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by sbv
Member Avatar for sbv

Hi All,

I have a datagrid that that get populated from a SQL store procedure and I need to hide the row(s) that are blank. Any idea how I can force the datagrid not to show blank row(s)?


Thanks
Doc Holiday

Hi,
You can do it from Server side. In Item Bound method you can check for cells values in a Row.
Like, here code by considering there are only two cells in rows

If  (e.Item.Cells(0).Text = "" and  e.Item.Cells(1).Text = "" ) then
                        e.Item.Cells(0).Visible = False
                        e.Item.Cells(1).Visible = False
                End if

Hope this will help you.

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.