1.编写前端
function DelInfo() {
// $("a").click(function () {
var SN = $("a").attr("name");
// });
$.ajax({
type: "POST",
url: "MainForm.aspx/DelInfo",
contentType: "application/json",
dataType: "json",
data: "{\"strSN\":\"" + SN + "\"}", //以json格式传参数
success: function (data) {
alert("删除成功");
$("#tb1").css("color", "#0000FF").html(data.d);
},
error: function (msg) {
alert(msg);
}
});
}
2.绑定到点击事件
strSb.Append("<td><a href='#' ' name='" + dr["SN"] + "' style='color:red' οnclick=\"DelInfo()\">删除</a> </td>");
3.webmethod
[WebMethod]
public static String DelInfo(string strSN)
{
string strMsg = "";
OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
try
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = " delete from t_cx_stumanage_student where SN=" + strSN + "";
cmd.ExecuteNonQuery();
return ShowAllStu();
}
catch (Exception ex)
{
return ex.Message;
}
}