我在操作数据库时(插入,删除,更新)都对成功或失败做了相应的提示?可妖怪的是所有成功的操作提示都有效,而所有失败的操作提示都失效了??,以下选取了更新时的代码,也就是说,更新成功的话Response.Write ("<script>alert('更新成功!');</script>");有效,而更新失败的话Response.Write ("<script>alert('更新失败!');</script>");失效????=================================================================
public void update(Object sender,DataGridCommandEventArgs e)
{
string strCommand="update 表1 set name=:name where ID=:ID" ;
System.Data.OracleClient .OracleCommand comm=new OracleCommand(strCommand,conn);
comm.Parameters .Add (new OracleParameter ("ID", OracleType.Number ,10) );
comm.Parameters .Add (new OracleParameter ("name",OracleType.VarChar ,40) );
comm.Parameters ["ID"].Value =this.DataGrid1 .DataKeys [(int)e.Item .ItemIndex ];
comm.Parameters["name"].Value=((TextBox)e.Item.Cells[1].Controls[0]).Text;
conn.Open ();
try
{
comm.ExecuteNonQuery ();
Response.Write ("<script>alert('更新成功!');</script>");
this.DataGrid1 .EditItemIndex =-1;
}
catch(System.Data.OracleClient .OracleException ex)
{
Response.Write ("<script>alert('更新失败!');</script>");
}
conn.Close ();
this.BindGrid ();
}
public void update(Object sender,DataGridCommandEventArgs e)
{
string strCommand="update 表1 set name=:name where ID=:ID" ;
System.Data.OracleClient .OracleCommand comm=new OracleCommand(strCommand,conn);
comm.Parameters .Add (new OracleParameter ("ID", OracleType.Number ,10) );
comm.Parameters .Add (new OracleParameter ("name",OracleType.VarChar ,40) );
comm.Parameters ["ID"].Value =this.DataGrid1 .DataKeys [(int)e.Item .ItemIndex ];
comm.Parameters["name"].Value=((TextBox)e.Item.Cells[1].Controls[0]).Text;
conn.Open ();
try
{
comm.ExecuteNonQuery ();
Response.Write ("<script>alert('更新成功!');</script>");
this.DataGrid1 .EditItemIndex =-1;
}
catch(System.Data.OracleClient .OracleException ex)
{
Response.Write ("<script>alert('更新失败!');</script>");
}
conn.Close ();
this.BindGrid ();
}
try
{
comm.ExecuteNonQuery ();
boolean=true;
this.DataGrid1 .EditItemIndex =-1;
}
catch(System.Data.OracleClient .OracleException ex)
{
boolean=false;
}
if(boolean)
Response.Write ("<script>alert('更新成功!');</script>");
else
Response.Write ("<script>alert('更新失败!');</script>");
conn.Close ();
this.BindGrid ();
}
if(result>0)
Response.Write ("<script>alert('更新成功!');</script>");
else
Response.Write ("<script>alert('更新失败!');</script>");
Response.Write ("<script>alert('添加失败!');</script>");Alert怎么输入变量
我想加入错误提示就又没提示框跳出来了,上面的能跳出来
Response.Write ("<script>alert('添加失败!"+ex.Message +"');</script>");
Page.RegisterStartupScript("msg","<script>alert('删除成功!')</script>');