GridView not Showing Headers When there are No Rows

[Steve Harclerode]

Hi,

I'm trying to get my DataGrid to show headers and footers when no rows are
returned from the datasource. Below is code that shows the first
TemplateField. Is there an easy way to get at least the footer to show? I
want to be able to insert a new row using the footer. Thanks...

<asp:GridView ID="gvMaterials " runat="server"
AutoGenerateCol umns="False"
DataSourceID="d sMaterials" ShowFooter="Tru e" Width="100%"
AutoGenerateEdi tButton="True">
<Columns>
<asp:TemplateFi eld HeaderText="Mat erial:">
<FooterTemplate >
<asp:TextBox ID="txtDescript ion"
runat="server"> </asp:TextBox>
</FooterTemplate>
<EditItemTempla te>
<asp:TextBox ID="txtDescript ion" runat="server"
Text='<%# Bind("Descripti on") %>'></asp:TextBox>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="lblDescript ion" runat="server" Text='<%#
Bind("Descripti on") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
[etc...]

--
My BizTalk blog:
http://stevestechnotes.blogspot.com/

[Marc Gravell]

What is the actual data-source - i.e. the object you give to
dsMaterials?

I'm going to go out on a limb and guess that it is an ArrayList?

To get metadata, it needs some clue to the data. There are various
ways it can do this - the simplest is a typed indexer - i.e. a "public
T this[int index] {get;}" for some T (doesn't have to be generics...).

In the absense of a typed indexer, the metadata of the first item is
used. If there aren't any items, you're scuppered.

(there are also things like ITypedList and IListSource that are taken
into account, but these are more complex)

[Marc Gravell]

Oops; I forgot to say! If you are using an ArrayList, the easiest way
to fix this is to use a List<Tor BindingList<T>, or perhaps even
just an array: T[]

If you aren't using ArrayList, then tell us what you *are* using as
the data-source.

Marc

[Steve Harclerode]

I'm using a SqlDataSource that calls a stored procedure -- which contains a
simple "SELECT * FROM Tablex WHERE ...".

Thanks,
Steve

"Marc Gravell" <ma**********@g mail.comwrote in message
news:de******** *************** ***********@x35 g2000hsb.google groups.com...

What is the actual data-source - i.e. the object you give to
dsMaterials?

[Marc Gravell]

Hmmm... I would have expected to work. I'm sorry, but I don't know. If
you don't get any other takers, I would recommend posting on an asp
group, since there will be many GridView experts there...

Marc

[Sunil Lakshkar]

HI Steve,

Gridview does not display anything if database is returning zero number of rows.
In case you still want to display it then you can enter some dummy rows in an arraylist or dataset and then connect it to gridview and then hide that dummy row in grid , it will display only header and footer now.

[Steve Harclerode]

Thanks for your input, Sunil. I'll try that.

- Steve

<Sunil Lakshkarwrote in message news:20******** *************@g mail.com...

HI Steve,

Gridview does not display anything if database is returning zero number of
rows.
In case you still want to display it then you can enter some dummy rows in
an arraylist or dataset and then connect it to gridview and then hide that
dummy row in grid , it will display only header and footer now.