c# - Add values to DropDownList that's not represented in the db and still get SelectedValue asp.net -
i have couple of dropdownlists
in gridview
customer table binds selected value db.
i noticed if have 1 customer , edit customers gender it's not possible because populate dropdownlists
select distinct gender customer , first customer either herr or frau , can choose value.
i thinking solve problem using union select select gender ( select gender = 'herr' union select gender = 'frau' )as gender
bring both alternatives error message 'dropdownlist1'** has selectedvalue invalid because not exist in list of items**
so question how can add alternatives dropdownlists
that's not presented in db , still bind selectedvalue
?
<edititemtemplate> <asp:dropdownlist id="dropdownlist3" runat="server" datasourceid="sqldatasource1" datatextfield="gender" datavaluefield="gender" selectedvalue='<%# bind("gender") %>'> </asp:dropdownlist> <asp:sqldatasource id="sqldatasource1" runat="server" connectionstring="<%$ connectionstrings:eventconnectionstring %>" selectcommand="select distinct [gender] [customer]"></asp:sqldatasource> </edititemtemplate> <itemtemplate> <asp:label id="label2" runat="server" text='<%# bind("gender") %>'></asp:label> </itemtemplate>
thanks answers, need change in code behind make work?
here code behind.
protected void page_load(object sender, eventargs e) { } protected void lbinsert_click(object sender, eventargs e) { event.insertparameters["gender"].defaultvalue = ((dropdownlist)gridview1.footerrow.findcontrol("ddlgender")).selectedvalue; event.insertparameters["lastname"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txtlastname")).text; event.insertparameters["firstname"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txtfirstname")).text; event.insertparameters["street"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txtstreet")).text; event.insertparameters["housenr"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txthousenr")).text; event.insertparameters["zip"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txtzip")).text; event.insertparameters["city"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txtcity")).text; event.insertparameters["phone"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txtphone")).text; event.insertparameters["email"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txtemail")).text; event.insertparameters["company"].defaultvalue = ((textbox)gridview1.footerrow.findcontrol("txtcompany")).text; event.insertparameters["active"].defaultvalue = ((dropdownlist)gridview1.footerrow.findcontrol("ddlactive")).selectedvalue; event.insert(); }