OracleDataAccess oda = new OracleDataAccess();
string sql = "insert into TBL_TeachChapter(BrfNo,ChapNo,ChapName,Hour) " +
"values(:BrfNo,:ChapNo,:ChapName,:Hour)";
OracleParameter[] ops =
{
new OracleParameter(":BrfNo",tc.BrfNo),
new OracleParameter(":ChapNo",tc.ChapNo),
new OracleParameter(":ChapName",tc.ChapName),
new OracleParameter(":Hour",tc.Hour)
};
try
{
oda.ExecuteNonQuery(sql, ops);
Response.Redirect("../../RedirectPage.aspx?RedirectPath=" + "./CourseManage/OutLine/AddTeachChapter.aspx");
this.grdChap.Visible = true;
btnAddChapter.Visible = true;
this.tbAddTable.Visible = false;
}
catch(Exception ex)
{
Response.Write("<script>数据重复</script>");
}
Response.Redirect("../../RedirectPage.aspx?RedirectPath=" + "./CourseManage/OutLine/AddTeachChapter.aspx");
this.grdChap.Visible = true;
btnAddChapter.Visible = true;
this.tbAddTable.Visible = false;
string sql = "insert into TBL_TeachChapter(BrfNo,ChapNo,ChapName,Hour) " +
"values(:BrfNo,:ChapNo,:ChapName,:Hour)";
OracleParameter[] ops =
{
new OracleParameter(":BrfNo",tc.BrfNo),
new OracleParameter(":ChapNo",tc.ChapNo),
new OracleParameter(":ChapName",tc.ChapName),
new OracleParameter(":Hour",tc.Hour)
};
try
{
oda.ExecuteNonQuery(sql, ops);
Response.Redirect("../../RedirectPage.aspx?RedirectPath=" + "./CourseManage/OutLine/AddTeachChapter.aspx");
this.grdChap.Visible = true;
btnAddChapter.Visible = true;
this.tbAddTable.Visible = false;
}
catch(Exception ex)
{
Response.Write("<script>数据重复</script>");
}
Response.Redirect("../../RedirectPage.aspx?RedirectPath=" + "./CourseManage/OutLine/AddTeachChapter.aspx");
this.grdChap.Visible = true;
btnAddChapter.Visible = true;
this.tbAddTable.Visible = false;
{
Response.Write("<script>alert('数据重复');window.location.href='"+
"../../RedirectPage.aspx?RedirectPath=" + "./CourseManage/OutLine/AddTeachChapter.aspx';</script>");
}
去掉最后的这几行. Response.Redirect("../../RedirectPage.aspx?RedirectPath=" + "./CourseManage/OutLine/AddTeachChapter.aspx");
this.grdChap.Visible = true;
btnAddChapter.Visible = true;
this.tbAddTable.Visible = false;
就已经被Redirect了
一个办法
就是你把后面的Redirect代码也用js脚本代替 再写一个Response.Write
内容是
<script>location.replace(xxxx)</script>
具体函数用法查阅JS文档
this.grdChap.Visible = true;
btnAddChapter.Visible = true;
this.tbAddTable.Visible = false;
不管你异常没有都执行了上面的语句。如果一定要执行上面的语句最好加上个判断啊!!!