黑马程序员----登录练习

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace 练习登录2
{
    class Program
    {
        static void Main(string[] args)
        {
            using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Mytest.mdf;Integrated Security=True;User Instance=True"))
            {
                conn.Open();
                Console.WriteLine("请输入您的姓名：");
                string name=Console.ReadLine();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select * from MyTable1 where Name='"+name+"' ";
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.Read())
                        {
                            Console.WriteLine("请输入密码：");
                            string password = Console.ReadLine();
                            if (password == reader.GetString(reader.GetOrdinal("PassWord")))
                            {
                                Console.WriteLine("登录成功");
                            }
                            else
                            {
                                Console.WriteLine("密码错误");
                            }
                        }
                        else
                        {
                            Console.WriteLine("该用户不存在，登录失败");
                        }
                    }
                }
            }
            Console.ReadKey();
        }
    }
}