public void RetrieveTables() // public for testing { using (SqlConnection serverConnection = new SqlConnection(conString)) { string query = "select * from Project"; using (SqlCommand cmd = new SqlCommand(query, serverConnection)) { ProjectTable.Clear(); // create data adapter to read table into DataTable object using (SqlDataAdapter da = new SqlDataAdapter(cmd)) da.Fill(ProjectTable); } query = "select * from [User]"; using (SqlCommand cmd = new SqlCommand(query, serverConnection)) { UserTable.Clear(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) da.Fill(UserTable); } query = "select * from Task"; using (SqlCommand cmd = new SqlCommand(query, serverConnection)) { TaskTable.Clear(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) da.Fill(TaskTable); } } }