Try:
if (myComboBox.Text == "Name")
{
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT Id, Description FROM myTable WHERE NameColumn LIKE '%' + @NAME + '%'", con))
{
cmd.Parameters.AddWithValue("@NAME", myTextBox.Text);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int id = (int)reader["Id"];
string desc = (string)reader["Description"];
Console.WriteLine("ID: {0}\n {1}", iD, desc);
}
}
}
}
}