I am new to ASP.NET. I am working with DetailsView edit mode, with dropdown lists filter and refreshing based on select from another. Let's me explain what I try to accomplish.I have this code in Detailsview:\[code\] <asp:TemplateField HeaderText="VendorName"> <ItemTemplate> <%#Eval("VendorName")%> </ItemTemplate> <InsertItemTemplate> <asp
ropDownList id="VendorName" datasourceid="VendorSqlDataSource" datatextfield="VendorName" DataValueField="VendorID" SelectedValue='http://stackoverflow.com/questions/12772117/<%# Bind("VendorID") %>' runat="server"/> </InsertItemTemplate> <EditItemTemplate> <aspropDownList id="VendorName" datasourceid="VendorSqlDataSource" datatextfield="VendorName" DataValueField="VendorID" SelectedValue='http://stackoverflow.com/questions/12772117/<%# Bind("VendorID") %>' runat="server"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Vendor BU"> <ItemTemplate> <%#Eval("VendorBUName")%> </ItemTemplate> <InsertItemTemplate> <aspropDownList id="VendorBUName" datasourceid="VendorBUSqlDataSource" datatextfield="VendorBUName" DataValueField="VendorBUID" SelectedValue='http://stackoverflow.com/questions/12772117/<%# Bind("VendorBUID") %>' runat="server"/> </InsertItemTemplate> <EditItemTemplate> <aspropDownList id="DropDownList1" datasourceid="VendorBUSqlDataSource" datatextfield="VendorBUName" DataValueField="VendorBUID" SelectedValue='http://stackoverflow.com/questions/12772117/<%# Bind("VendorBUID") %>' runat="server"/> </EditItemTemplate> </asp:TemplateField>\[/code\]And this code is displayed the dropdown list and selected the right value:\[code\]<asp:SqlDataSource ID="VendorSqlDataSource" ConnectionString="<%$Connectionstrings:ConnectionString%>"SelectCommand="SELECT VendorID, VendorName from MDF_Vendor" runat="server"/> <asp:SqlDataSource ID="VendorBUSqlDataSource" ConnectionString="<%$Connectionstrings:ConnectionString%>"SelectCommand="SELECT VendorBUID, VendorBUName from MDF_VendorBU" runat="server"/>\[/code\]This works, but what I am trying to do is filtering the list of VendorBU based on VendorID in the "DataValueField="VendorID" field. So when use click on a record in GridView, and switch to edit mode in DetailsView, it will use that current VendorID to filter that VendorBU list, then if user change VendorName (different VendorID), the VendorBU list will refilter again.I know the query would be "SELECT VendorBUID, VendorBUName from MDF_VendorBU where VendorID = @VendorID" -- The VendorID is from the DataValueField="VendorID", but I couldn't figure out how to capture that VendorID since I a new.Please help. Thank you,
ropDownList id="VendorName" datasourceid="VendorSqlDataSource" datatextfield="VendorName" DataValueField="VendorID" SelectedValue='http://stackoverflow.com/questions/12772117/<%# Bind("VendorID") %>' runat="server"/> </InsertItemTemplate> <EditItemTemplate> <aspropDownList id="VendorName" datasourceid="VendorSqlDataSource" datatextfield="VendorName" DataValueField="VendorID" SelectedValue='http://stackoverflow.com/questions/12772117/<%# Bind("VendorID") %>' runat="server"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Vendor BU"> <ItemTemplate> <%#Eval("VendorBUName")%> </ItemTemplate> <InsertItemTemplate> <aspropDownList id="VendorBUName" datasourceid="VendorBUSqlDataSource" datatextfield="VendorBUName" DataValueField="VendorBUID" SelectedValue='http://stackoverflow.com/questions/12772117/<%# Bind("VendorBUID") %>' runat="server"/> </InsertItemTemplate> <EditItemTemplate> <aspropDownList id="DropDownList1" datasourceid="VendorBUSqlDataSource" datatextfield="VendorBUName" DataValueField="VendorBUID" SelectedValue='http://stackoverflow.com/questions/12772117/<%# Bind("VendorBUID") %>' runat="server"/> </EditItemTemplate> </asp:TemplateField>\[/code\]And this code is displayed the dropdown list and selected the right value:\[code\]<asp:SqlDataSource ID="VendorSqlDataSource" ConnectionString="<%$Connectionstrings:ConnectionString%>"SelectCommand="SELECT VendorID, VendorName from MDF_Vendor" runat="server"/> <asp:SqlDataSource ID="VendorBUSqlDataSource" ConnectionString="<%$Connectionstrings:ConnectionString%>"SelectCommand="SELECT VendorBUID, VendorBUName from MDF_VendorBU" runat="server"/>\[/code\]This works, but what I am trying to do is filtering the list of VendorBU based on VendorID in the "DataValueField="VendorID" field. So when use click on a record in GridView, and switch to edit mode in DetailsView, it will use that current VendorID to filter that VendorBU list, then if user change VendorName (different VendorID), the VendorBU list will refilter again.I know the query would be "SELECT VendorBUID, VendorBUName from MDF_VendorBU where VendorID = @VendorID" -- The VendorID is from the DataValueField="VendorID", but I couldn't figure out how to capture that VendorID since I a new.Please help. Thank you,