写插入存储过程，并在注册页面中使用。
Sql Server存储过程：
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 = "注册失败！";
}
}
}
}