tags:

views:

390

answers:

1
Q: 

Problem with ASP:DataList control Databinding to SQL DataSource

I have a DataList bound to a SQL DataSource on my website. The DataSource has a view populating data to the control. I recently edited the View to contain a new column of data to use in my DataList, however when I go to reference it in the DataList I get a

'System.Data.DataRowView' does not contain a property with the name 'promo_timezone'.

error message. I have checked the column names for accuracy and have ran the View in Management Studio to confirm all my columns are accounted for. I am wondering if this is a bug of some sort, I am using SQL 2008 and .NET 3.5.

Any help with this issue would be appreciated.

A: 

Can you post your datalist and the SQL from the view so we can see if there are typos etc?

twlichty  2009-06-30 14:28:39
Found the issue yesterday. I had a SQLDataSource on the page which had all the columns from the view, however I also had a conditional query getting loaded from the code behind based on the count of the "coming soon" list. ANYONE that is getting the error message in my post, there is a missing or mistyped column in your datasource, make sure to check all possible queries to confirm all columns are getting returned that are needed in the control you are databinding to. Thanks for your Answer twlichty.
Akornmeier  2009-07-02 12:13:37

related questions

Is it better to create Model classes, or just stick with generic database utility class?
What are effective options for embedding video in an ASP.NET web site?
Visual Studio 2008 debugger already attached work-around
Tracking state using ASP.NET AJAX / ICallbackEventHandler
ASP.NET Display SVN Revision Number
ASP.NET URL Rewriting
How can I change the background of a masterpage from the code behind of a content page?
Easy way to AJAX WebControls
How do I define custom web.config sections with potential child elements and attributes for the properties?
ASP.NET MVC "CRUD" Database Sample
Are Multiple DataContext classes ever appropriate?
How to RedirectToAction in ASP.NET MVC without losing request data
Triple Quotes? How do I delimit a databound Javascript string parameter in ASP.NET?
ASP.NET built in user profile, Vs old stile user class/tables
What's a good book for learning ASP?
Bandwith throttling in IIS 6 by IP Address
ASP .Net Custom Client-Side Validation
How to get the value of built, encoded ViewState?
Decent, simple, GIS/mapping component for ASP.NET?
Checklist for IIS 6/ASP.NET Windows Authentication?
How to write to Web.Config in Medium Trust ?
ASP.NET, Visual Studio and Subversion - how to integrate?
Floating Point Number parsing: Is there a Catch All algorithm?
How do I sync the SVN revision number with my ASP.NET web site?
ASP.NET Site Maps