Unable to cast object of type 'System.Web.UI. WebControls.Sql DataSource' to type 'System.Collect ions.IEnumerabl e'.

[Chris]

Hi,

I want to limit the amount of data shown in a page coming from a database.
Everything works except that I get the error:
"Unable to cast object of type 'System.Web.UI. WebControls.Sql DataSource' to
type 'System.Collect ions.IEnumerabl e'"
on line: PageDataSource. DataSource = SqlDataSource2

Thanks for help
code-behind:
-----------
Imports System.Data
Imports System.Data.Ole Db

Partial Class Item
Inherits System.Web.UI.P age

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load
Dim PageDSource As New PagedDataSource ()
PageDSource.Dat aSource = SqlDataSource2
PageDSource.All owPaging = True
PageDSource.Pag eSize = 6
End Sub
End Class
aspx file:
---------
<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:prod %>"
SelectCommand=" SELECT * FROM [Prod] WHERE ([ItemId] = @ItemId)">
<SelectParamete rs>
<asp:QueryStrin gParameter Name="CId" DefaultValue="1 "
QueryStringFiel d="ite" />
</SelectParameter s>
</asp:SqlDataSour ce>

[Teemu Keiski]

SqlDataSource isn't itself enumerable or a resultset, it's a "middle-man"
control to get you the resultset.

You would need to get the resultset out of the SqlDataSource by calling it's
Select method (with arguments), nad passing this returned object to the
DataSource property.

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

"Chris" <rr***@sdsd.dcw rote in message
news:e9******** *****@TK2MSFTNG P06.phx.gbl...

Hi,

I want to limit the amount of data shown in a page coming from a database.
Everything works except that I get the error:
"Unable to cast object of type 'System.Web.UI. WebControls.Sql DataSource'
to type 'System.Collect ions.IEnumerabl e'"
on line: PageDataSource. DataSource = SqlDataSource2

Thanks for help
code-behind:
-----------
Imports System.Data
Imports System.Data.Ole Db

Partial Class Item
Inherits System.Web.UI.P age

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load
Dim PageDSource As New PagedDataSource ()
PageDSource.Dat aSource = SqlDataSource2
PageDSource.All owPaging = True
PageDSource.Pag eSize = 6
End Sub
End Class
aspx file:
---------
<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:prod %>"
SelectCommand=" SELECT * FROM [Prod] WHERE ([ItemId] = @ItemId)">
<SelectParamete rs>
<asp:QueryStrin gParameter Name="CId" DefaultValue="1 "
QueryStringFiel d="ite" />
</SelectParameter s>
</asp:SqlDataSour ce>