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