Ajax+jquery+asp enables real-time verification of identity card information already exists

2. <span style="font-size:18px" ><td height= "" align= "right" class="Style17" >
4. ID number
6. :</td>
8. <TD height="align=" "left" class="Style19" >
10. <input type="text" id="Txtidnumber" onblur= "Judgeusername()" Width="140px"/> /c0>
14. </td>
16. <script type="Text/javascript" >
18. function Judgeusername () {
20. //Gets the input value of the control in the page
22. Browers = +$ ("#txtidNumber"). Val ();
24. //define the type and pass the value to the parameter params
26. var params = ' {browerstype: ' + browers + ' "} ';
28. $.ajax ({//Invoke Ajax Backend data async method
30. //How to submit
32. Type: "Post",
34. //Data transfer page: To start the interface of the address/interface of the background method
36. URL: "Add.aspx/sayhello",
38. ContentType: "Application/json; Charset=utf-8 ",
40. Data:params,
42. parameter types that are passed to the server
44. DataType: "JSON",
48. //Important back-end callback function (very important)
50. Success: function (data) {
52. //Return prompt to interface effect
54. alert (DATA.D);
58. },
60. //Error alert
62. Error: function (err) {
64. alert (ERR);
66. }
68. });
70. }
72. </span>

2. <span style="font-size:18px" >[system.web.services.webmethod ()]
4. public static string SayHello (string browerstype)
6. {
8. //Create a database connection
10. SqlConnection con = new SqlConnection ("server=.; database=personnelfiles;uid=sa;pwd=123456; ");
12. //Open Connection
14. Con. Open ();
16. //Query whether this data exists in the data database sent by the foreground
18. SqlCommand cmd = new SqlCommand ("Select Count (*) from t_basicinformation where idnumber= '" + browerstype + "'"  , con);
20. //Return some number of bars
22. int count = Convert.ToInt32 (cmd).  ExecuteScalar ());
24. //To be judged
26. if (Count > 0)
28. {
30. return "This person's personal information already exists, please modify the original information!"  ";
34. }
36. Else
38. {
40. return "can be registered correctly";
42. }
46. } </span>

Ajax+jquery+asp enables real-time verification of identity card information already exists