public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
//获取页面传值
//string name = context.Request.QueryString["username"];
//string name1 = context.Request.Form["usernmae"]; //通过表单
string name = context.Request["username"];//这样写兼容上面2种写法,而且简洁。
string pass = context.Request["password"];
string str = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
string sql = "insert into t_users(username,password) values(@name,@pass)";
using (SqlConnection conn = new SqlConnection(str))
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlParameter[] parameter = { new SqlParameter("@name", name), new SqlParameter("@pass", pass) };
cmd.Parameters.AddRange(parameter);
conn.Open();
cmd.ExecuteNonQuery();
}
//添加成功之后页面跳转到index.ashx
context.Response.Redirect("/index.ashx");
{
context.Response.ContentType = "text/html";
//获取页面传值
//string name = context.Request.QueryString["username"];
//string name1 = context.Request.Form["usernmae"]; //通过表单
string name = context.Request["username"];//这样写兼容上面2种写法,而且简洁。
string pass = context.Request["password"];
string str = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
string sql = "insert into t_users(username,password) values(@name,@pass)";
using (SqlConnection conn = new SqlConnection(str))
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlParameter[] parameter = { new SqlParameter("@name", name), new SqlParameter("@pass", pass) };
cmd.Parameters.AddRange(parameter);
conn.Open();
cmd.ExecuteNonQuery();
}
//添加成功之后页面跳转到index.ashx
context.Response.Redirect("/index.ashx");
}
点击保存
添加成功