Thanks for the replies.
I want the the text to be supplied to me. I will match this text with the value in my database and then want to create a session variable storing this value accordingly. I am using the following code.
if portalList.SelectedItem.text = objDataReader.GetString(0) then
Session("course_id") = objDataReader.GetInt32(1).toString()
However, this is not working as when i response.write my course_id variable then I always get "1" as my output value where I am changing my dropdown list values so I think something is wrong, I don't know what thought but my SQL statement is fine.
Any suggestions here.