Guest User

Untitled

a guest
Sep 17th, 2018
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.51 KB | None | 0 0
  1. insert data in database with jqueryajax
  2. [WebMethod]
  3. public static string executeinsert(string name ,string family , string username,string password , string email,string tel, string codemeli)
  4. { string constring = "data source=.;database=site;integrated security=true;";
  5.  
  6. SqlConnection con = new SqlConnection(constring);
  7. SqlCommand com = new SqlCommand("insertmember", con);
  8. com.CommandType = CommandType.StoredProcedure;
  9. com.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar, 250));
  10. com.Parameters["@username"].Value = username;
  11. com.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 150));
  12. com.Parameters["@name"].Value = name;
  13. com.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar, 50));
  14. com.Parameters["@password"].Value = password;
  15. com.Parameters.Add(new SqlParameter("@family", SqlDbType.NVarChar, 250));
  16. com.Parameters["@family"].Value = family;
  17. com.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar, 50));
  18. com.Parameters["@email"].Value = email;
  19. com.Parameters.Add(new SqlParameter("@codemeli", SqlDbType.NChar, 10));
  20. com.Parameters["@codemeli"].Value = codemeli;
  21. com.Parameters.Add(new SqlParameter("@tel", SqlDbType.NChar, 12));
  22. com.Parameters["@tel"].Value = tel;
  23. con.Open();
  24. com.ExecuteNonQuery();
  25. con.Close();
  26. return "success";
  27. }
  28.  
  29. <script type="text/javascript">
  30. $(document).ready(
  31. function () {
  32. $("#Button1").click(
  33. function () {
  34. var username, family, name, email, tel, codemeli, password;
  35. username = $('#<%=TextBox1.ClientID%>').val();
  36. name = $('#<%=TextBox2.ClientID%>').val();
  37. family = $('#<%=TextBox3.ClientID%>').val();
  38. password = $('#<%=TextBox4.ClientID%>').val();
  39. email = $('#<%=TextBox5.ClientID%>').val();
  40. tel = $('#<%=TextBox6.ClientID%>').val();
  41. codemeli = $('#<%=TextBox7.ClientID%>').val();
  42.  
  43. $.ajax(
  44. {
  45. type: "POST",
  46. url: "WebApplication20.aspx/executeinsert",
  47. data: "{'username':'username','name':name,
  48. 'family':family,'password':password,
  49. 'email':email,'tel':tel,
  50. 'codemeli':codemeli}",
  51. contentType: "application/json;charset=utf-8",
  52. dataType: "json",
  53. async: true,
  54. cache: false,
  55. success: function(msg) {
  56. alert(msg);
  57. },
  58. error: function (x, e) {
  59. alert("The call to the server side failed. "
  60. + x.responseText);
  61. }
  62. }
  63. );
  64. }
  65. )
  66. })
  67. </script>
  68.  
  69. data: "{'username' : 'username', 'name':name,'family':family,'password':password,'email':email,'tel':tel,'codemeli':codemeli }",
  70.  
  71. data: "{'username' : 'username', 'name':'name', 'family':'family', 'password':'password', 'email':'email', 'tel':'tel', 'codemeli':'codemeli'}",
  72.  
  73. $(document).ready(function () {
  74. $("#Button1").click(function () {
  75. var userData = new Object();
  76.  
  77. userData.username = $('#<%=TextBox1.ClientID%>').val();
  78. userData.name = $('#<%=TextBox2.ClientID%>').val();
  79. userData.family = $('#<%=TextBox3.ClientID%>').val();
  80. userData.password = $('#<%=TextBox4.ClientID%>').val();
  81. userData.email = $('#<%=TextBox5.ClientID%>').val();
  82. userData.tel = $('#<%=TextBox6.ClientID%>').val();
  83. userData.codemeli = $('#<%=TextBox7.ClientID%>').val();
  84.  
  85. $.ajax({
  86. type: "POST",
  87. url: "WebApplication20.aspx/executeinsert",
  88. data: userData,
  89. contentType: "application/json;charset=utf-8",
  90. dataType: "json",
  91. async: true,
  92. cache: false,
  93. success: function (msg) {
  94. alert(msg);
  95. },
  96. error: function (x, e) {
  97. alert("The call to the server side failed. " + x.responseText);
  98. }
  99. });
  100. });
  101. });
  102.  
  103. $.ajax(
  104. {
  105. type: "POST",
  106. url: "WebApplication20.aspx/executeinsert",
  107. data: '{"username" : '+username+', "name": '+name+', "family": '+family+',
  108. "password": '+password+', "email": '+email+', "tel": '+tel+' ,
  109. "codemeli": '+codemeli+'}',.....
Add Comment
Please, Sign In to add comment