"no rows" message in a datagrid

[Andy Fish]

Hi,

when there are no rows to display in my asp.net datagrid control, I'd like
to put in a message saying "No results" or some such

Ideally I'd like the message to be centred across all the columns, but I'd
settle for the message appearing in a single cell, or header/footer line.
maybe there's a way to make the whole control invisible when there are no
rows in the data source.

TIA for any ideas

Andy

[Ben Lucas]

Any control can be made invisible by setting its "Visible" property to
false. You can check whether your data source has any rows and set the
DataGrid's "visible" property to false if it does. For example:

ASP.Net:

<asp:Label id="lblNoRows" runat="server" visible="false" >No
Results</asp:Label><br>
<asp:DataGrid id="dgData" runat="server" />

C# Code Behind:

private void Page_Load(objec t sender, System.EventArg s e)
{
DataTable dtSource;
//Code here retrieves data from data source into dtSource

if (dtSource.Rows. Count == 0)
lblNoRows.Visib le = true;
else
{
dgData.DataSour ce = dtSource;
dgData.DataBind ();
}
}

--
Ben Lucas
Lead Developer
Solien Technology, Inc.
www.solien.com
"Andy Fish" <aj****@blueyon der.co.uk> wrote in message
news:uz******** ******@TK2MSFTN GP12.phx.gbl...

Hi,

when there are no rows to display in my asp.net datagrid control, I'd like
to put in a message saying "No results" or some such

Ideally I'd like the message to be centred across all the columns, but I'd
settle for the message appearing in a single cell, or header/footer line.
maybe there's a way to make the whole control invisible when there are no
rows in the data source.

TIA for any ideas

Andy

[Andy Fish]

Do'h!

thanks ben,

I was thinking I had to somehow do this inside the databind - I was
forgetting I can just check the count of rows before calling DataBind()

Andy

"Ben Lucas" <be*@nospam.sol ien.nospam.com> wrote in message
news:Y-*************** *****@comcast.c om...

Any control can be made invisible by setting its "Visible" property to
false. You can check whether your data source has any rows and set the
DataGrid's "visible" property to false if it does. For example:

ASP.Net:

<asp:Label id="lblNoRows" runat="server" visible="false" >No
Results</asp:Label><br>
<asp:DataGrid id="dgData" runat="server" />

C# Code Behind:

private void Page_Load(objec t sender, System.EventArg s e)
{
DataTable dtSource;
//Code here retrieves data from data source into dtSource

if (dtSource.Rows. Count == 0)
lblNoRows.Visib le = true;
else
{
dgData.DataSour ce = dtSource;
dgData.DataBind ();
}
}

--
Ben Lucas
Lead Developer
Solien Technology, Inc.
www.solien.com
"Andy Fish" <aj****@blueyon der.co.uk> wrote in message
news:uz******** ******@TK2MSFTN GP12.phx.gbl...

Hi,

when there are no rows to display in my asp.net datagrid control, I'd like to put in a message saying "No results" or some such

Ideally I'd like the message to be centred across all the columns, but I'd settle for the message appearing in a single cell, or header/footer line. maybe there's a way to make the whole control invisible when there are no rows in the data source.

TIA for any ideas

Andy

[Ben Lucas]

No problem. Glad I could help.

--
Ben Lucas
Lead Developer
Solien Technology, Inc.
www.solien.com

"Andy Fish" <aj****@blueyon der.co.uk> wrote in message
news:OU******** *****@TK2MSFTNG P11.phx.gbl...

Do'h!

thanks ben,

I was thinking I had to somehow do this inside the databind - I was
forgetting I can just check the count of rows before calling DataBind()

Andy

"Ben Lucas" <be*@nospam.sol ien.nospam.com> wrote in message
news:Y-*************** *****@comcast.c om...

Any control can be made invisible by setting its "Visible" property to
false. You can check whether your data source has any rows and set the
DataGrid's "visible" property to false if it does. For example:

ASP.Net:

<asp:Label id="lblNoRows" runat="server" visible="false" >No
Results</asp:Label><br>
<asp:DataGrid id="dgData" runat="server" />

C# Code Behind:

private void Page_Load(objec t sender, System.EventArg s e)
{
DataTable dtSource;
//Code here retrieves data from data source into dtSource

if (dtSource.Rows. Count == 0)
lblNoRows.Visib le = true;
else
{
dgData.DataSour ce = dtSource;
dgData.DataBind ();
}
}

--
Ben Lucas
Lead Developer
Solien Technology, Inc.
www.solien.com
"Andy Fish" <aj****@blueyon der.co.uk> wrote in message
news:uz******** ******@TK2MSFTN GP12.phx.gbl...

Hi,

when there are no rows to display in my asp.net datagrid control, I'd like to put in a message saying "No results" or some such

Ideally I'd like the message to be centred across all the columns, but I'd settle for the message appearing in a single cell, or header/footer line. maybe there's a way to make the whole control invisible when there are no rows in the data source.

TIA for any ideas

Andy