ASP.NET前台html页面AJAX提交数据后台ashx页面接收数据

 1 
class="yjdjfm">
 2     
class="yjdjfd"> 
 3         

 4             

仪检名称："txtyjneme" name="txtyjneme" type="text" value="" required="required"  oninvalid="setCustomValidity(‘必须填写！‘);" oninput="setCustomValidity(‘‘);"  />*class="yz_name" style="display:none; color:red;">请填写仪检名称

 5             

规格型号："txtyjxh" name="txtyjxh" type="text" value="" autofocus="autofocus" placeholder="" />*class="yz_xh" style="display:none; color:red;">请填写规格型号

 6             

出厂编号："txtyjnumber" name="txtyjnumber" type="text" value="" />*class="yz_bh" style="display:none; color:red;">请填写设备编号

 7         
 8 
 9         
"float:right; margin-top:-122px;">
10             

登记日期："txtyjdate" name="txtyjdate" type="text" value="" readonly />*"color:#d0cfcf;">系统默认时间

11             

登 记  人："txtyjperson" name="txtyjperson" type="text" value="" />*class="yz_person" style="display:none; color:red;">请填写您的姓名

12             

联系电话："txtyjphone" name="txtyjphone" type="number" value="" />*class="yz_phone" style="display:none; color:red;">请正确填写手机号码

13         
14     
15    class="yjdjtjan" id="btntj">添加记录
16 
17     
"clear:both;">
18 
19 
20     
class="yjdjlist">
21         "tttab">
22"yjdjtrone">
232425262728293031
             
                 
序号
                 
仪检名称
                 
规格型号
                 
出厂编号
                 
登记日期
                 
登 记  人
                 
联系电话
             
         

32 

 1  

 1  public void ProcessRequest(HttpContext context)
 2         {
 3             
 4             var name = HttpContext.Current.Request["name"];
 5             var xh = HttpContext.Current.Request["xh"];
 6             var bh = HttpContext.Current.Request["bh"];
 7             var data = HttpContext.Current.Request["date"];
 8             var person = HttpContext.Current.Request["person"];
 9             var phone =HttpContext.Current.Request["phone"];
10             string _sql = string.Format("insert into InstrumentCheck(Name,Modle,Number,Person,Phone) values(‘{0}‘,‘{1}‘,‘{2}‘,‘{3}‘,‘{4}‘)",name,xh,bh,person, phone);
11             _sql.Replace("‘", " ");
12              ExecuteNonQuery(_sql);
13         }
14         public static string connectionStringgg = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
15         /// 

16         /// 插入数据
17         /// 
18         /// sql语句
19         /// 影响的行数
20         public void ExecuteNonQuery(string sql)
21         {
22                 SqlConnection connection = new SqlConnection(connectionStringgg);
23             if(connection.State==ConnectionState.Closed)
24             {
25                 connection.Open();
26             }
27                 
28                 SqlCommand cmd = new SqlCommand(sql, connection);
29                  cmd.ExecuteNonQuery();
30 
31         }