I am attemting to convert my asp.NET web application to use SQLite instead of Access. It connects just fine, but when I try to do the call to databind() on the web control I get the exception "System.Web.HttpException:DataBinder.Eval: 'Finisar.SQLite.SQLiteDataReader' does not contain a property with the name ReportDisplayName". I looked in at the datareader in the debugger and the field was present in the list of mFieldNames, along with the other column read. It all looks fine, the data is there.
here is the code
string sqlText = "SELECT " + nameFld+","+ idFld+" FROM ["+table+"]";
dr = GetDr( sqlText );
if(control.DataTextField != nameFld)
control.DataTextField = nameFld;
if(control.DataValueField != idFld)
control.DataValueField = idFld;
control.DataSource = dr;
control.DataBind();
Any help appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I forgot the stack trace:
DataBinder.Eval: 'Finisar.SQLite.SQLiteDataReader' does not contain a property with the name ReportDisplayName.
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.Web.HttpException: DataBinder.Eval: 'Finisar.SQLite.SQLiteDataReader' does not contain a property with the name ReportDisplayName.
Source Error:
Line 62: control.DataValueField = idFld;
Line 63: control.DataSource = dr;
Line 64: control.DataBind();
Line 65: }
Line 66: finally
I am attemting to convert my asp.NET web application to use SQLite instead of Access. It connects just fine, but when I try to do the call to databind() on the web control I get the exception "System.Web.HttpException:DataBinder.Eval: 'Finisar.SQLite.SQLiteDataReader' does not contain a property with the name ReportDisplayName". I looked in at the datareader in the debugger and the field was present in the list of mFieldNames, along with the other column read. It all looks fine, the data is there.
here is the code
string sqlText = "SELECT " + nameFld+","+ idFld+" FROM ["+table+"]";
dr = GetDr( sqlText );
if(control.DataTextField != nameFld)
control.DataTextField = nameFld;
if(control.DataValueField != idFld)
control.DataValueField = idFld;
control.DataSource = dr;
control.DataBind();
Any help appreciated.
I forgot the stack trace:
DataBinder.Eval: 'Finisar.SQLite.SQLiteDataReader' does not contain a property with the name ReportDisplayName.
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.Web.HttpException: DataBinder.Eval: 'Finisar.SQLite.SQLiteDataReader' does not contain a property with the name ReportDisplayName.
Source Error:
Line 62: control.DataValueField = idFld;
Line 63: control.DataSource = dr;
Line 64: control.DataBind();
Line 65: }
Line 66: finally
Source File: c:\inetpub\wwwroot\bugtracks\dbaccess.cs Line: 64
Stack Trace:
[HttpException (0x80004005): DataBinder.Eval: 'Finisar.SQLite.SQLiteDataReader' does not contain a property with the name ReportDisplayName.]
System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName)
System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName, String format)
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e)
System.Web.UI.Control.DataBind()
BugTracks.DBAccess.PopulateListControl(ListControl control, String nameFld, String idFld, String table, Int32 defaultVal) in c:\inetpub\wwwroot\bugtracks\dbaccess.cs:64
BugTracks.RunReport.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\bugtracks\runreport.aspx.cs:37
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
It's a bug need to be fixed.
Mic,
Do you want to create a bug for this and take it on?
Robert,
Well, I'll do it.
Mic