Ad:

ASP.NET Discussion Thread
Unsolved
Views: 38028

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Feb 9th, 2007

Gridview display for an empty dataset

Expand Post »

Hi Everybody

How can i display in the gridview.
"there is no data for this request" if the binded dataset is empty?

Can anyone give some ideas?

Thanks

Similar Threads

MultiLine TextBoxes in GridView edit mode in ASP.NET
GridView With More than one table in ASP.NET
Special formatting of a GridView... in ASP.NET
How can i retrieve data after i logod on..... in ASP.NET

Sarah Lee

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

45 posts
since Sep 2006

Permalink

Feb 9th, 2007

Re: Gridview display for an empty dataset

why not check whether the DataSet has any rows in code before binding then show/hide a label with that text?

sedgey

Reputation Points: 68

Solved Threads: 9

Junior Poster

Offline

130 posts
since Jan 2007

Permalink

Feb 9th, 2007

Re: Gridview display for an empty dataset

alternatively if it must appear in the grid view, why not build a data table with one column called result and add a row who's value is your text, then bind it to your grid view

sedgey

Reputation Points: 68

Solved Threads: 9

Junior Poster

Offline

130 posts
since Jan 2007

Permalink

Feb 12th, 2007

Re: Gridview display for an empty dataset

Thanks
First one seems to be more easy
I will try for that

Sarah Lee

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

45 posts
since Sep 2006

Permalink

Feb 12th, 2007

Re: Gridview display for an empty dataset

GridView supports EmptyDataRowStyle

http://msdn2.microsoft.com/en-us/lib...arowstyle.aspx

nikkiH

Reputation Points: 13

Solved Threads: 4

Junior Poster in Training

Offline

79 posts
since Dec 2006

Permalink

Feb 12th, 2007

Re: Gridview display for an empty dataset

spot on nikkiH

sedgey

Reputation Points: 68

Solved Threads: 9

Junior Poster

Offline

130 posts
since Jan 2007

Permalink

May 25th, 2009

Re: Gridview display for an empty dataset

If there is No Data in Gridview and we want to show a message that “No data available”.
We can do this by using the following tag in gridview.

ASP.NET Syntax (Toggle Plain Text)

<EmptyDataTemplate>
 
No Data Available
 
</EmptyDataTemplate>

znetweb

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

17 posts
since May 2008

Permalink

May 26th, 2009

Re: Gridview display for an empty dataset

JUST ADD THE EmptyDataText PROPERTY IN THE FOLLOWING WAY:

ASP.NET Syntax (Toggle Plain Text)
<asp:GridView runat="server" ID="gvCaseDetail" Width="100%" 
    EmptyDataText="there is no data for this request"
......................................
<asp:GridView runat="server" ID="gvCaseDetail" Width="100%" 
    EmptyDataText="there is no data for this request"
......................................

YOU CAN ALSO RENDER HTMEL TEXT LIKE:

ASP.NET Syntax (Toggle Plain Text)
<asp:GridView runat="server" ID="gvCaseDetail" Width="100%" 
    EmptyDataText="<table cellspacing=1 cellpadding=4 rules=rows border=0 style=color:Black;font-family:Tahoma;font-size:1em;width:730px;border-collapse:collapse;><tr style=color:Black;background-color:#00BFFF;font-weight:bold;><th scope=col>Case ID</th><th align=center scope=col>Subject</th><th align=center scope=col>Status</th><th align=center scope=col>Date</th><th align=center scope=col>Action</th></tr></table>"
..............................
<asp:GridView runat="server" ID="gvCaseDetail" Width="100%" 
    EmptyDataText="<table cellspacing=1 cellpadding=4 rules=rows border=0 style=color:Black;font-family:Tahoma;font-size:1em;width:730px;border-collapse:collapse;><tr style=color:Black;background-color:#00BFFF;font-weight:bold;><th scope=col>Case ID</th><th align=center scope=col>Subject</th><th align=center scope=col>Status</th><th align=center scope=col>Date</th><th align=center scope=col>Action</th></tr></table>"
..............................

ONE THING YOU HAVE TO KEEP IN MIND THAT IF YOU DIDN'T BIND ANY DATASOURCE YOU WILL GET BLANK.

mail2saion

Reputation Points: 26

Solved Threads: 44

Posting Whiz in Training

Offline

247 posts
since Apr 2009

Permalink

May 26th, 2009

Re: Gridview display for an empty dataset

Dear,

zneweb and mail2saion have solved your problem.

ASP.NET Syntax (Toggle Plain Text)
 <asp:GridView ID="GridView1" runat="server">
            <EmptyDataTemplate>
                There is no data.
            </EmptyDataTemplate>
        </asp:GridView>
 <asp:GridView ID="GridView1" runat="server">
            <EmptyDataTemplate>
                There is no data.
            </EmptyDataTemplate>
        </asp:GridView>

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

May 26th, 2009

Re: Gridview display for an empty dataset

try with this. My english is poor ok?

ASP.NET Syntax (Toggle Plain Text)
    Public Sub CheckEmptyGrid(ByVal grid As WebControls.GridView)
 
            If grid.Rows.Count = 0 And Not grid.DataSource Is Nothing Then
                Dim dt As Object = Nothing
                If grid.DataSource.GetType Is GetType(Data.DataSet) Then
                    dt = New System.Data.DataSet
                    dt = CType(grid.DataSource, System.Data.DataSet).Tables(0).Clone()
                ElseIf grid.DataSource.GetType Is GetType(Data.DataTable) Then
                    dt = New System.Data.DataTable
                    dt = CType(grid.DataSource, System.Data.DataTable).Clone()
                ElseIf grid.DataSource.GetType Is GetType(Data.DataView) Then
                    dt = New System.Data.DataView
                    dt = CType(grid.DataSource, System.Data.DataView).Table.Clone
                End If
                dt.Rows.Add(dt.NewRow())
                grid.DataSource = dt
                grid.DataBind()
                grid.Rows(0).Visible = False
                grid.Rows(0).Controls.Clear()
            End If
        End Sub
    Public Sub CheckEmptyGrid(ByVal grid As WebControls.GridView)

            If grid.Rows.Count = 0 And Not grid.DataSource Is Nothing Then
                Dim dt As Object = Nothing
                If grid.DataSource.GetType Is GetType(Data.DataSet) Then
                    dt = New System.Data.DataSet
                    dt = CType(grid.DataSource, System.Data.DataSet).Tables(0).Clone()
                ElseIf grid.DataSource.GetType Is GetType(Data.DataTable) Then
                    dt = New System.Data.DataTable
                    dt = CType(grid.DataSource, System.Data.DataTable).Clone()
                ElseIf grid.DataSource.GetType Is GetType(Data.DataView) Then
                    dt = New System.Data.DataView
                    dt = CType(grid.DataSource, System.Data.DataView).Table.Clone
                End If
                dt.Rows.Add(dt.NewRow())
                grid.DataSource = dt
                grid.DataBind()
                grid.Rows(0).Visible = False
                grid.Rows(0).Controls.Clear()
            End If
        End Sub

and the call

ASP.NET Syntax (Toggle Plain Text)

CheckEmptyGrid(Grid)

With this the headers appers ok

argisoft

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2009

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Get images from database to Ajaxslideshow

Next Thread in ASP.NET Forum Timeline: DropDownList problem

DaniWeb Message

Cancel Changes

User Name
Password