SPROC And VIEW Trouble

I have a SPROC that uses various VIEWs (passed into the SPROC from an ASP.NET dropdownlist), but I'm getting "Invalid Syntax near 'View name' " errors from the browser (IE) when I execute the dropdownlist.





It appears to me that it should work. The VIEWs run fine by themselves.





When I run the SPROC in Query Analyzer, I get the following error





Server: Msg 201, Level 16, State 4, Procedure Company_List_by_Filter, Line 0


Procedure 'Company_List_by_Filter' expects parameter '@Filter', which was not supplied.





I completely removed the control and rebuilt it (Using VisualStudio.NET 2003), but still have the same error.





VS builds the code without error.





Here's the code for the event handler:





private void Select_Filter_SelectedIndexChanged(object sender, System.EventArgs e)


{


SqlConnection myConnection = new SqlConnection("server=AMD;database=imSMART;Trusted_Connection=yes");


SqlDataAdapter myCommand = new SqlDataAdapter("Company_List_by_Filter", myConnection);





myCommand.SelectCommand.CommandType = CommandType.StoredProcedure;





myCommand.SelectCommand.Parameters.Add(new SqlParameter("@Filter", SqlDbType.VarChar, 150));


myCommand.SelectCommand.Parameters["@Filter"].Value = Select_Filter.SelectedValue;





//Arbitrary table name Company_List


DataSet ds = new DataSet();


myCommand.Fill(ds, "Company_List");





Select_Company.DataSource=ds.Tables["Company_List"].DefaultView;


Select_Company.DataBind();


}





Somehow the @Filter variable is not properly getting passed by the SPROC to the VIEW.





Anyone have any ideas why this is happening?





Thanks,





Paul