Argument Not Specified For Parameter Error

I am trying to extract a value out of a cookie and then use that as a parameter to a SQL Select...Where function but I am getting the Argument not specified for parameter error. I assume the value from the cookie is not in the variable that I created but I could be wrong.





What is the proper method for populating a variable from a cookie and using that value as part of a SQL Select....Where function?





After I get a value out of the Select...Where function, I need to use the dataset results in a DropDownList as well as perform the DataBind().





here's some of the code:











Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)


if Not Page.IsPostBack then


dim Code as String


Code = Server.HtmlEncode(Request.Cookies("UCodeCookie")("Code"))


label1.Text = Code


GetPropertyCodes(Code)


ddlPropertyCode.DataBind()


end if


End Sub





Function GetPropertyCodes(ByVal Code As String) As System.Data.DataSet


Dim connectionString As String = "server='(local)'; trusted_connection=true; database='master'"


Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)





Dim queryString As String = "SELECT [Property_Details_db].[Prop_Code] FROM [Property_Details_db] WHERE ([Property_Details_db].[Code] = @Code)"


Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand


dbCommand.CommandText = queryString


dbCommand.Connection = dbConnection





Dim dbParam_code As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter


dbParam_code.ParameterName = "@Code"


dbParam_code.Value = Code


dbParam_code.DbType = System.Data.DbType.String


dbCommand.Parameters.Add(dbParam_code)





Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter


dataAdapter.SelectCommand = dbCommand


Dim dataSet As System.Data.DataSet = New System.Data.DataSet


dataAdapter.Fill(dataSet)





Return dataSet


End Function











Thanks for your help.





Chris