C# And MySQL - How To Search / Filter DataGridView Data Depending On Combobox Value [+ Source Code ]

private void invoicenotext_TextChanged(object sender, EventArgs e)
{

SqlDataAdapter sda = new SqlDataAdapter("SELECT [ID],[InventoryID],[InvoiceNo],[SupCode],[SupName],[PCode],[Pname],[ReceivedQty],[ReceivedDate],[PUnit],[Employee1],[Employee2],[Price],[TotalPrice] FROM[1_new].[dbo].[Invoice] where invoiceno like '" + invoicenotext.Text + "' ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
dataGridView1.DataSource = dt;


why all thisssssssssssssssssss while i can do it very simple