ASP.NET

ASP.NET RSS

Gridview display for an empty dataset

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2006

Posts: 45

Reputation: Sarah Lee is an unknown quantity at this point

Solved Threads: 0

Sarah Lee

Offline

Light Poster

Gridview display for an empty dataset

Feb 9th, 2007

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

•

Join Date: Jan 2007

Posts: 130

Reputation: sedgey is on a distinguished road

Solved Threads: 8

sedgey

Offline

Junior Poster

Re: Gridview display for an empty dataset

Feb 9th, 2007

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

David Ridgway: so little daylight, too much caffeine
MCSD MCAD MCSE
http://web2asp.net

•

Join Date: Jan 2007

Posts: 130

Reputation: sedgey is on a distinguished road

Solved Threads: 8

sedgey

Offline

Junior Poster

Re: Gridview display for an empty dataset

Feb 9th, 2007

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

David Ridgway: so little daylight, too much caffeine
MCSD MCAD MCSE
http://web2asp.net

•

Join Date: Sep 2006

Posts: 45

Reputation: Sarah Lee is an unknown quantity at this point

Solved Threads: 0

Sarah Lee

Offline

Light Poster

Re: Gridview display for an empty dataset

Feb 12th, 2007

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

•

Join Date: Dec 2006

Posts: 79

Reputation: nikkiH is an unknown quantity at this point

Solved Threads: 4

nikkiH

Offline

Junior Poster in Training

Re: Gridview display for an empty dataset

Feb 12th, 2007

GridView supports EmptyDataRowStyle

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

Google is your friend. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
Bored? Visit http://www.kaelisspace.com/

•

Join Date: Jan 2007

Posts: 130

Reputation: sedgey is on a distinguished road

Solved Threads: 8

sedgey

Offline

Junior Poster

Re: Gridview display for an empty dataset

Feb 12th, 2007

spot on nikkiH

David Ridgway: so little daylight, too much caffeine
MCSD MCAD MCSE
http://web2asp.net

•

Join Date: May 2008

Posts: 17

Reputation: znetweb is an unknown quantity at this point

Solved Threads: 0

znetweb

Offline

Newbie Poster

Re: Gridview display for an empty dataset

May 25th, 2009

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.

Help with Code Tags

ASP.NET Syntax (Toggle Plain Text)

<EmptyDataTemplate>
 
No Data Available
 
</EmptyDataTemplate>

•

Join Date: Apr 2009

Posts: 220

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 33

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Re: Gridview display for an empty dataset

May 26th, 2009

JUST ADD THE EmptyDataText PROPERTY IN THE FOLLOWING WAY:

 Help with Code Tags 
 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:

 Help with Code Tags 
 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.

MARK AS SOLVED if its help you.

REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com

•

Join Date: Oct 2008

Posts: 2,634

Reputation: adatapost has much to be proud of

Solved Threads: 472

adatapost

Offline

Posting Maven

Re: Gridview display for an empty dataset

May 26th, 2009

Dear,

zneweb and mail2saion have solved your problem.

 Help with Code Tags 
 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>

Failure is not fatal, but failure to change might be. - John Wooden

•

Join Date: May 2009

Posts: 1

Reputation: argisoft is an unknown quantity at this point

Solved Threads: 0

argisoft

Offline

Newbie Poster

Re: Gridview display for an empty dataset

#10

May 26th, 2009

try with this. My english is poor ok?

 Help with Code Tags 
 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