Comments by Member 9430088 (Top 4 by date)

Sorry its still not working

When i execute this nothing happens
the datagridview does not update

public void Search()
{
OleDbCommand ocm = new OleDbCommand("SELECT Firstname FROM students WHERE Firstname LIKE '% Hello %' ", conn);
conn.Open();
ocm.ExecuteNonQuery();
conn.Close();


}

Please let me Know with an example code on how to search The dataTable .
I have Know idea how to do this