Asad.Safari
دوشنبه 27 مهر 1383, 16:30 عصر
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;integrated security=true;"
dim objconnection as new sqlconnection(strconnection)
dim strsql as string="insert into Register(Name,Family,Tel,email,Password,Confirmpas sword)" & _
"values (@Name,@Family,@Tel,@email,@Password,@Confirmpassw ord);"
dim objcommand as new sqlcommand(strsql,objconnection)
objcommand.parameters.add("@name",sqldbtype.nvarchar)
objcommand.parameters.add("@Family",sqldbtype.nvarchar)
objcommand.parameters.add("@Tel",sqldbtype.nvarchar)
objcommand.parameters.add("@email",sqldbtype.nvarchar)
objcommand.parameters.add("@Password",sqldbtype.nvarchar)
objcommand.parameters.add("@Confirmpassword",sqldbtype.nvarchar)
objcommand.parameters("@name").value=txtname.text
objcommand.parameters("@Family").value=txtfamily.text
objcommand.parameters("@Tel").value=mydropdown.text
objcommand.parameters("@email").value=txtemail.text
objcommand.parameters("@Password").value=txtpassword.text
objcommand.parameters("@Confirmpassword").value=txtConfirm.text
objconnection.open()
objcommand.executenonquery()
objconnection.close()
end sub
ama error mide:
objcommand.parameters("@Tel").value=mydropdown.text
Compiler Error Message: BC30456: 'text' is not a member of 'System.Web.UI.WebControls.DropDownList'
thank :flower:
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;integrated security=true;"
dim objconnection as new sqlconnection(strconnection)
dim strsql as string="insert into Register(Name,Family,Tel,email,Password,Confirmpas sword)" & _
"values (@Name,@Family,@Tel,@email,@Password,@Confirmpassw ord);"
dim objcommand as new sqlcommand(strsql,objconnection)
objcommand.parameters.add("@name",sqldbtype.nvarchar)
objcommand.parameters.add("@Family",sqldbtype.nvarchar)
objcommand.parameters.add("@Tel",sqldbtype.nvarchar)
objcommand.parameters.add("@email",sqldbtype.nvarchar)
objcommand.parameters.add("@Password",sqldbtype.nvarchar)
objcommand.parameters.add("@Confirmpassword",sqldbtype.nvarchar)
objcommand.parameters("@name").value=txtname.text
objcommand.parameters("@Family").value=txtfamily.text
objcommand.parameters("@Tel").value=mydropdown.text
objcommand.parameters("@email").value=txtemail.text
objcommand.parameters("@Password").value=txtpassword.text
objcommand.parameters("@Confirmpassword").value=txtConfirm.text
objconnection.open()
objcommand.executenonquery()
objconnection.close()
end sub
ama error mide:
objcommand.parameters("@Tel").value=mydropdown.text
Compiler Error Message: BC30456: 'text' is not a member of 'System.Web.UI.WebControls.DropDownList'
thank :flower: