executescalar *resolved*

[demoti]

sub Opslaan_Click (s as object , e as eventargs)
	dim CON as odbcconnection
	dim CMD as odbccommand
	dim DTR as odbcdatareader
	dim STR_INSERT as string
	dim ID_type as string			
			
	CON = new odbcconnection("DSN=STOCK")
			
	CMD = new odbcCommand("SELECT type_id FROM  types WHERE type_type = @type", CON)
	CMD.parameters.add ("@type", droptype.selecteditem.text)
			
	CON.open
	ID_type = CMD.executescalar

i get the error:

System.Data.Odbc.OdbcException: ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

with stack:

[OdbcException: ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.]
System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode) +32
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +1189
System.Data.Odbc.OdbcCommand.ExecuteScalar() +203
ASP.WebForm1_aspx.Opslaan_Click(Object s, EventArgs e) in C:\Inetpub\wwwroot\Stock\webform1.aspx:66
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277

i don't know what's causing the error on executescalar, and since i'm not sure how to read the stack i could use some tips here...

thanks,