110,567
社区成员
发帖
与我相关
我的任务
分享
string uid = Session["Username"].ToString();
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["contoadmin"].ToString();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "UPDATE Teacher SET te_name= @te_name,te_sex= @te_sex,te_addr= @te_addr ,te_tel= @te_tel WHERE te_id = @te_id ";
try
{
con.Open();
cmd.Parameters.Add("@te_name", SqlDbType.Char).Value = TextBox1.Text.Trim();
cmd.Parameters.Add("@te_sex", SqlDbType.Char).Value = DropDownList1.SelectedValue;
cmd.Parameters.Add("@te_addr", SqlDbType.Char).Value = TextBox2.Text.Trim();
cmd.Parameters.Add("@te_tel", SqlDbType.Char).Value = TextBox3.Text.Trim();
cmd.Parameters.Add("@te_id", SqlDbType.Char).Value = uid;
cmd.ExecuteNonQuery();
Response.Write("<script>alert('修改成功!')</script>");
}
catch(SqlException ex)
{
Response.Write(ex.ToString());
Response.Write("<script>alert('修改失败!')</script>");
}
if (cmd.ExecuteNonQuery() < 0)
{
Response.Write("<script>alert('修改成功!')</script>");
}
else
{
Response.Write("<script>alert('修改失败!')</script>");
}