Query problem in XSD in C#
Posted on 2012-09-22
Hey guys another problem.
The following code in a table adapter:
SELECT MemberID, FirstName, Middle, LastName, RoleID, MemberStatusID, GoesByName, FamilyCode, WorkStatusID, EmployerID, UseFamilyAddress,
Address, Address2, City, State, ZipCode, HomePhone, HomeFaxPhone, HomeCellPhone, HomeEMail, WorkPhone, WorkFaxPhone, WorkCellPhone,
WorkEMail, MailLabelLine1, MailLabelLine2, OccupationID, Sex, Student, Retired, MemberShipDate, Anniversary, Birthday, BaptizedDate,
MaritalStatus, BloodType, ProjectedGraduationDate, InvolvementFormDate, Notes, LastUpdate
WHERE (FirstName LIKE @fname) ORDER BY LastName
gives errors of: Error in where clause near '@'
Error in where clause near 'ORDER'
I have the exact same type of query in another program that uses the same WHERE clause and it works perfectly.
Any help would be appreciated!!