Empty DataSet and GridView

  • Thread starter Thread starter shapper
  • Start date Start date
S

shapper

Hello,

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

Thanks,

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

Regards,
Ladislav
 
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
}
 
Hello,

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

Thanks,

Miguel
Click to expand...

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.
 
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

}
Click to expand...

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
 
Back
Top