ASP SQL Statement Error

[dhrehor]

Here is what I am trying to run

SELECT quarter, startdate, enddate, requiredquarterhours AS quarter, startdate, enddate, requiredquarterhours
FROM quarters WHERE quarter = DropDownList2.DataValueField


I get an error stating that DropDownList2.DataValueField cannot be bound.

I have also tried DropDownList2.DataTextField and gain the same error.

Thanks

Don

 

[TipGiver]

What is the data type of 'quarter' ?
Do you want the text or the value of the selected item of the ddl?

 

[DotNetGnat]

you have to do this:

WHERE quarter = DropDownList2.SelectedItem.value

-DNG

 

[dhrehor]

quarter is a nchar(10)

 

[dhrehor]

Still get this meesage

The multi-part identifier could not be bound

Don

 

[jbenson001]

Are you actually writing this?:

SELECT quarter, startdate, enddate, requiredquarterhours AS quarter, startdate, enddate, requiredquarterhours 
FROM quarters WHERE quarter = DropDownList2.DataValueField

You need to do this:

"SELECT quarter, startdate, enddate, requiredquarterhours AS quarter, startdate, enddate, requiredquarterhours 
FROM quarters WHERE quarter = " + DropDownList2.SelectedItem.value