private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { userDB = userAdapter.GetData(); sessionDB = sessionAdapter.GetData(); if (comboBox1.SelectedIndex == 0) { var query = from u in userDB where u.OnlineStatus == true join s in sessionDB on u.UserID equals s.UserID into countSes from ses in countSes where ses.StartSession == countSes.Max(r => r.StartSession) select new { UserID = u.UserID, UserName = u.UserName, Password = u.UserPassword, SessionsCount = countSes.Count(), LastEnter = ses.StartSession }; dataGridViewUsers.DataSource = query.ToList(); } else if (comboBox1.SelectedIndex == 1) { var query = from u in userDB where u.OnlineStatus == false join s in sessionDB on u.UserID equals s.UserID into countSes from ses in countSes where ses.StartSession == countSes.Max(r => r.StartSession) select new { UserID = u.UserID, UserName = u.UserName, Password = u.UserPassword, SessionsCount = countSes.Count(), LastEnter = ses.StartSession }; dataGridViewUsers.DataSource = query.ToList(); } }
public Form1() { InitializeComponent(); //comboBox1.SelectedIndex = 0; chatAdapter = new MyChatTableAdapters.ChatTableAdapter(); userAdapter = new MyChatTableAdapters.UsersTableAdapter(); sessionAdapter = new MyChatTableAdapters.SessionsLogTableAdapter(); userDB = userAdapter.GetData(); chatDB = chatAdapter.GetData(); sessionDB = sessionAdapter.GetData(); }