private void LoadUsers() { using (var db = new StudentDBDataContext()) { dgvUser.DataSource = db.Users; //.ToList() } }
private void LoadStudent() { using (var db = new StudentDBDataContext()) { var list = from s in db.Students select new { s.Id, s.StudentName, s.Birthday, s.Batch.BatchName, s.Phone, s.Address }; dgvStudent.DataSource = list; } }
private void checkLogin() { using (var db = new StudentDBDataContext()) { var user = db.Users.Where(x => x.UserName.Equals(txtUser.Text)).SingleOrDefault(); if (user != null) { if (user.Password.Equals(txtPass.Text)) { new frmMain(user).Show(); this.Hide(); } else { MessageBox.Show("Password invalid"); } } else { MessageBox.Show("User name not exists!"); } } }