在登录之前首先有和数据库连接
http://blog.csdn.net/tskyming/article/details/8495024
然后就是和数据库进行数据交互
交换程序源码
Console.WriteLine("请输入用户名");
string username = Console.ReadLine();
Console.WriteLine("请输入密码");
string password = Console.ReadLine();
using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "Select * from T_Users where UserName='"+username+"'";
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
//
string dbpassword = reader.GetString(reader.GetOrdinal("Password"));
if (password == dbpassword.Trim())
{ Console.WriteLine("登录成功"); }
else
{
Console.WriteLine("登录失败");
}
}
else
{
Console.WriteLine("用户名错误");
}
}
cmd.ExecuteNonQuery();
}
}