CapDemo.BL.UserBL.GetUser C# (CSharp) Метод

        public List<User> GetUser()
        {
            List<User> UserList = new List<User>();
            string query = "SELECT u.[User_ID],u.[Username],u.[Password]"
                        + " FROM [User] u";
            DataTable dt = DA.SelectDatabase(query);
            int i = 1;
            if (dt!= null)
            {
                foreach (DataRow item in dt.Rows)
                {
                    User User = new User();
                    User.UserID = Convert.ToInt32(item["User_ID"]);
                    User.UserName = item["Username"].ToString();
                    User.PassWord = item["Password"].ToString();
                    User.Sequence = i;
                    UserList.Add(User);
                    i++;
                }
            }
            return UserList;
        }

        //Load user table
        public void LoadUser()
        {
            UserBL UserBL = new UserBL();
            List<DO.User> UserList;
            UserList = UserBL.GetUser();
            if (UserList != null)
                dgv_UserManagement.DataSource = UserList;

            dgv_UserManagement.Columns["UserID"].Visible = false;
            dgv_UserManagement.Columns["PassWord"].Visible = false;
            dgv_UserManagement.Columns["Role"].Visible = false;
            dgv_UserManagement.Columns["Sequence"].HeaderText = "STT";
            dgv_UserManagement.Columns["UserName"].HeaderText = "Tên Tài khoản";
            dgv_UserManagement.Columns["Sequence"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
        }