blocks|key|3080918|text|结果变量上的一个简单的ToList()应该可以工作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3080919|编辑：正如我的答案下面的注释中所解释的那样，错误的原因是数据源应该实现ICollection。IEnumerable不会，当您执行ToList()时，它会将其转换为实现ICollection的列表。|BOLD|3080920|entityMap^0|B|8|0|0|2|1T|8|0^^$0|@$1|2|3|4|5|6|7|K|8|@$9|L|A|M|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|N|8|@$9|O|A|P|B|H]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|I|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|J|$]]

A simple <code>ToList()</code> on your result var should work.

Edit: 
As explained in comments below my answer, the reason for the error is that the data source should implement ICollection. IEnumerable does not, when you do <code>ToList()</code> it converts it into a list which implements ICollection.

blocks|key|326916|text|你也可以使用泛型List<T>。请参阅示例代码片段：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|326917|public+List<Company>+GetContactList(int+startindex)
{

++++string+path+=+Server.MapPath("~/contacts.xml");
++++XDocument+xd+=+XDocument.Load(path);
++++IEnumerable<Company>+results+=+(from+items+in+xd.Elements("Company").Elements("Contact")
+++++++++++++++++++select+new+Company
+++++++++++++++++++{
+++++++++++++++++++++++Id+=+items.Element("ID").Value,
+++++++++++++++++++++++Photo+=+(string)items.Element("photo").Value,
+++++++++++++++++++++++Name+=+(string)items.Element("Name").Value,
+++++++++++++++++++++++BloodGroup+=+(string)items.Element("Bg").Value,
+++++++++++++++++++++++Dob+=+(string)items.Element("dob").Value,
+++++++++++++++++++++++Anniversery+=+(string)items.Element("avd").Value,
+++++++++++++++++++++++Mobile+=+(string)items.Element("cnum").Value,
+++++++++++++++++++++++designation+=+(string)items.Element("desig").Value,
+++++++++++++++++++++++Team+=+(string)items.Element("team").Value
+++++++++++++++++++}).Skip(startindex*10).Take(10);
++++return+(List<Company>)+results;
}|code-block|syntax|javascript|326918|​|326919|您还可以使用DataSet/DataTable代替DataReader。|326920|entityMap^0|8|7|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|V|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

You can use generic <code>List&lt;T&gt;</code> also. See the sample code snippet:

<pre><code>public List&lt;Company&gt; GetContactList(int startindex)
{

 string path = Server.MapPath("~/contacts.xml");
 XDocument xd = XDocument.Load(path);
 IEnumerable&lt;Company&gt; results = (from items in xd.Elements("Company").Elements("Contact")
 select new Company
 {
 Id = items.Element("ID").Value,
 Photo = (string)items.Element("photo").Value,
 Name = (string)items.Element("Name").Value,
 BloodGroup = (string)items.Element("Bg").Value,
 Dob = (string)items.Element("dob").Value,
 Anniversery = (string)items.Element("avd").Value,
 Mobile = (string)items.Element("cnum").Value,
 designation = (string)items.Element("desig").Value,
 Team = (string)items.Element("team").Value
 }).Skip(startindex*10).Take(10);
 return (List&lt;Company&gt;) results;
}
</code></pre>



You can also use DataSet/DataTable instead of DataReader.

blocks|key|3294369|text|在ObjectDataSource中，只需添加可以工作的enablePaging="true"即可。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3294370|entityMap^0|S|J|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

In ObjectDataSource just add <code>enablePaging="true"</code> that will work.

blocks|key|3080984|text|我已经将我的代码修改为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3080985|public+List<string>+ListofNewsTitle()
{
++++var+query+=+from+n+in+db.NewsEvents
++++++++++++++++orderby+n.NewsDate+descending
++++++++++++++++select+n.NewsTitle;
++++return+query.ToList();++++++++
}|code-block|syntax|javascript|3080986|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I've changed my code to this:

<pre><code>public List&lt;string&gt; ListofNewsTitle()
{
 var query = from n in db.NewsEvents
 orderby n.NewsDate descending
 select n.NewsTitle;
 return query.ToList(); 
}
</code></pre>

blocks|key|326041|text|.ToList()在DataSource的末尾，我分配的工作如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|326042|gvCaseLabelsLeft.DataSource+=+caseLabelsList.OrderBy(c=>c.caseLabelNumber).ToList();|code-block|syntax|javascript|326043|entityMap^0|0|9|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

<code>.ToList()</code> at the end of the DataSource, I am assigning worked for me like below:

<pre><code>gvCaseLabelsLeft.DataSource = caseLabelsList.OrderBy(c=&gt;c.caseLabelNumber).ToList();
</code></pre>

blocks|key|326045|text|LINQ查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|326046|ProductController.cs：|326047|List<Product>+products=+productModel.GetProducts(start,+offset);|code-block|syntax|javascript|326048|ProductModel.cs：|326049|public+List<Product>+GetProducts(int+start,+int+offset)
{
++++IEnumerable<Product>+query+=+from+m+in+db.Products
+++++++++++++++++++++++++++++++++orderby+m.Id+descending
+++++++++++++++++++++++++++++++++select+m;
++++query+=+query.Skip(start).Take(offset);
++++return+query.ToList();
}|326050|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

LINQ query:

ProductController.cs:

<pre><code>List&lt;Product&gt; products= productModel.GetProducts(start, offset);
</code></pre>

ProductModel.cs:

<pre><code>public List&lt;Product&gt; GetProducts(int start, int offset)
{
 IEnumerable&lt;Product&gt; query = from m in db.Products
 orderby m.Id descending
 select m;
 query = query.Skip(start).Take(offset);
 return query.ToList();
}
</code></pre>

blocks|key|3294457|text|如果你使用的是SqldataReader，那么它不支持分页。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3294458|此错误的解决方案是使用泛型列表集合、DataTables、DataSets等DataSources来绑定GridView。|3294459|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If You are Using SqldataReader then its not support Paging.

Solution to this error is making use of DataSources such as Generic List collections, DataTables, DataSets, etc. to bind the GridView.

blocks|key|3081071|text|试试这篇文章https://www.aspsnippets.com/Articles/ASPNet-GridView-The-data-source-does-not-support-server-side-data-paging.aspx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3081072|总之，试着使用下面这几行|3081073|private+void+BindGrid()
{
++++string+constr+=+ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
++++using+(SqlConnection+con+=+new+SqlConnection(constr))
++++{
++++++++using+(SqlCommand+cmd+=+new+SqlCommand("SELECT+CustomerId,+ContactName,+Country+FROM+Customers"))
++++++++{
++++++++++++cmd.Connection+=+con;
++++++++++++con.Open();
++++++++++++using+(SqlDataReader+sdr+=+cmd.ExecuteReader())
++++++++++++{
++++++++++++++++GridView1.DataSource+=+sdr;
++++++++++++++++GridView1.DataBind();
++++++++++++}
++++++++++++con.Close();
++++++++}
++++}
}

protected+void+OnPaging(object+sender,+GridViewPageEventArgs+e)
{
++++GridView1.PageIndex+=+e.NewPageIndex;
++++this.BindGrid();
}

<asp:GridView+ID="GridView1"+runat="server"+AutoGenerateColumns="false"+AllowPaging="true"
OnPageIndexChanging="OnPaging">
<Columns>
++++<asp:BoundField+DataField="CustomerID"+HeaderText="CustomerID"+/>
++++<asp:BoundField+DataField="ContactName"+HeaderText="ContactName"+/>
++++<asp:BoundField+DataField="Country"+HeaderText="Country"+/>
</Columns>|code-block|syntax|javascript|3081074|​|3081075|entityMap|0|LINK|mutability|MUTABLE|url|https://www.aspsnippets.com/Articles/ASPNet-GridView-The-data-source-does-not-support-server-side-data-paging.aspx^0|6|36|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

Try this article
<a href="https://www.aspsnippets.com/Articles/ASPNet-GridView-The-data-source-does-not-support-server-side-data-paging.aspx" rel="nofollow noreferrer">https://www.aspsnippets.com/Articles/ASPNet-GridView-The-data-source-does-not-support-server-side-data-paging.aspx</a>

in summary try to use these lines

<pre><code>private void BindGrid()
{
 string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
 using (SqlConnection con = new SqlConnection(constr))
 {
 using (SqlCommand cmd = new SqlCommand("SELECT CustomerId, ContactName, Country FROM Customers"))
 {
 cmd.Connection = con;
 con.Open();
 using (SqlDataReader sdr = cmd.ExecuteReader())
 {
 GridView1.DataSource = sdr;
 GridView1.DataBind();
 }
 con.Close();
 }
 }
}

protected void OnPaging(object sender, GridViewPageEventArgs e)
{
 GridView1.PageIndex = e.NewPageIndex;
 this.BindGrid();
}

&lt;asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" AllowPaging="true"
OnPageIndexChanging="OnPaging"&gt;
&lt;Columns&gt;
 &lt;asp:BoundField DataField="CustomerID" HeaderText="CustomerID" /&gt;
 &lt;asp:BoundField DataField="ContactName" HeaderText="ContactName" /&gt;
 &lt;asp:BoundField DataField="Country" HeaderText="Country" /&gt;
&lt;/Columns&gt;
</code></pre>

I have a GridView on my screen and need it to allow paging.

Markup:

<pre><code>&lt;asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
 AutoGenerateColumns="False" DataSourceID="ObjectDataSource1"&gt;
 &lt;Columns&gt;
 &lt;asp:BoundField DataField="appID" HeaderText="appID" SortExpression="appID" /&gt;
 &lt;/Columns&gt;
&lt;/asp:GridView&gt;

&lt;asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
 SelectMethod="GetBookingId" 
 TypeName="AppointmentRepository"&gt;
 &lt;SelectParameters&gt;
 &lt;asp:Parameter Name="maximumRows" Type="Int32" /&gt;
 &lt;asp:Parameter Name="startRowIndex" Type="Int32" /&gt;
 &lt;/SelectParameters&gt;
&lt;/asp:ObjectDataSource&gt;
</code></pre>

Code-behind:

<pre><code>ObjectDataSource1.SelectParameters["maximumRows"].DefaultValue = "10";
ObjectDataSource1.SelectParameters["startRowIndex"].DefaultValue = "0";
</code></pre>

LINQ query:

<pre><code>public IQueryable&lt;tblAppointment&gt; GetBookingId(int maximumRows, int startRowIndex)
{
 var result = (FROM a IN dc.tblAppointments
 SELECT a).Skip(startRowIndex).Take(maximumRows);
}
</code></pre>

However I receive this error:

<blockquote>
 The data source does not support server-side data paging. 
</blockquote>

What am I doing wrong?

The data source does not support server-side data paging

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我的屏幕上有一个GridView，需要它来允许分页。标记：<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="ObjectDataSource1"> <Co...

问数据源不支持服务器端数据分页
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据源不支持服务器端数据分页EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据源不支持服务器端数据分页
EN