jexcel_删除行并同步数据库

写在*.aspx中

    //删除行 OK
    var myDeleteRow = function () {
        var DBID = document.getElementById("my_textbox").value;
        //var tempConfirm = confirm("DBID为：" + DBID); //弹出确认框 
        var tempConfirm = confirm("确定删除吗？"); //弹出确认框 
        if (tempConfirm == true) {
            $.ajax({
                url: "Handler2.ashx", //删除行_写入数据库
                datatype: "json",
                data: { "RequestType": "deleted_Row", "DBID": DBID },
                success: function (data) {
                    document.getElementById('spreadsheet').jexcel.refresh(); //刷新表格
                },
                error: function (error) {
                    alert(error.responseText);
                }
            });
        }
    };

辅助删除代码（将选中的行ID，存放到页面的文本框中，文本框要做隐藏。）

//点击单元格，获取行列坐标 OK
    var selectionActive = function (instance, x1, y1, x2, y2, origin) {
        var cellName = jexcel.getColumnNameFromId([0, y1]);
        var DBID = document.getElementById('spreadsheet').jexcel.getValue(cellName);
        document.getElementById("my_textbox").value = DBID;

        //var data = document.getElementById('spreadsheet').jexcel.getData().length;//表格上显示的数据或公式       
        //var tempConfirm = confirm("DBID:" + DBID + " data:" + data); //弹出确认框

    };

 

写在*.ashx中

//前端删除行_写入数据库 OK 
        if (context.Request["RequestType"] == "deleted_Row") //save_data是homePage.aspx中自定义的请求类型
        {
            string dbId = context.Request["DBID"].ToString();            //ID                        
            string s0 = "delete from outstanding where id=" + dbId;

            //确认查询语句，是否正确
            //context.Response.Write(s0);

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

        };