UC知道用 c# asp.net编写密码修改页面 数据库SQL请帮我完善下代码！！
来源：百度知道 编辑：UC知道 时间：2024/05/22 15:28:20
我的代码如下：
public partial class xgmm : System.Web.UI.Page
{
private string sqlConnection,str;
private data mydata = new data();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=192.168.1.5;Uid=sa;Pwd=sa;Database=AllSystemData");
string str = "insert into basic_person(vch_loginname,vch_password) values('" + TextBox1.Text + "','" + TextBox2.Text + "')";
SqlCommand cmd = new SqlCommand(str, conn);
Response.Write("<script language='javascript'>alert('密码修改成功');window.location.href('xgmm1.aspx');</script>");
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
出现的错误是在 ：conn.Open()
public partial class xgmm : System.Web.UI.Page
{
private string sqlConnection,str;
private data mydata = new data();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=192.168.1.5;Uid=sa;Pwd=sa;Database=AllSystemData");
string str = "insert into basic_person(vch_loginname,vch_password) values('" + TextBox1.Text + "','" + TextBox2.Text + "')";
SqlCommand cmd = new SqlCommand(str, conn);
Response.Write("<script language='javascript'>alert('密码修改成功');window.location.href('xgmm1.aspx');</script>");
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
出现的错误是在 ：conn.Open()
//修改用户密码
private void subbtn_Click(object sender, System.EventArgs e)
{
string usetxt=this.usertxt.Text;//用户名
string pass=this.passtxt.Text;//密码框
string cpass=this.cpasstxt.Text;//确认密码框
if(usetxt=="")
{
this.Response.Write("<script>alert('用户名不能为空!');</script>");
return;
}
if(pass != cpass)
{
this.Response.Write("<script>alert('两次输入的密码不一致!');</script>");
return;
}
else
{
//获取Web.config中的连接字符串
string sqlConnString=ConfigurationSettings.AppSettings["SQLConnString"].ToString();
//连接数据库
SqlConnection conn=new SqlConnection(sqlConnString);
SqlCommand cm=new SqlCommand("proc_user_add",conn);//使用存储过程
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add("@pro_uname",us