Parameterized Query expects parameter @Company, which was not supplied.

[Maneesh Agarwal]

I am trying to pass a parameter to dynamically populate drop down list. I am not able to pass the parameter from my .aspx file. Here is the grid view and related ObjectDataSourc e. In srcLocation, the Company paramter being passed is blank or null, if I put default value (hardcoding what is expected), the page display fine when I click on edit button. But with no default value it gives above error.

<asp:GridView
id="grdCAPAs"
DataSourceID="s rcCAPAs"
DataKeyNames="C APA_Number"
AutoGenerateEdi tButton="true"
AutoGenerateDel eteButton="true "
AutoGenerateCol umns="false"
CssClass="produ cts"
GridLines="none "
Runat="server" >
<Columns>
<asp:BoundFie ld
DataField="CAPA _Number"
ReadOnly="true"
HeaderText="CAP A Number" />
<asp:TemplateFi eld HeaderText="Com pany" >
<ItemTemplate >
<%#Eval("Compan y", "{0}")%>
</ItemTemplate>

<EditItemTempla te>
<asp:DropDownLi st
ID = "ddlCompany "
DataSourceID = "srcCompany "
DataTextField=" C9_Company"
DataValueField = "C9_Company "
SelectedValue = '<%# Bind("Company", "{0}") %>'
Runat = "server"
Autopostback = "true" />

</EditItemTemplat e>
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Loc ation" >
<ItemTemplate >
<%#Eval("Locati on", "{0}")%>
</ItemTemplate>

<EditItemTempla te>
<asp:DropDownLi st
ID = "ddlLocatio n"
DataSourceID = "srcLocatio n"
DataTextField=" C9_Location"
DataValueField = "C9_Locatio n"
SelectedValue = '<%# Bind("Location" , "{0}") %>'
Runat = "server" />

</EditItemTemplat e>
</asp:TemplateFie ld>

<asp:BoundFie ld
DataField="Area "
HeaderText="Are a" />


<asp:ObjectData Source
id="srcCAPAs"
TypeName="CAPAs .BLL.MaintainCA PA"
SelectMethod="S electAll"
UpdateMethod="U pdate"
InsertMethod="I nsert"
DeleteMethod="D elete"
Runat="server" />

<asp:ObjectData Source
id = "srcCompany "
TypeName="CAPAs .BLL.MaintainCA PA"
SelectMethod="S electCompany"
Runat = "server" />

<asp:ObjectData Source
id = "srcLocatio n"
TypeName="CAPAs .BLL.MaintainCA PA"
SelectMethod="S electLocation"

Runat = "server" >
<SelectParamete rs>
<asp:ControlPar ameter ControlID="grdC APAs" Name = "Company" PropertyName ="SelectedValue " />
</SelectParameter s>
</asp:ObjectDataS ource>


Public Shared Function SelectLocation( ByVal Company As String)
Dim daLayer As DAL1 = New DAL1()
Return daLayer.SelectA llLocation(Comp any)
End Function


Public Function SelectAllLocati on(ByVal Company As String) As SqlDataReader
'Create Connection
Dim con As New SqlConnection(_ connectionStrin g)

'Create Command
Dim cmd As SqlCommand = New SqlCommand()
cmd.Connection = con
cmd.CommandText = "SELECT DISTINCT C9_LOCATION FROM CAPA_LOCATION WHERE C9_COMPANY = @Company"
'Add parameters
cmd.Parameters. AddWithValue("@ Company", Company)

'Return DataReader
con.Open()
Return cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion)
End Function

Let me know what you think