62,046
社区成员
发帖
与我相关
我的任务
分享
protected void Button1_Click(object sender, EventArgs e)
{
using (OracleConnection conn = new OracleConnection(DB.connString))
{
conn.Open();
OracleTransaction tran = conn.BeginTransaction();
string sql = String.Format("insert into eight_dossierinfo(image_id,image_url,dossier_id,image_name)"
+ "values({0},'{1}',{2},'{3}')",TextBox1.Text.Trim(),TextBox2.Text.Trim(),TextBox3.Text.Trim(),TextBox4.Text.Trim());
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.Transaction = tran;
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Button1.Attributes.Add("onclick", "return prompt ('添加成功');");
//Response.Write("<script>alert('添加成功')</script>");
tran.Commit();
}
else
{
Response.Write("<script>alert('添加失败')</script>");
}
}
Response.Redirect("EightAddImage.aspx");
}