send data from drop down list to data base
ba salam
man drop down list ro be in sorat sakhtam:
<asp:dropdownlist id="mydropdown" class="dropbox" runat="server"><asp:listitem text=" -- select -- " value=""></asp:listitem>
<asp:listitem text="Text 1" value="1" />
<asp:listitem text="Text 2" value="2" />
<asp:listitem text="Text 3" value="3"/></asp:dropdownlist>
va ye etesal be sql server dorost kardam:
sub insertdata(sender as object,e as eventargs)
dim strconnection as string="server=(local);database=Test;integ rated security=true;"
dim objconnection as new sqlconnection(strconnection)
dim strsql as string="insert into Register(Name,Family,Tel,email,Password,Confir mpassword)" & _
"values (@Name,@Family,@Tel,@email,@Password,@Confirmp assword);"
dim objcommand as new sqlcommand(strsql,objconnection)
objcommand.parameters.add("@name",sqldbtype.nv archar)
objcommand.parameters.add("@Family",sqldbtype. nvarchar)
objcommand.parameters.add("@Tel",sqldbtype.nva rchar)
objcommand.parameters.add("@email",sqldbtype.n varchar)
objcommand.parameters.add("@Password",sqldbtyp e.nvarchar)
objcommand.parameters.add("@Confirmpassword",s qldbtype.nvarchar)
objcommand.parameters("@name").value=txtna me.text
objcommand.parameters("@Family").value=txt family.text
objcommand.parameters("@Tel").value=mydrop down.text
objcommand.parameters("@email").value=txte mail.text
objcommand.parameters("@Password").value=t xtpassword.text
objcommand.parameters("@Confirmpassword"). value=txtConfirm.text
objconnection.open()
objcommand.executenonquery()
objconnection.close()
end sub
ama error mide:
objcommand.parameters("@Tel").value=mydrop down.text
Compiler Error Message: BC30456: 'text' is not a member of 'System.Web.UI.WebControls.DropDownList'
thank :flower:
