Paging Datagrid - Prev / Next will not appear as links

[Darren]

Dear Groups

I've used paging with a datagrid in C# at least a hundred times, but
for whatever reason, I cannot get the prev /next to appear as links.
It is absolutely certain that the number of records exceed the page
size.

Code is as follows:

<asp:datagrid id="grdStores" runat="server" allowpaging="True"
autogeneratecolumns="False" allowcustompaging="True"">
<alternatingitemstyle backcolor="#F0F1F3"></alternatingitemstyle>
<itemstyle cssclass="grdrow"></itemstyle>
<headerstyle cssclass="grdheader"></headerstyle>
<columns>
<asp:boundcolumn datafield="Name" headertext="Store Name">
<itemstyle width="25%"></itemstyle>
</asp:boundcolumn>
<asp:boundcolumn datafield="Address" headertext="Store Address">
<itemstyle width="50%"></itemstyle>
</asp:boundcolumn>
<asp:boundcolumn datafield="City" headertext="City">
<itemstyle width="20%"></itemstyle>
</asp:boundcolumn>
<asp:templatecolumn>
<headerstyle cssclass="grdheader"></headerstyle>
<itemstyle width="15px"></itemstyle>
<itemtemplate>
<asp:linkbutton id="lnkEdit" commandname="Edit" commandargument='<%#
DataBinder.Eval(Container.DataItem, "storeid" ) %>'
runat=server>Edit</asp:linkbutton>
</itemtemplate>
</asp:templatecolumn>
</columns>
<pagerstyle nextpagetext="Next" prevpagetext="Prev"></pagerstyle>
</asp:datagrid>

Databinding
SqlConnection connLC;
SqlCommand cmd;
SqlDataReader dtrCombos;
connLC = new
SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
connLC.Open();
string cSql="Select * from stores order by Name";
cmd = new SqlCommand(cSql , connLC);
dtrCombos = cmd.ExecuteReader();
if (dtrCombos.Read())
{
dtrCombos.Close();
dtrCombos = cmd.ExecuteReader();
grdStores.DataSource=dtrCombos;
grdStores.DataBind();
}
dtrCombos.Close();
connLC.Close();

Thanks in advance,

Darren

[Teemu Keiski]

As you have custom paging enabled (allowcustompaging="true"), you should
tell the exact row count for the grid via VirtualItemCount property. Another
thing being that paging with a datareader can get difficult.

--
Teemu Keiski
ASP.NET MVP, AspInsider
Finland, EU
http://blogs.aspadvice.com/joteke

[vinay]

Set AllowPaging="True"

U have allowcustompaging="True" , are u using custom paging??
--
http://pathidotnet.blogspot.com
=====
vInAypAtHi
o__
---_,>/'_------
(_) \(_)
---------------
"Darren" wrote:

Dear Groups

I've used paging with a datagrid in C# at least a hundred times, but
for whatever reason, I cannot get the prev /next to appear as links.
It is absolutely certain that the number of records exceed the page
size.

Code is as follows:

<asp:datagrid id="grdStores" runat="server" allowpaging="True"
autogeneratecolumns="False" allowcustompaging="True"">
<alternatingitemstyle backcolor="#F0F1F3"></alternatingitemstyle>
<itemstyle cssclass="grdrow"></itemstyle>
<headerstyle cssclass="grdheader"></headerstyle>
<columns>
<asp:boundcolumn datafield="Name" headertext="Store Name">
<itemstyle width="25%"></itemstyle>
</asp:boundcolumn>
<asp:boundcolumn datafield="Address" headertext="Store Address">
<itemstyle width="50%"></itemstyle>
</asp:boundcolumn>
<asp:boundcolumn datafield="City" headertext="City">
<itemstyle width="20%"></itemstyle>
</asp:boundcolumn>
<asp:templatecolumn>
<headerstyle cssclass="grdheader"></headerstyle>
<itemstyle width="15px"></itemstyle>
<itemtemplate>
<asp:linkbutton id="lnkEdit" commandname="Edit" commandargument='<%#
DataBinder.Eval(Container.DataItem, "storeid" ) %>'
runat=server>Edit</asp:linkbutton>
</itemtemplate>
</asp:templatecolumn>
</columns>
<pagerstyle nextpagetext="Next" prevpagetext="Prev"></pagerstyle>
</asp:datagrid>

Databinding
SqlConnection connLC;
SqlCommand cmd;
SqlDataReader dtrCombos;
connLC = new
SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
connLC.Open();
string cSql="Select * from stores order by Name";
cmd = new SqlCommand(cSql , connLC);
dtrCombos = cmd.ExecuteReader();
if (dtrCombos.Read())
{
dtrCombos.Close();
dtrCombos = cmd.ExecuteReader();
grdStores.DataSource=dtrCombos;
grdStores.DataBind();
}
dtrCombos.Close();
connLC.Close();

Thanks in advance,

Darren

[Darren]

Thanks for your assistance everyone. Absolutely, using the datareader
in this scenario was problematic. I switched to a dataset and problem
solved. Thanks again.

Darren