SQLCommand question to view

cmd.executenonquery(); will not return you the result set. Try to use data reader or data adapter.

Check for any leading or trailing blank spaces in your data. If that is the case, using LTrim(RTrim(Countrycode)) like @Code will work fine.

SqlConnection objConnection = new SqlConnection("Connection String");
System.Data.DataSet objDataSet = new System.Data.DataSet();
SqlCommand objCommand = new SqlCommand(strQuery);
objCommand.Connection = objConnection;
objCommand.CommandType=System.Data.CommandType.Text;
//Initializing the adapter
SqlDataAdapter objDataAdapter = new SqlDataAdapter(objCommand);
//Creating the DataSet
objDataSet = new System.Data.DataSet();
//Filling the DataSet
objDataAdapter.Fill(objDataSet);
objCommand.Dispose();
objConnection.Close();

simple way to pass the parameters is to embed them to commandstring.
like

string s = "Select * from Country where Countrycode like '%"+ Code +"%'"

and in query u r selecting multiple values so u had to use SqlDataReader.
SqlDataReader stores multiple columns and rows. and to read the data write code like this one

while(reader.read())
{
value1=reader[0]//u can use column name instead of index number.
value2=reader["Name"]//like i used it here
// use arrays  to store the data.
}

Try this,

var SQL = string.format("SELECT * FROM {0} WHERE {1} LIKE ?", TABLE, NAME);
Cmd.Parameters.AddWithValue(@code, "%" + value + "%");