Fatal error on command execution MySQL DB

See more:

C#

MySQL

Hi All,

I have a Windows form with a textbox named "txtSearch". I want to retrieve data based on value inside this textbox. However I get error "Fatal error encountered while executing command". The search result is supposed to be on a DataGridViewer.

My code is as below (Connection string is removed) :

try
{
dataGridView1.Visible = true;
BindingSource bs = new BindingSource();
DataTable newadm = new DataTable();
String term = txtSearch.Text;
string db = ----Connection String Goes Here----;

bs.DataSource = newadm;
this.dataGridView1.DataSource = bs;

MySqlConnection conn = new MySqlConnection(db);
conn.Open();

string s = "select * from newadm where firstname like @term OR lastname like @term";
MySqlCommand cmd = new MySqlCommand(s, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@term", MySqlDbType.VarChar, 40).Value = "%" + txtSearch.Text + "%";

MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = new MySqlCommand(s, conn);

da.Fill(newadm);
da.Update(newadm);
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}

If I remove the placeholders (@term), with an actual value, this works just fine. Any assitance will be greatly appreciated.

Thanks in advance.