public void searchData(string valueToSearch) { string query = "SELECT * FROM `assessment` WHERE CONCAT(`ID`, `First Name`, `Last Name`, `Age`, `Date`, `Swim Team/s`, `Swim Group`, `Grade`) like '%" + valueToSearch + "%' AND `Swim Team/s`= 'Dolphin'"; command = new MySqlCommand(query, connection); adapter = new MySqlDataAdapter(command); table = new DataTable(); adapter.Fill(table); dataGridView1.DataSource = assessment.getAssessments(command); }
private void Assessment_List_Load(object sender, EventArgs e) { labelUser.Text = GLOBAL.userType; //populating the datagridview with swimmer's data MySqlCommand command = new MySqlCommand("SELECT * FROM `assessment`"); dataGridView1.ReadOnly = true; dataGridView1.RowTemplate.Height = 30; dataGridView1.DataSource = assessment.getAssessments(command); dataGridView1.AllowUserToAddRows = false; searchData(""); }