I have a combo box which i wish to display all the Usernames from the table Users, but with the UsergroupID of 1. However my codes currently displays ALL Username records. How can i modify it to only fetch Usernames records with the UsergroupID of 1?
Codes as follows:
string query = "SELECT Username FROM Users"; OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, sConnectionString); DataTable source = new DataTable(); dAdapter.Fill(source); UsernameComboBox.DataSource = source; UsernameComboBox.DisplayMember = "Username";
- ID (PK)
Any help will be greatly appreciated, cheers!