.net ajax批量删除,asp.net 全部选中与取消操作,选中后的删除(ajax)实现无刷新效果...

前台代码

:

用户信息操作

//页面的初始化

$(document).ready( function(){ loadUserInfo(); });

//加载用户信息到页面

function loadUserInfo()

{

$.ajax(

{

type:"POST",

url:"Default.aspx",

data:{action:'action'},

success:loadUserInfoCallbace

}

);

}

//页面初始化回调函数

function loadUserInfoCallbace(r)

{

if(r=="")

{

$("#userInfo").html("暂无数据");

}

else

{

$("#userInfo").html(r);

}

}

//全部选中

function CheckAll(obj)

{

$("input[@type=checkbox][@name=checkItem]").attr("checked",$(obj).attr("checked"));

}

//收集所有选中项

function NumberID()

{

var allcheckboxs=$("input[@type=checkbox][@name=checkItem][checked]");

var ids="";

for(i=0;i

{

var id=$(allcheckboxs[i]).attr("id").split("_")[1];

ids+=id;

ids+=",";

}

return ids;

}

//删除用户

function DeleteUser()

{

if(!window.confirm("您真的要删除选中用户信息吗?"))

{

return;

}

var ids=NumberID();

$.ajax({

type:'POST',

url:'Default.aspx',

data:{action:'Delete',userid:ids},

success:deleteUserCall

});

}

//删除用户回调函数

function deleteUserCall(r)

{

if(r=="ok")

{

alert("删除成功");

loadUserInfo();

}

else

{

alert("失败");

}

}

后台代码:

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Text;

public partial class _Default : System.Web.UI.Page

{

string Straction = "";

protected void Page_Load(object sender, EventArgs e)

{

Straction = Request["action"];

if(Straction=="action")

{

UserInfo();

}

if (Straction == "Delete")

{

DeleteUser();

}

}

///

/// 周昕 2009-6-8号加载用户详细信息

///

public void UserInfo()

{

SqlConnection mycon = new SqlConnection();

mycon.ConnectionString = ConfigurationManager.ConnectionStrings["BoBoConn"].ToString();

string sql = "select * from loginuser";

SqlCommand mycom = new SqlCommand(sql, mycon);

mycon.Open();

SqlDataReader myda = mycom.ExecuteReader();

StringBuilder str = new StringBuilder();

str.Append("

全选

用户名

用户全名

while (myda.Read())

{

str.Append("

");

str.Append("

");

str.Append("

" + myda["UserName"].ToString() + "");

str.Append("

" + myda["FullName"].ToString() + "");

}

str.Append("

");

str.Append("

Response.Clear();

Response.ContentType = "application/text";

Response.Write(str);

Response.End();

}

///

/// 周昕 2009-6-8 删除选中用户的详细信息

///

public void DeleteUser()

{

//获取用户ID

string strID = Request["userid"];

string Userid = strID.Substring(0, strID.Length - 1);

//转换成为数组

string[] stridArray = Userid.Trim().Split(',');

string sql = "delete from loginuser where ID='" + stridArray[0].ToString() + "'";

for (int i = 0; i < stridArray.Length; i++)

{

string id = stridArray[i].ToString();

sql += "or ID='" + id + "'";

}

SqlConnection mycon = new SqlConnection();

mycon.ConnectionString = ConfigurationManager.ConnectionStrings["BoBoConn"].ToString();

mycon.Open();

SqlCommand mycom = new SqlCommand(sql, mycon);

int n = (int)mycom.ExecuteNonQuery();

mycon.Close();

if (n > 0)

{

Response.Clear();

Response.ContentType = "application/text";

Response.Write("ok");

Response.End();

}

else

{

Response.Clear();

Response.ContentType = "application/text";

Response.Write("no");

Response.End();

}

}

}