小弟最近遇到一个难题,就是如这样一个登陆界面，怎样实现它的登陆，数据库是sql sever?

[此贴子已经被作者于2005-10-10 20:15:27编辑过]

this. * from (表名)where 登陆帐号='"+this.textBox1.Text.Trim()+"'and 登陆密码='"+this.textBox2.Text.Trim()+"';
this.SqlConnection.Open();
this.SqlSelectCommand1.ExecuteNonQuery();
SqlDataReader aa=this.SqlSelectCommand1.ExecuteReader();
if(aa.Read())
{
MessageBox.Show("登陆成功");
}
else
{
MessageBox.Show("用户名或者密码错误");
}
this.SqlConnection1.Close();

支持

谢谢啦，呵呵

哈哈哈

支持

1:创建存储过程:
create proc Login
 @UserName varch(50)
 @PassWord int
as
select * from Login where userName = @UserName and passWord = @PassWord

2:创建一个方法Login.
public void Login()
{
     conStr = "server = (local);trusted_connection = true; database = loginDataBase";

     SqlConnection sqlCon = new SqlConnection();

     try
    {
         sqlCon.Open();
         SqlCommand sqlCom = new SqlCommand("Login",conStr);
          = CommandType.StoredProcedure;

         SqlParameter userName = new SqlParameter("@UserName",SqlDbType.Varchar,50);
         userName.Direction = ParameterDirection.Input;
         userName.Value = txtUserName.Text;

         SqlParameter passWord = new SqlParameter("@PassWord",SqlDbType.Int,4);
         passWord.Direction = txtPassWord.Text;
         passWord.Value = int.Pase(txtPassWord.Text);

        sqlCom.Parameter.Add(userName);
        sqlCom.Parameter.Add(passWord);

        sqlCom.ExecuteNoQuery();
      
        MessageBox.Show("登录成功!!!");

    }
    catch(SqlException sqlExcep)
    {
         MessageBox.Show(sqlExcep.Message());
    }
    catch(Exception excep)
    {
         MessageBox.Show(excep.Message());
    }
    finally
    {
           sqlCon.Close();
    }
}

3:在"登录"按钮事件中调用方法Login
private void Login_Click(object sender, System.EventArgs e)
{
     Login();
}

喜欢!!

不错不错，一个问题能够引起众多高手的参与，难得难得！