sending asp:dropdownlist value with json.stringify
Guys ı have a asp:DropDownList inside a form.What I want to do is get the selected value of ddl and send this value to webmethod via $.ajax method with using JSON.stringify. And save this value to my database.How can ı do this?
related code are below:
-
<asp:TableCell>
<%-- <asp:TextBox runat="server" ID="txt4"></asp:TextBox>--%>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem Value="Men">Men</asp:ListItem>
<asp:ListItem Value="Women">Women</asp:ListItem>
</asp:DropDownList>
</asp:TableCell>
-
<script type="text/javascript">
$(document).ready(function () {
$("#gonder").click(function () {
var ddl = $('#<%=DropDownList1.ClientID%>');
$.ajax({
type: "post",
url: "Ekle.aspx/func",
contentType: "application/json;charset:utf-8",
data: JSON.stringify({
Id: $("#txt1").val(), Name: $("#txt2").val(),
Surname: $("#txt3").val(), Sex: ddl,
Email: $("#txt5").val(),
City: $("#txt6").val(), Age: $("#txt7").val()
}),
dataType: "json",
success: onSuccess,
error: function (xhr, status, error) {
var err = eval("(" + xhr.responseText + ")");
alert(err.Message);
}
});
});
}
</script>
codebehind is:
- [System.Web.Services.WebMethod]
- public static void func(string Id, string Name, string Surname, string Sex, string Email, string City, string Age)
- {
-
- string text = "Data Source=HARUNYILMAZ; Initial Catalog=Ogrenci; Integrated Security=true";
- string commandText = "insert into Student(Id,Name,Surname,Sex,Email,City,Age) values(@val1,@val2,@val3,@val4,@val5,@val6,@val7)";
-
- using (SqlConnection connection = new SqlConnection(text))
- {
-
- using (SqlCommand command = new SqlCommand())
- {
-
- command.Connection = connection;
- command.CommandText = commandText;
- command.Parameters.AddWithValue("@val1", Int32.Parse(Id));
- command.Parameters.AddWithValue("@val2", Name);
- command.Parameters.AddWithValue("@val3", Surname);
- command.Parameters.AddWithValue("@val4", Sex);
- command.Parameters.AddWithValue("@val5", Email);
- command.Parameters.AddWithValue("@val6", City);
- command.Parameters.AddWithValue("@val7", Int32.Parse(Age));
- try
- {
- connection.Open();
- command.ExecuteNonQuery();
- }
- catch (SqlException e)
- {
- }
- }
- }
- }