Hello.

I am DESPERATELY trying to assign a variable a dynamic value from a database record. I have pulled the record using a binding called CompanyList (it pulls company data) from a table called Company. The code to show this result is this:
<%# CompanyList.FieldValue("company_industry", Container%> (the value by the way is dining)

I want to take that value and assign it to a variable, called test, so I set my code to this:

dim test As string
test = <%# CompanyList.FieldValue("company_industry", Container)%>

the error I get is: Compiler Error Message: BC30201: Expression expected.


essentially, I want test="Dining"

Please help!!!!!