//关键字 'User' 附近有语法错误。 求教 错哪了？

using System.Data.SqlClient;

namespace ConsoleApplication5
{
    class Program
    {
        static void Main(string[] args)
        {

            ////神奇代码：
            string dataDir = AppDomain.CurrentDomain.BaseDirectory;
            if (dataDir.EndsWith(@"\bin\Debug\")
            || dataDir.EndsWith(@"\bin\Release\"))
            {
                dataDir = (dataDir).Parent.Parent.FullName;
                AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
            }

           
            //编写登录代码：
            Console.WriteLine("请输入用户名：");
            string username = Console .ReadLine();
            Console.WriteLine("请输入密码：");
            string password = Console. ReadLine();
            using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\app.mdf;Integrated Security=True;User Instance=True"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {

                     = "select * from User where Username =='"+username+"'";

                    using (SqlDataReader reader = cmd.ExecuteReader())   //关键字 'User' 附近有语法错误。
                    {
                        if (reader.Read())
                        {
                            string dbpassword = reader.GetString(reader.GetOrdinal("Password"));
                            if (password == dbpassword)
                            {
                                Console.WriteLine("登陆成功！");

                            }
                            else
                            {

                                Console.WriteLine("密码错误！");
                            }

                        }
                        else
                        {
                            Console.WriteLine ("用户名错误！");


                        }

                    }
                }

            }      
           
            Console.ReadKey();
        }

    }
}