Hi. I've been in numerous forums and I cannot seem to find the answer I need.
I am populating a datatable from a recordset using a data adapter. From there, I need to add a new column to the datatable that concatenates two strings together. This is working just fine. But when I try to bind the datatable to a DropDownList control, it won't let me do that. I end up with an HTTPException error that states: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'sDisplayName + sTerritoryNumber + ' - ' + sTerritoryName'.
I've seen an example of what I'm trying to do in a book, yet it's not working for me. Changing the query in the database isn't really an option, either, as other things use this and it's way more hassle than it's worth. I know I can always do a FOR/NEXT to get the DropDownList populated, but I'd rather not go that route.
I can also see that the column I created ...
Go to the complete details ...