jexcel_增加行并同步数据库

写在*.aspx中

//增加行 OK
    var addRow = function () {
        var fieldName = "type";     //字段名 
        var modifyValue = "请输入";    //值 
        //var tempConfirm = confirm("modifyValue：" + modifyValue + "  fieldName：" + fieldName)//确认
        
        $.ajax({
            url: "Handler2.ashx",
            datatype: "json",
            data: { "RequestType": "inserted_Row", "modifyValue": modifyValue, "fieldName": fieldName },
            success: function (data) {
                document.getElementById('spreadsheet').jexcel.refresh(); //刷新表格                
            }
        });

    }

写在*.ashx中

//前端增加行_写入数据库 OK
        if (context.Request["RequestType"] == "inserted_Row")
        {
            string fieldName = context.Request["fieldName"].ToString();     //字段名 
            string modifyValue = context.Request["modifyValue"].ToString(); //值 


            //确认是否收到值
            //Console.Write("来到Handler2中" + fieldName+ "_" + modifyValue);
            //context.Response.Write("Handler2中取到的值：" + fieldName+ "_" + modifyValue);

            string s0 = "insert into outstanding (" + fieldName + ") values ('" + modifyValue + "')";
            //context.Response.Write(s0); //确认值

            //往数据库写入新信息  
            SqlConnection conn = new SqlConnection("server=150.17.232.180;database=SSC;uid=sscosd;pwd=BtQasYxonQuZqukIYkGM");
            conn.Open();
            SqlCommand cmd = new SqlCommand(s0, conn); //用来执行查询语句           
            cmd.ExecuteNonQuery();    //执行SQL语句，返回受影响的行数            
            cmd.Dispose();            //释放资源
            conn.Close();

        };