asp.net存储过程登陆

 

 第一步在数据库中创那一个存储过程：

create procedure ProUserLogin
(@LoginName [VarChar](50),
@PassWord [VarChar](50))
as
select*from t_user where username=@LoginName and password=@PassWord
go

 

第二步写一个调用存储过程的方法封装在一个类（abc）

 public static SqlConnection getcon() //连接数据库
    {
        SqlConnection conn = new SqlConnection("server=.;database=test;pwd=123456789;uid=sa");
        conn.Open();
        return conn;
    }

      public int ExeProedure(string sqltxt, SqlParameter[] splist)//调用存储过程方法
    {
        SqlConnection conn = getcon();//getcon()为连接数据库的方法
        SqlCommand cmd = new SqlCommand(sqltxt, conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddRange(splist);
        int i = 0;
       // conn.Open();
        i = cmd.ExecuteNonQuery();
        conn.Close();
        return i;
    }

登陆确定按钮事件里调用

new dbget=new abc();

 protected void Button1_Click(object sender, EventArgs e)
    {
         SqlParameter[] param = new SqlParameter[2];
        param[0] = new SqlParameter("@LoginName", TextBox1.Text);
        param[1] = new SqlParameter("@password", TextBox2.Text);

        if (dbget.ExeProedure("ProUserLogin", param) == 1)
        {
            //
            Response.Write("<script>alert('登录成功')</script>");
        }
        else
        {
            Response.Write("<script>alert('登录成功')</script>");
        }
    }