核心代码(本人没有SQLServer,所以用Access代替了,将所有的Ole替换成Sql就可以了,请参阅附件中的完整代码):
namespace DALC
{
using System.Configuration;
using System.Data.OleDb;
public class UserDal
{
public int GetUser(string userName, string password)
{
using (var connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["LoginDemo.Properties.Settings.LoginDemoConnectionString"].ConnectionString))
{
var command = new OleDbCommand
{
Connection = connection,
CommandText = @"SELECT COUNT(1) FROM Users
WHERE UserName = @UserName
AND Password = @Password"
};
command.Parameters.AddWithValue("@UserName", userName);
command.Parameters.AddWithValue("@Password", password);
connection.Open();
return (int)command.ExecuteScalar();
}
}
}
}