I am new to ASP.NET and currently having problem with dropdownlists in the DetailsView.I have this code my code behind to refresh the list for the dropdownlists in DetailsView\[code\]protected void ddlVendor_SelectedIndexChanged (object sender, EventArgs e) { DropDownList ddlVendorBB = (DropDownList)DetailsView1.FindControl("VendorBUName"); if (ddlVendorBB != null) { Response.Write("SelectChanged"); ddlVendorBB.DataBind(); } } protected void SqlDataSourceProd_Selecting (object sender, SqlDataSourceSelectingEventArgs e) { DropDownList ddlVendor = (DropDownList)DetailsView1.FindControl("VendorName"); if (ddlVendor != null) { e.Command.Parameters["@VendorID"].Value = http://stackoverflow.com/questions/12808865/ddlVendor.SelectedValue; } }\[/code\]These two dropdownlists in the DetailsView\[code\]<EditItemTemplate> <asp
ropDownList id="VendorName" datasourceid="VendorSqlDataSource" AutoPostBack="true" datatextfield="VendorName" DataValueField="VendorID" SelectedValue='http://stackoverflow.com/questions/12808865/<%# Bind("VendorID") %>' runat="server" OnSelectedIndexChanged="ddlCategory_SelectedIndexChanged" /> <asp:SqlDataSource ID="VendorSqlDataSource" ConnectionString="<%$Connectionstrings:ConnectionString%>" SelectCommand="SELECT VendorID, VendorName from MDF_Vendor" runat="server"> </asp:SqlDataSource> </EditItemTemplate> <EditItemTemplate> <aspropDownList id="VendorBUName" datasourceid="VendorBUSqlDataSource" datatextfield="VendorBUName" DataValueField="VendorBUID" SelectedValue='http://stackoverflow.com/questions/12808865/<%# Bind("VendorBUID") %>' runat="server"/> <asp:SqlDataSource ID="VendorBUSqlDataSource" runat="server" ConnectionString="<%$Connectionstrings:ConnectionString%>" selectcommand="SELECT VendorBUID, VendorBUName from MDF_VendorBU Where VendorID = @VendorID" OnSelecting="SqlDataSourceProd_Selecting"> <SelectParameters> <asp
arameter Name="VendorID" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </EditItemTemplate>\[/code\]Problem is:If I leave SelectedValue= http://stackoverflow.com/questions/12808865/there, the dropdownlists in Edit mode seletected the correct value in the items listed when I first click Edit, but when I select a new VendorName, it errors"Databining method such as Eval(), Xpath(), and Bind()... ". Now, if I removed the Selectedvalued for the dropdownlists, it will work for refreshing the VendorBUName when select a new VendorName, but NOT not selected the default VendorID when I click "Edit". It just list the VendorName list without selected the current VendorID one. Can someone please let me know what wrong in my codes? Thanks!
ropDownList id="VendorName" datasourceid="VendorSqlDataSource" AutoPostBack="true" datatextfield="VendorName" DataValueField="VendorID" SelectedValue='http://stackoverflow.com/questions/12808865/<%# Bind("VendorID") %>' runat="server" OnSelectedIndexChanged="ddlCategory_SelectedIndexChanged" /> <asp:SqlDataSource ID="VendorSqlDataSource" ConnectionString="<%$Connectionstrings:ConnectionString%>" SelectCommand="SELECT VendorID, VendorName from MDF_Vendor" runat="server"> </asp:SqlDataSource> </EditItemTemplate> <EditItemTemplate> <aspropDownList id="VendorBUName" datasourceid="VendorBUSqlDataSource" datatextfield="VendorBUName" DataValueField="VendorBUID" SelectedValue='http://stackoverflow.com/questions/12808865/<%# Bind("VendorBUID") %>' runat="server"/> <asp:SqlDataSource ID="VendorBUSqlDataSource" runat="server" ConnectionString="<%$Connectionstrings:ConnectionString%>" selectcommand="SELECT VendorBUID, VendorBUName from MDF_VendorBU Where VendorID = @VendorID" OnSelecting="SqlDataSourceProd_Selecting"> <SelectParameters> <asparameter Name="VendorID" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </EditItemTemplate>\[/code\]Problem is:If I leave SelectedValue= http://stackoverflow.com/questions/12808865/there, the dropdownlists in Edit mode seletected the correct value in the items listed when I first click Edit, but when I select a new VendorName, it errors"Databining method such as Eval(), Xpath(), and Bind()... ". Now, if I removed the Selectedvalued for the dropdownlists, it will work for refreshing the VendorBUName when select a new VendorName, but NOT not selected the default VendorID when I click "Edit". It just list the VendorName list without selected the current VendorID one. Can someone please let me know what wrong in my codes? Thanks!