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]
value2=reader["Name"]
}