create proc usp_T_Users_Insert
@username varchar(50),
@password varchar(50),
@email varchar(50)
as
begin
insert into T_Users values(@username,@password,@email)
end
---------------------------------------------------------------
Web.config:
<connectionStrings>
<add name="UserDB1conStr" connectionString="Data Source=PC_THINK-THINK;Initial Catalog=UserDB1;User ID=sa; Password=111111"/>
</connectionStrings>
registor.aspx:
protected void btnregistor_Click(object sender, EventArgs e)
{
string UserConstr = ConfigurationManager.ConnectionStrings["UserDB1conStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(UserConstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
string sp_name = "usp_T_Users_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sp_name;
SqlParameter prm1 = new SqlParameter("@username", txtUserName.Text);
SqlParameter prm2 = new SqlParameter("@password ", txtPassword.Text);
SqlParameter prm3 = new SqlParameter("@email", txtEmail.Text);
cmd.Parameters.Add(prm1);
cmd.Parameters.Add(prm2);
cmd.Parameters.Add(prm3);
int r = cmd.ExecuteNonQuery();
if (r > 0)
{
Label1.Text = "注册成功!";
}
else
{
Label1.Text = "注册失败!";
}
}
}
}