Gridview分页：数据源不支持服务器端数据分页 [英] Gridview paging :The data source does not support server-side data paging

问题描述

如果我把AllowPaging =False这个有效，但我需要在我的项目上进行分页，当我把AllowPaging =True时它不起作用！

错误是数据源不支持服务器端数据分页

任何人都可以帮助我吗？我是新编码

谢谢



< asp：GridView ID =GridView6runat =serverBackColor =White

BorderColor =＃DEDFDEBorderStyle =NoneBorderWidth =1pxCellPadding =4

ForeColor =BlackGridLines =VerticalWidth = 507pxPageSize =3

AllowPaging =Trueonpageindexchanging =GridView6_PageIndexChanging>

< alternatingrowstyle backcolor =White>

< columns> < asp：TemplateField>

< itemtemplate>

< asp：CheckBox ID =CheckBox1runat =server/>





< footerstyle backcolor =＃CCCC99>

< HeaderStyle BackColor =＃6B696B字体粗体=TrueForeColor =White/>

< pagerstyle backcolor =＃F7F7DEforecolor =Blackhorizo​​ntalalign =Right>

字体-Bold =True/>

< rowstyle backcolor =＃F7F7DE>

< SelectedRowStyle BackColor =＃CE5D5AFont-Bold =真正的ForeColor =白色/>

< sortedascendingcellstyle backcolor =＃FBFBF2>

< sortedascendingheaderstyle backcolor =＃848384>

< sorteddescendingcellstyle backcolor =＃EAEAD3>

< sorteddescendingheaderstyle backcolor =＃575357>






代码落后：





SqlCommand cmd = new SqlCommand（ ，con）;

SqlDataReader dr1;

con.Open（）;

cmd.CommandText =my select quary

dr1 = cmd.ExecuteReader（）;

if（dr1.HasRows == true）

{

con.Close（ ）;

GridView6.DataSource = dr1;

GridView6.DataBind（）;

}

con.Close （）;

Hi ,if I put AllowPaging="False" this works but I need paging on my project,when I put AllowPaging="True" it doesnt work !
and error is "The data source does not support server-side data paging"
Can any body help me ? I am new in coding
thanks

<asp:GridView ID="GridView6" runat="server" BackColor="White"
BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4"
ForeColor="Black" GridLines="Vertical" Width="507px" PageSize="3"
AllowPaging="True" onpageindexchanging="GridView6_PageIndexChanging">
<alternatingrowstyle backcolor="White">
<columns> <asp:TemplateField >
<itemtemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />


<footerstyle backcolor="#CCCC99">
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
<pagerstyle backcolor="#F7F7DE" forecolor="Black" horizontalalign="Right">
Font-Bold="True" />
<rowstyle backcolor="#F7F7DE">
<SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<sortedascendingcellstyle backcolor="#FBFBF2">
<sortedascendingheaderstyle backcolor="#848384">
<sorteddescendingcellstyle backcolor="#EAEAD3">
<sorteddescendingheaderstyle backcolor="#575357">



code behind:


SqlCommand cmd = new SqlCommand(" ", con);
SqlDataReader dr1;
con.Open();
cmd.CommandText = "my select quary"
dr1 = cmd.ExecuteReader();
if (dr1.HasRows == true)
{
con.Close();
GridView6.DataSource = dr1;
GridView6.DataBind();
}
con.Close();

推荐答案

使用 SqlDataAdapter 而不是使用 SqlDataReader



以下帖子用代码示例解释得很好。希望它对你有帮助..



http://stackoverflow.com/questions/17606868/data -source此结果不支持的服务器端数据寻呼 [<啊ref =http://stackoverflow.com/questions/17606868/data-source-does-not-support-server-side-data-pagingtarget =_ blanktitle =New Window> ^ ]



快乐编码

Use SqlDataAdapter instead of using SqlDataReader

Below post explains it well with code example.Hope it will help to you..

http://stackoverflow.com/questions/17606868/data-source-does-not-support-server-side-data-paging[^]

Happy coding

这篇关于Gridview分页：数据源不支持服务器端数据分页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！