大家进来帮帮小弟,很简单的问题.多谢!!
这段代码"clear.aspx"是用来清空数据库的,如何在点击该页上某一个清除按钮后,系统自动跳出一个小窗口,显示该表已经清空,然后点确定关闭小窗口. 另外在该页面下添加一个返回按钮,返回上一页,比如上一页是"clearlogin.aspx".谢谢!!
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace CourseWork3
{
/// <summary>
/// </summary>
public class WebForm12 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.Button Button3;
protected System.Web.UI.WebControls.Button Button4;
protected System.Web.UI.WebControls.Button Button5;
protected System.Web.UI.WebControls.Label Label2;
protected System.Data.SqlClient.SqlConnection VisitConnection;
private void Page_Load(object sender, System.EventArgs e)
{
}
#region
override protected void OnInit(EventArgs e)
{
//
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// </summary>
private void InitializeComponent()
{
this.VisitConnection = new System.Data.SqlClient.SqlConnection();
this.Button5.Click += new System.EventHandler(this.Button5_Click);
this.Button4.Click += new System.EventHandler(this.Button4_Click);
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
//
// VisitConnection
//
this.VisitConnection.ConnectionString = "workstation id=erhtrc;packet size=4096;integrated security=SSPI;data source=erthr" +
"c;persist security info=False;initial catalog=VisitDays";
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
try
{
VisitConnection.Open();
SqlCommand cmd =
new SqlCommand("delete from Applicant",VisitConnection);
cmd.ExecuteReader();
}
finally{
VisitConnection.Close();
}
}
private void Button2_Click(object sender, System.EventArgs e)
{
try
{
VisitConnection.Open();
SqlCommand cmd =
new SqlCommand("delete from Applications",VisitConnection);
cmd.ExecuteReader();
}
finally
{
VisitConnection.Close();
}
}
private void Button3_Click(object sender, System.EventArgs e)
{
try
{
VisitConnection.Open();
SqlCommand cmd =
new SqlCommand("delete from Attending",VisitConnection);
cmd.ExecuteReader();
}
finally
{
VisitConnection.Close();
}
}
private void Button4_Click(object sender, System.EventArgs e)
{
try
{
VisitConnection.Open();
SqlCommand cmd =
new SqlCommand("delete from Course",VisitConnection);
cmd.ExecuteReader();
}
finally
{
VisitConnection.Close();
}
}
private void Button5_Click(object sender, System.EventArgs e)
{
try
{
VisitConnection.Open();
SqlCommand cmd =
new SqlCommand("delete from OpenDay",VisitConnection);
cmd.ExecuteReader();
}
finally
{
VisitConnection.Close();
}
}
}
}
问题点数：0、回复次数：16Top
1 楼tophifi（黑字先生）回复于 2005-04-01 12:37:06 得分 0
如何在点击该页上某一个清除按钮后,系统自动跳出一个小窗口,显示该表已经清空,然后点确定关闭小窗口.
Response.Write(<script language=javascript>alert('数据已经清空！');</script>);
另外在该页面下添加一个返回按钮,返回上一页,比如上一页是"clearlogin.aspx".
<a href="javascript:history.back();"><返回上一页/a>Top
2 楼tophifi（黑字先生）回复于 2005-04-01 12:37:50 得分 0
另外在该页面下添加一个返回按钮,返回上一页,比如上一页是"clearlogin.aspx".
<a href="javascript:history.back();">返回上一页</a>
Top
3 楼sunny_blackhorse（sunny）回复于 2005-04-01 12:38:00 得分 0
点第一个按钮触发这个事件：Response.Write("<script language=javascript>alert('该表已经清空！');</script>");
点第二个按钮触发这个事件：注：你的第二个按钮在客户断这样定义<input type="submit" name="Submit2" value="后退" onClick=history.go(-1)>Top
4 楼sunny_blackhorse（sunny）回复于 2005-04-01 12:40:05 得分 0
如果非要用服务器的按钮你就这样写：在第二个按钮事件里这样写：
Response.Redirect("clearlogin.aspx");
Top
5 楼syeerzy（快乐永远*先天下之乐而乐*后天下之忧而忧*）回复于 2005-04-01 12:49:35 得分 0
弹出：
Response.Write(<script language=javascript>alert('数据已经清空！');</script>);
返回：
Response.Redirect("clearlogin.aspx");
Top
6 楼bylmy（）回复于 2005-04-01 12:57:19 得分 0
多谢各位,小弟还想补充一下,想在点击清除按钮后,先出一个窗口提示是否确定清除,然后有确定或取消,点确定后接上面的小窗口,点取消返回页面,如何做?再谢!Top
7 楼sunny_blackhorse（sunny）回复于 2005-04-01 13:03:02 得分 0
btn.Attributes.Add("onclick", "javascript:{if(confirm('确定删除吗？')==false) return false;}");写在page_lode里Top
8 楼sunny_blackhorse（sunny）回复于 2005-04-01 13:03:40 得分 0
不对，按钮事件Top
9 楼tophifi（黑字先生）回复于 2005-04-01 13:06:48 得分 0
<form id=form1 onsubmit=return confirm('资料将被删除，请确认') >Top
10 楼HONGDUN（）回复于 2005-04-01 13:10:47 得分 0
在Page_Load中
btn.Attributes.Add("onclick", "return confirm('确定删除吗？');}");Top
11 楼bylmy（）回复于 2005-04-01 13:19:55 得分 0
各位,能不能写个完整的给我啊,小弟等急用呢?Top
12 楼bylmy（）回复于 2005-04-01 13:27:19 得分 0
帮上面三个新增的直接添到小弟的代码中,我现在都快晕了,大家帮帮忙吧Top
13 楼bylmy（）回复于 2005-04-01 13:37:49 得分 0
怎么没人理我了,都吃饭去了?Top
14 楼hyj_828（水梦）回复于 2005-04-01 13:52:51 得分 0
upTop
15 楼morality（业精于勤，行成于思！）回复于 2005-04-01 16:07:56 得分 0
private void Page_Load(...)
{
if(!IsPostBack)
{
btnDel.Attributes.Add("onclick","return confirm('您确定要删除吗？');");
}
}
private void btnDel_Click(...)
{
//your delete code here
}Top
16 楼bylmy（）回复于 2005-04-01 22:44:10 得分 0
不行啊，小弟在VS.net里编译，有问题！Top
