Problem with FormView and DropDownLists

[Bas Paap]

I'm having a problem with formviews and DropDownLists in ASP.NET 2.0. I'm
using a formview to insert an order into a database. Part of the order is the
customer. Currently, I have a dropdownlist bound to a datasource that simply
selects all customers from a database table. The DropDownList's Selectedvalue
is bound with the following expression:

Bind("customerI d")

This works perfectly, the id is passed to a stored procedure and the order
is insterted. However, rather than provide a list of all customers, I'd like
to provide a dropdownlist of companies. If the user selects one of the
companies, the page posts back (the lists autopostback is set to true), and
then the dropdownlist for the customers should show only the customers
related to that company.

I added a clause to the customer datasource that ensures it only selects
customers related to the currently selected company. (It uses a control
parameter that refers to the company dropdownlist's selected value.) However,
when I run the page, and try to select a company, Visual studio gives me the
following message:

"There is no source code available for the current location." Followed by an
"OK" and a "Show Disassembly" button. When I press OK, I get an
"InvalidOperati onException was unhandled by user code" message, informing me
that "Databindin g methods such as Eval(), XPath(), and Bind() can only be
used in the context of a databound control."

I have no idea where I'm going wrong. Does anybody have a clue?

Here's the code from the InsertItemTempl ate:

<asp:DropDownLi st ID="CompanyDrop DownList" runat="server"
AutoPostBack="T rue" DataSourceID="C ompanySqlDataSo urce"
DataTextField=" companyName" DataValueField= "companyId" >
</asp:DropDownLis t>
<asp:SqlDataSou rce ID="CompanySqlD ataSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ordersystemC onnectionString %>"
SelectCommand=" SELECT [companyId], [companyName] FROM
[company]">
</asp:SqlDataSour ce>

<asp:DropDownLi st ID="CustomerDro pDownList" runat="server"
DataSourceID="C ustomerSqlDataS ource"
DataTextField=" lastName"
DataValueField= "personId" SelectedValue=' <%# Bind("customerI d") %>' >
</asp:DropDownLis t>
<asp:SqlDataSou rce ID="CustomerSql DataSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ordersystemC onnectionString %>"
SelectCommand=" SELECT [lastName],
[personId], [companyId] FROM [person] WHERE ([companyId] = @companyId)">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Comp anyDropDownList "
Name="companyId " PropertyName="S electedValue" />
</SelectParameter s>
</asp:SqlDataSour ce>


This is the InsertParameter for the FormView's datasource:

<InsertParamete rs>
<asp:Paramete r Name="customerI d" Type="Int32" />
<InsertParamete rs>

[Phillip Williams]

http://www.webswapp.com/codesamples/...s/default.aspx
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Bas Paap" wrote:

I'm having a problem with formviews and DropDownLists in ASP.NET 2.0. I'm
using a formview to insert an order into a database. Part of the order is the
customer. Currently, I have a dropdownlist bound to a datasource that simply
selects all customers from a database table. The DropDownList's Selectedvalue
is bound with the following expression:

Bind("customerI d")

This works perfectly, the id is passed to a stored procedure and the order
is insterted. However, rather than provide a list of all customers, I'd like
to provide a dropdownlist of companies. If the user selects one of the
companies, the page posts back (the lists autopostback is set to true), and
then the dropdownlist for the customers should show only the customers
related to that company.

I added a clause to the customer datasource that ensures it only selects
customers related to the currently selected company. (It uses a control
parameter that refers to the company dropdownlist's selected value.) However,
when I run the page, and try to select a company, Visual studio gives me the
following message:

"There is no source code available for the current location." Followed by an
"OK" and a "Show Disassembly" button. When I press OK, I get an
"InvalidOperati onException was unhandled by user code" message, informing me
that "Databindin g methods such as Eval(), XPath(), and Bind() can only be
used in the context of a databound control."

I have no idea where I'm going wrong. Does anybody have a clue?

Here's the code from the InsertItemTempl ate:

<asp:DropDownLi st ID="CompanyDrop DownList" runat="server"
AutoPostBack="T rue" DataSourceID="C ompanySqlDataSo urce"
DataTextField=" companyName" DataValueField= "companyId" >
</asp:DropDownLis t>
<asp:SqlDataSou rce ID="CompanySqlD ataSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ordersystemC onnectionString %>"
SelectCommand=" SELECT [companyId], [companyName] FROM
[company]">
</asp:SqlDataSour ce>

<asp:DropDownLi st ID="CustomerDro pDownList" runat="server"
DataSourceID="C ustomerSqlDataS ource"
DataTextField=" lastName"
DataValueField= "personId" SelectedValue=' <%# Bind("customerI d") %>' >
</asp:DropDownLis t>
<asp:SqlDataSou rce ID="CustomerSql DataSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ordersystemC onnectionString %>"
SelectCommand=" SELECT [lastName],
[personId], [companyId] FROM [person] WHERE ([companyId] = @companyId)">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Comp anyDropDownList "
Name="companyId " PropertyName="S electedValue" />
</SelectParameter s>
</asp:SqlDataSour ce>


This is the InsertParameter for the FormView's datasource:

<InsertParamete rs>
<asp:Paramete r Name="customerI d" Type="Int32" />
<InsertParamete rs>

[Bas Paap]

Excellent! That worked perfectly. Such a simple solution, too.

I never would've guessed that the formview wouldn't be re-bound, but
automatically recreated from the ViewState. Wouldn't it be possible to force
the formview to rebind rather than have it recreated from the ViewState? That
way you could, (I'm just guessing here), leave the dropdownlist's 2-way
databinding intact and automated.

Anyway, this works perfectly. Many thanks, you just saved my vacation!

"Phillip Williams" wrote:

http://www.webswapp.com/codesamples/...s/default.aspx
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Bas Paap" wrote:

I'm having a problem with formviews and DropDownLists in ASP.NET 2.0. I'm
using a formview to insert an order into a database. Part of the order is the
customer. Currently, I have a dropdownlist bound to a datasource that simply
selects all customers from a database table. The DropDownList's Selectedvalue
is bound with the following expression:

Bind("customerI d")

This works perfectly, the id is passed to a stored procedure and the order
is insterted. However, rather than provide a list of all customers, I'd like
to provide a dropdownlist of companies. If the user selects one of the
companies, the page posts back (the lists autopostback is set to true), and
then the dropdownlist for the customers should show only the customers
related to that company.

I added a clause to the customer datasource that ensures it only selects
customers related to the currently selected company. (It uses a control
parameter that refers to the company dropdownlist's selected value.) However,
when I run the page, and try to select a company, Visual studio gives me the
following message:

"There is no source code available for the current location." Followed by an
"OK" and a "Show Disassembly" button. When I press OK, I get an
"InvalidOperati onException was unhandled by user code" message, informing me
that "Databindin g methods such as Eval(), XPath(), and Bind() can only be
used in the context of a databound control."

I have no idea where I'm going wrong. Does anybody have a clue?

Here's the code from the InsertItemTempl ate:

<asp:DropDownLi st ID="CompanyDrop DownList" runat="server"
AutoPostBack="T rue" DataSourceID="C ompanySqlDataSo urce"
DataTextField=" companyName" DataValueField= "companyId" >
</asp:DropDownLis t>
<asp:SqlDataSou rce ID="CompanySqlD ataSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ordersystemC onnectionString %>"
SelectCommand=" SELECT [companyId], [companyName] FROM
[company]">
</asp:SqlDataSour ce>

<asp:DropDownLi st ID="CustomerDro pDownList" runat="server"
DataSourceID="C ustomerSqlDataS ource"
DataTextField=" lastName"
DataValueField= "personId" SelectedValue=' <%# Bind("customerI d") %>' >
</asp:DropDownLis t>
<asp:SqlDataSou rce ID="CustomerSql DataSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ordersystemC onnectionString %>"
SelectCommand=" SELECT [lastName],
[personId], [companyId] FROM [person] WHERE ([companyId] = @companyId)">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Comp anyDropDownList "
Name="companyId " PropertyName="S electedValue" />
</SelectParameter s>
</asp:SqlDataSour ce>


This is the InsertParameter for the FormView's datasource:

<InsertParamete rs>
<asp:Paramete r Name="customerI d" Type="Int32" />
<InsertParamete rs>

[Phillip Williams]

If you re-bind the FormView then you would reset the selection for the
customers dropdownlist that was supposed to set the next list's selection.

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

Excellent! That worked perfectly. Such a simple solution, too.

I never would've guessed that the formview wouldn't be re-bound, but
automatically recreated from the ViewState. Wouldn't it be possible to force
the formview to rebind rather than have it recreated from the ViewState? That
way you could, (I'm just guessing here), leave the dropdownlist's 2-way
databinding intact and automated.

Anyway, this works perfectly. Many thanks, you just saved my vacation!

"Phillip Williams" wrote:

http://www.webswapp.com/codesamples/...s/default.aspx
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Bas Paap" wrote:

I'm having a problem with formviews and DropDownLists in ASP.NET 2.0. I'm
using a formview to insert an order into a database. Part of the order is the
customer. Currently, I have a dropdownlist bound to a datasource that simply
selects all customers from a database table. The DropDownList's Selectedvalue
is bound with the following expression:

Bind("customerI d")

This works perfectly, the id is passed to a stored procedure and the order
is insterted. However, rather than provide a list of all customers, I'd like
to provide a dropdownlist of companies. If the user selects one of the
companies, the page posts back (the lists autopostback is set to true), and
then the dropdownlist for the customers should show only the customers
related to that company.

I added a clause to the customer datasource that ensures it only selects
customers related to the currently selected company. (It uses a control
parameter that refers to the company dropdownlist's selected value.) However,
when I run the page, and try to select a company, Visual studio gives me the
following message:

"There is no source code available for the current location." Followed by an
"OK" and a "Show Disassembly" button. When I press OK, I get an
"InvalidOperati onException was unhandled by user code" message, informing me
that "Databindin g methods such as Eval(), XPath(), and Bind() can only be
used in the context of a databound control."

I have no idea where I'm going wrong. Does anybody have a clue?

Here's the code from the InsertItemTempl ate:

<asp:DropDownLi st ID="CompanyDrop DownList" runat="server"
AutoPostBack="T rue" DataSourceID="C ompanySqlDataSo urce"
DataTextField=" companyName" DataValueField= "companyId" >
</asp:DropDownLis t>
<asp:SqlDataSou rce ID="CompanySqlD ataSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ordersystemC onnectionString %>"
SelectCommand=" SELECT [companyId], [companyName] FROM
[company]">
</asp:SqlDataSour ce>

<asp:DropDownLi st ID="CustomerDro pDownList" runat="server"
DataSourceID="C ustomerSqlDataS ource"
DataTextField=" lastName"
DataValueField= "personId" SelectedValue=' <%# Bind("customerI d") %>' >
</asp:DropDownLis t>
<asp:SqlDataSou rce ID="CustomerSql DataSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ordersystemC onnectionString %>"
SelectCommand=" SELECT [lastName],
[personId], [companyId] FROM [person] WHERE ([companyId] = @companyId)">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Comp anyDropDownList "
Name="companyId " PropertyName="S electedValue" />
</SelectParameter s>
</asp:SqlDataSour ce>


This is the InsertParameter for the FormView's datasource:

<InsertParamete rs>
<asp:Paramete r Name="customerI d" Type="Int32" />
<InsertParamete rs>