asp.net GridView IF empty show message

Question

I've got a grid view. I want it to say "you have nothing to show" if there are no details.

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound


    If GridView1.Rows.Count = 0 Then
        Lblemptygridview.Text = "you do no details to show"

    Elseif e.Row.RowType = DataControlRowType.DataRow then
        Dim datakey As String = GridView1.DataKeys(e.Row.RowIndex).Value.ToString()

    End If


End Sub

However; it seems to be working backwards and showing the message when there is data to display in the gird view and continues to be a blank page when there is not data to display in the grid view.

I've tried a variety of combinations with the below IF statement below but no success.

Icarus · Accepted Answer · 2012-04-02 19:03:26Z

11

Instead, use the EmptyDataTemplate:

 <emptydatatemplate>
        No Data Found.  
    </emptydatatemplate>

answered Apr 2, 2012 at 19:03

Icarus

64k14 gold badges102 silver badges116 bronze badges

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

Comments

Gobbledigook · Accepted Answer · 2012-04-02 19:11:43Z

4

This is more of an addendum to Icarus's answer, adding a bit of context as to why your solution does not work. (For educational purposes).

RowDataBound is called when a Row is bound to the gridview. This basically means that this is called for every row in the grid view.

Now, the reason why your solution doesn't work, is that if your GridView simply has nothing in it, RowDataBound will not be called.

The reason why you're getting 'No Data Found' when you DO have data, is because the first time the if statement runs when loading a GridView, the GridView (at the time of execution) has no Rows, which results in your if statement being true.

Just something to keep in mind.

answered Apr 2, 2012 at 19:11

Gobbledigook

4721 gold badge6 silver badges20 bronze badges

Comments

JohnJ · Accepted Answer · 2012-04-02 19:52:06Z

1

Just a suggestion.. Instead of showing "you have nothing to show" in a gridview which looks outdated, why don't you make it fancy?? You can do

        Dim dt As DataTable = getDatatable()

        If Not dt Is Nothing AndAlso dt.Rows.Count > 0 Then
            GridView1.datasource = dt
            GridView1.databind()
            div.style.add("display", "none")
        Else
            GridView1.visible = False
            'Add some fancy style here to show no record
            div.style.add("display", "block")
        End If

thanks

answered Apr 2, 2012 at 19:52

JohnJ

111 bronze badge

1 Comment

Matt Browne Over a year ago

Sometimes it's good to explicitly tell the user that no results were found; it depends on the situation.

Collectives™ on Stack Overflow

asp.net GridView IF empty show message

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related