Empty DataSet and GridView

[shapper]

Hello,

Is it possible to display a message in a GridView such as "No Records
Available" when the DataSet is empty?

Thanks,

Miguel

 

[Guest]

Hi Miguel,
GridView contains EmptyDataTemplate which is used in your case.

Regards,
Ladislav

 

[Mike]

or you could just not show the grid and show a message in its place if your
ds is empty.

something like
if(ds.row.count > 0)
{
show grid
}
else
{
show no records found message
}

 

[weston.jossey]

Hello,

Is it possible to display a message in a GridView such as "No Records
Available" when the DataSet is empty?

Thanks,

Miguel

You can also, if you would prefer the columns and grids did not
display as there is no data, to read the property Rows from the
GridView, and if (rows == 0) then alertLabel.Visible = true;
alertLabel.Text = "Blah blah"

Where an alertLabel is merely an invisible label you hide in your
screen to display only upon empty resultant sets.

 

[shapper]

or you could just not show the grid and show a message in its place if your
ds is empty.

something like
if(ds.row.count > 0)
{
show grid}

else
{
show no records found message

}

Hi,

I need o create it at runtime and I am having a few problems. On my
GridView ITemplate I have the following:

Dim edtPost As New TemplateField
edtPost.ItemTemplate = New edtPost(ListItemType.Item)
gvPosts.EmptyDataTemplate = edtPost

edtPost is a class as follows:


' edtPost
Private Class edtPost
Implements ITemplate

Private Type As ListItemType

Public Sub New(ByVal type As ListItemType)
Me.Type = type
End Sub ' New

Public Sub InstantiateIn(ByVal container As Control) Implements
ITemplate.InstantiateIn

' Select template type
Select Case Me.Type

Case ListItemType.Item ' Item template

Dim l As New Label
l.Text = "No Records Found"
container.Controls.Add(l)

End Select

End Sub ' InstantiateIn

End Class ' edtPost


I am getting the error:

Unable to cast object of type
'System.Web.UI.WebControls.TemplateField' to type
'System.Web.UI.ITemplate'.

On code line:

gvPosts.EmptyDataTemplate = edtPost

How can I solve this?

Thanks,

Miguel