Error when databinding

[Nathan Sokalski]

When I run my application, which uses databinding in a DataList, I recieve the following error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Public member 'title' on type 'DataRowView' not found.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.MissingMemberException: Public member 'title' on type 'DataRowView' not found.

Source Error:

Line 65: <ItemStyle Font-Names="Arial,Helvetica,Sans-Serif" BackColor="Silver"></ItemStyle>
Line 66: <ItemTemplate>
Line 67: <asp:HyperLink id=lnkTitle1 runat="server" NavigateUrl='<%# "viewpoem.aspx?poem=" &amp; Server.UrlEncode(Container.DataItem.title) %>' Text='<%# DataBinder.Eval(Container, "DataItem.title") %>' Width="400px" Font-Size="Medium">
Line 68: </asp:HyperLink>
Line 69: <asp:Label id=lblRating1 runat="server" Text="<%# FormatNumber(CDbl(Container.DataItem.totalpoints)/CDbl(Container.DataItem..timesrated),1,TriState.Tr ue) %>" Width="40px" Font-Size="Medium">

Source File: c:\inetpub\wwwroot\poetry\poemratings.aspx Line: 67

Stack Trace:

[MissingMemberException: Public member 'title' on type 'DataRowView' not found.]
Microsoft.VisualBasic.CompilerServices.LateBinding .LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack) +885
ASP.poemratings_aspx.__DataBind__control12(Object sender, EventArgs e) in c:\inetpub\wwwroot\poetry\poemratings.aspx:67
System.Web.UI.Control.OnDataBinding(EventArgs e) +66
System.Web.UI.Control.DataBind() +26
System.Web.UI.Control.DataBind() +86
System.Web.UI.WebControls.DataList.CreateItem(Int3 2 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +127
System.Web.UI.WebControls.DataList.CreateControlHi erarchy(Boolean useDataSource) +686
System.Web.UI.WebControls.BaseDataList.OnDataBindi ng(EventArgs e) +49
System.Web.UI.WebControls.BaseDataList.DataBind() +23
localhost.poetry.poemratings.SortPoems(String sortby) in C:\Inetpub\wwwroot\poetry\poemratings.aspx.vb:59
localhost.poetry.poemratings.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\poetry\poemratings.aspx.vb:41
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750



--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032


I cannot figure out why this is happening. The code I use to do the binding, which I call from Page_Load using Me.SortPoems("title") is as follows:


Private Sub SortPoems(ByVal sortby As String)
Dim ratedpoems As New DataSet
Dim sqltext As String = "SELECT * FROM poemratings ORDER BY "

Select Case sortby
Case "title"
sqltext &= "title"
Case "rating"
sqltext &= "(totalpoints/timesrated),timesrated,title"
Case "timesrated"
sqltext &= "timesrated,(totalpoints/timesrated),title"
End Select
Dim dataadapterSelect As New System.Data.OleDb.OleDbDataAdapter(sqltext, Global.GetDBConnection())
dataadapterSelect.Fill(ratedpoems)
datRatings.DataSource = ratedpoems
datRatings.DataBind()
End Sub


I have tried several experiments (such as removing the databinding expressions that use the field, but the same thing happens with the other fields). Why is ASP.NET telling me the field is not there? Any help would be appreciated. Thanks.
--
Nathan Sokalski
[email]njsokalski@hotmail.com[/email]
[url]http://www.nathansokalski.com/[/url]

[Cor Ligthert [MVP]]

Nathan

Try it in this case with a datatable.

I hope this helps,

Cor