在datagrid中添加了删除按钮,点击这个按钮后弹出一个确认对话框,询问用户是否确定删除数据,如果是就删除数据,如果否就回到原来的页面,请问能不能在后台的cs文件中添加相应的代码,获取用户所按下的是那个按钮?下面是这个按钮的后台代码
public void deleteCommand(Object sender,DataGridCommandEventArgs e)
{
Response.Write("<script>confirm(\"你确定删除这条数据吗?\")</script>");
string name=e.Item.Cells[1].Text;
string connstr="Provider=Microsoft.Jet.OleDb.4.0;data source="+Server.MapPath("student.mdb"); OleDbConnection1=new OleDbConnection(connstr);
OleDbCommand cmd=new OleDbCommand();
cmd.CommandText="delete from student where name=@name";
cmd.Connection=OleDbConnection1;
OleDbParameter pName=new OleDbParameter("@name",OleDbType.Char);
pName.Value=name;
cmd.Parameters.Add(pName);
OleDbConnection1.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
OleDbConnection1.Dispose();
displayData();
}
public void deleteCommand(Object sender,DataGridCommandEventArgs e)
{
Response.Write("<script>confirm(\"你确定删除这条数据吗?\")</script>");
string name=e.Item.Cells[1].Text;
string connstr="Provider=Microsoft.Jet.OleDb.4.0;data source="+Server.MapPath("student.mdb"); OleDbConnection1=new OleDbConnection(connstr);
OleDbCommand cmd=new OleDbCommand();
cmd.CommandText="delete from student where name=@name";
cmd.Connection=OleDbConnection1;
OleDbParameter pName=new OleDbParameter("@name",OleDbType.Char);
pName.Value=name;
cmd.Parameters.Add(pName);
OleDbConnection1.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
OleDbConnection1.Dispose();
displayData();
}
你使用DataGrid,可以:
protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
LinkButton lb = e.Item.Cells[0].Controls[0] as LinkButton;
if (lb != null)
{
lb.Attributes.Add("onclick", "return confirm('确认删除吗?');");
}
}
}
如果用户点‘取消’,页面是不会回发的。====
~~~~ 我的Blog:http://blog.csdn.net/quou2002