Hey there,
The problem is in your Stored Procedure and this line:
mbDefaultRoute.DataTextField = "AreaName";
Your Stored Procedure is not returning any column with name
AreaName
because in your Select statement you are concatenating
areaname
with
routename
:
area.areaname + ' / ' + routeinfo.routename
which probably returns value but without a column name. Change the Select statement to this:
select routeinfo.routeid AS RouteID, area.areaname + ' / ' + routeinfo.routename AS AreaName from
routeinfo inner join area
on routeinfo.areaid = area.areaid
It should work for you.
Do let me know if it does.
Azee...