Dear all,

Can anyone points out where I am doing wrong. I have it over The comRadiobuttonList example (p.113)

Problem:
When I select radiobutton of employee ex. "Davilio" in browser, I get the following error in debugger:

"The column prefix radEmployees.SelectedItem does not match with a table alias name used in query".

Other findings:
In IDE (Matrix), Design Tab: The radEmployees web control(asp:RadioButtonList) shows "Unbound".

Versions used:
                .Net Framework: 1.1
                Internet Explorer 6.0
                Database: MSDE with sp3
                Web Server: Web Matrix, version 0.6
                O/S: Windows 2000
                Database used:(SQL-Northwind, Employees DB)
                Code used: Same as in your example pp 113-114-115.

What I have already checked:
- My strSQL query: "SELECT TitleOfCourtesy, FirstName, LastName, Country, Region, City, Notes FROM Employees WHERE EmployeeID=lbxEmployees.SelectedItem.Value"
-The ID of my webcontrol is indeed: "lbxEmployees"'
-ExecuteReader() method is called after the connection is open.
-Connection syntax is seemingly good since i can display the data of Employees Table if I do not use the RadioButtonList web control.
-Data Environment of WebMatrix shows that there is a connection to Northwind DB on local.
-Connection to this database works as expected when displaying data in a datagrid (that is without eventhandler).
-Employees DB has a column "Employees ID" and a column "LastName"
Values "Davilio" en "1" are indeed in the table.

Looking forward to some coaching on this,
Christiane, The Netherlands

Hi Christiane,

You need to concatenate the value of the selected item to your SQL string. Right now, you're just passing the text lbxEmployees.SelectedItem.Value to the SQL statement.

Try this instead (all on one line):

"SELECT TitleOfCourtesy, FirstName, LastName, Country, Region, City,
  Notes FROM Employees WHERE EmployeeID = " &
  lbxEmployees.SelectedItem.Value

Is EmployeeID a number? If it's not, you probably need to surround it by quotes:

"SELECT TitleOfCourtesy, FirstName, LastName, Country, Region, City,
  Notes FROM Employees WHERE EmployeeID = '" &
  lbxEmployees.SelectedItem.Value & "'"

HtH,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Distegration by The Cure (Track 10 from the album: Disintegration) What's This?

it's better to use SqlParameters in your statement.

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.