bind dropdown field in GridView EditItemTemplat e?

[Dabbler]

I have two tables I'm editing in a Gridview. The VANS table contains a key to
the other LESSOR table. I would like to use a dropdown list to select the
LessorId value while displaying the Lessor table's "Company" field as text.
When I commit the edit I get error:Must declare the scalar variable
"@LessorId" .

Also as a bonus question ;) I don't know how to set the selectedindex value
in the dropdown list based on the LessorId value in the Vans table.

Any ideas would be appreciated!

Thanks.

Here's my templatefield:
<asp:TemplateFi eld HeaderText="Com pany" >
<ItemTemplate >
<asp:literal ID="Literal1" runat="server" Text='<%# Eval("Company") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId">
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>

Gridview's SqlDataSource:
<asp:SqlDataSou rce ID="sdsVans" runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT v.VanNo, v.LessorId, v.Status, v.Active,
l.Company, l.Account FROM dbo.Van v join dbo.Lessors l ON
v.LessorId=l.Le ssorId order by VanNo"
UpdateCommand=" Update dbo.Vans set VanNo=@VanNo, LessorId=@Lesso rId,
Status=@Status, Active=@Active where LessorId=@Lesso rId" >
</asp:SqlDataSour ce>

DropDownList's SqlDataSource:
<asp:SqlDataSou rce ID="sdsLessors " runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT LessorId, Company, Account FROM dbo.Lessors
order by Company">
</asp:SqlDataSour ce>

[Dabbler]

Super Green! Thanks!

"Phillip Williams" wrote:

The GridView will pass the LessorID as a parameter (in the NewValues
collection) if you create a 2-way databind on the dropdownlist:

<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId"
SelectedValue=' <%# Bind("LessorID" ) %>'>
</asp:DropDownLis t>

In addition, for good programming style, you should define an
<UpdateParamete rs> collection within the markup of the SqlDatasource that
updates the GridView.

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I have two tables I'm editing in a Gridview. The VANS table contains a key to
the other LESSOR table. I would like to use a dropdown list to select the
LessorId value while displaying the Lessor table's "Company" field as text.
When I commit the edit I get error:Must declare the scalar variable
"@LessorId" .

Also as a bonus question ;) I don't know how to set the selectedindex value
in the dropdown list based on the LessorId value in the Vans table.

Any ideas would be appreciated!

Thanks.

Here's my templatefield:
<asp:TemplateFi eld HeaderText="Com pany" >
<ItemTemplate >
<asp:literal ID="Literal1" runat="server" Text='<%# Eval("Company") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId">
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>

Gridview's SqlDataSource:
<asp:SqlDataSou rce ID="sdsVans" runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT v.VanNo, v.LessorId, v.Status, v.Active,
l.Company, l.Account FROM dbo.Van v join dbo.Lessors l ON
v.LessorId=l.Le ssorId order by VanNo"
UpdateCommand=" Update dbo.Vans set VanNo=@VanNo, LessorId=@Lesso rId,
Status=@Status, Active=@Active where LessorId=@Lesso rId" >
</asp:SqlDataSour ce>

DropDownList's SqlDataSource:
<asp:SqlDataSou rce ID="sdsLessors " runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT LessorId, Company, Account FROM dbo.Lessors
order by Company">
</asp:SqlDataSour ce>

[Dabbler]

You solution worked but in an effort to practice "good programming" I tried
to add InsertParameter s. I'm a little puzzled here.. I tried creating
InsertParameter for my InsertCommand for the drop down list as in:
InsertCommand=" INSERT INTO dbo.Vans(... VendorCode) VALUES (... @VendorCode)">

<InsertParamete rs>
<asp:ControlPar ameter ControlID="Vend orsDropDownList " Name="VendorCod e"
PropertyName="S electedValue" />
</InsertParameter s>
but when I try and insert a row I get an error:
cannot find control "VendorsDropDow nList" in controlparamete r "VendorCode "
Just would like to understand this binding better.

Thanks for listening ;)

"Phillip Williams" wrote:

The GridView will pass the LessorID as a parameter (in the NewValues
collection) if you create a 2-way databind on the dropdownlist:

<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId"
SelectedValue=' <%# Bind("LessorID" ) %>'>
</asp:DropDownLis t>

In addition, for good programming style, you should define an
<UpdateParamete rs> collection within the markup of the SqlDatasource that
updates the GridView.

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I have two tables I'm editing in a Gridview. The VANS table contains a key to
the other LESSOR table. I would like to use a dropdown list to select the
LessorId value while displaying the Lessor table's "Company" field as text.
When I commit the edit I get error:Must declare the scalar variable
"@LessorId" .

Also as a bonus question ;) I don't know how to set the selectedindex value
in the dropdown list based on the LessorId value in the Vans table.

Any ideas would be appreciated!

Thanks.

Here's my templatefield:
<asp:TemplateFi eld HeaderText="Com pany" >
<ItemTemplate >
<asp:literal ID="Literal1" runat="server" Text='<%# Eval("Company") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId">
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>

Gridview's SqlDataSource:
<asp:SqlDataSou rce ID="sdsVans" runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT v.VanNo, v.LessorId, v.Status, v.Active,
l.Company, l.Account FROM dbo.Van v join dbo.Lessors l ON
v.LessorId=l.Le ssorId order by VanNo"
UpdateCommand=" Update dbo.Vans set VanNo=@VanNo, LessorId=@Lesso rId,
Status=@Status, Active=@Active where LessorId=@Lesso rId" >
</asp:SqlDataSour ce>

DropDownList's SqlDataSource:
<asp:SqlDataSou rce ID="sdsLessors " runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT LessorId, Company, Account FROM dbo.Lessors
order by Company">
</asp:SqlDataSour ce>

[Phillip Williams]

What is the VendorsDropDown List? How are you using it? In your earlier
question you only explained a dropdownlist named ddlCompany?
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

You solution worked but in an effort to practice "good programming" I tried
to add InsertParameter s. I'm a little puzzled here.. I tried creating
InsertParameter for my InsertCommand for the drop down list as in:
InsertCommand=" INSERT INTO dbo.Vans(... VendorCode) VALUES (... @VendorCode)">

<InsertParamete rs>
<asp:ControlPar ameter ControlID="Vend orsDropDownList " Name="VendorCod e"
PropertyName="S electedValue" />
</InsertParameter s>
but when I try and insert a row I get an error:
cannot find control "VendorsDropDow nList" in controlparamete r "VendorCode "
Just would like to understand this binding better.

Thanks for listening ;)

"Phillip Williams" wrote:

The GridView will pass the LessorID as a parameter (in the NewValues
collection) if you create a 2-way databind on the dropdownlist:

<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId"
SelectedValue=' <%# Bind("LessorID" ) %>'>
</asp:DropDownLis t>

In addition, for good programming style, you should define an
<UpdateParamete rs> collection within the markup of the SqlDatasource that
updates the GridView.

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I have two tables I'm editing in a Gridview. The VANS table contains a key to
the other LESSOR table. I would like to use a dropdown list to select the
LessorId value while displaying the Lessor table's "Company" field as text.
When I commit the edit I get error:Must declare the scalar variable
"@LessorId" .

Also as a bonus question ;) I don't know how to set the selectedindex value
in the dropdown list based on the LessorId value in the Vans table.

Any ideas would be appreciated!

Thanks.

Here's my templatefield:
<asp:TemplateFi eld HeaderText="Com pany" >
<ItemTemplate >
<asp:literal ID="Literal1" runat="server" Text='<%# Eval("Company") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId">
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>

Gridview's SqlDataSource:
<asp:SqlDataSou rce ID="sdsVans" runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT v.VanNo, v.LessorId, v.Status, v.Active,
l.Company, l.Account FROM dbo.Van v join dbo.Lessors l ON
v.LessorId=l.Le ssorId order by VanNo"
UpdateCommand=" Update dbo.Vans set VanNo=@VanNo, LessorId=@Lesso rId,
Status=@Status, Active=@Active where LessorId=@Lesso rId" >
</asp:SqlDataSour ce>

DropDownList's SqlDataSource:
<asp:SqlDataSou rce ID="sdsLessors " runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT LessorId, Company, Account FROM dbo.Lessors
order by Company">
</asp:SqlDataSour ce>

[Phillip Williams]

If you still have not solved this issue, review this article to an indepth
explanation of how the datasource creates paramters for databound fields:
http://msdn2.microsoft.com/en-us/lib...51(VS.80).aspx
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

You solution worked but in an effort to practice "good programming" I tried
to add InsertParameter s. I'm a little puzzled here.. I tried creating
InsertParameter for my InsertCommand for the drop down list as in:
InsertCommand=" INSERT INTO dbo.Vans(... VendorCode) VALUES (... @VendorCode)">

<InsertParamete rs>
<asp:ControlPar ameter ControlID="Vend orsDropDownList " Name="VendorCod e"
PropertyName="S electedValue" />
</InsertParameter s>
but when I try and insert a row I get an error:
cannot find control "VendorsDropDow nList" in controlparamete r "VendorCode "
Just would like to understand this binding better.

Thanks for listening ;)

"Phillip Williams" wrote:

The GridView will pass the LessorID as a parameter (in the NewValues
collection) if you create a 2-way databind on the dropdownlist:

<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId"
SelectedValue=' <%# Bind("LessorID" ) %>'>
</asp:DropDownLis t>

In addition, for good programming style, you should define an
<UpdateParamete rs> collection within the markup of the SqlDatasource that
updates the GridView.

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I have two tables I'm editing in a Gridview. The VANS table contains a key to
the other LESSOR table. I would like to use a dropdown list to select the
LessorId value while displaying the Lessor table's "Company" field as text.
When I commit the edit I get error:Must declare the scalar variable
"@LessorId" .

Also as a bonus question ;) I don't know how to set the selectedindex value
in the dropdown list based on the LessorId value in the Vans table.

Any ideas would be appreciated!

Thanks.

Here's my templatefield:
<asp:TemplateFi eld HeaderText="Com pany" >
<ItemTemplate >
<asp:literal ID="Literal1" runat="server" Text='<%# Eval("Company") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st ID="ddlCompany " runat="server"
DataSourceID="s dsLessors" DataTextField=" Company" DataValueField= "LessorId">
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>

Gridview's SqlDataSource:
<asp:SqlDataSou rce ID="sdsVans" runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT v.VanNo, v.LessorId, v.Status, v.Active,
l.Company, l.Account FROM dbo.Van v join dbo.Lessors l ON
v.LessorId=l.Le ssorId order by VanNo"
UpdateCommand=" Update dbo.Vans set VanNo=@VanNo, LessorId=@Lesso rId,
Status=@Status, Active=@Active where LessorId=@Lesso rId" >
</asp:SqlDataSour ce>

DropDownList's SqlDataSource:
<asp:SqlDataSou rce ID="sdsLessors " runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT LessorId, Company, Account FROM dbo.Lessors
order by Company">
</asp:SqlDataSour ce>