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!");
}
}
}
