using (SqlClient client = new SqlClient())
{
  client.CommandText = "SELECT first_name, last_name, age, sex FROM users WHERE age = @age AND sex = @sex";
  client.Parameters.Add("@age", SqlDbType.Int).Value = 30;
  client.Parameters.Add("@sex", SqlDbType.VarChar, 6).Value = "Female";
  var table = client.GetTable();
  foreach(var row in table.Rows)
  {
    Console.WriteLine("Имя: {0} {1}", row["first_name"], row["last_name"]);
    Console.WriteLine("Пол: {0}", row["sex"]);
    Console.WriteLine("Возраст: {0}", row["age"]);
  }
}

using (SqlClient client = new SqlClient())
{
  client.CommandText = "SELECT first_name, last_name, age, sex FROM users WHERE age = @age AND sex = @sex";
  client.Parameters.Add("@age", SqlDbType.Int).Value = 30;
  client.Parameters.Add("@sex", SqlDbType.VarChar, 6).Value = "Female";
  var table = client.GetTable();
  foreach(var row in table.Rows)
  {
    Console.WriteLine("Имя: {0} {1}", row["first_name"], row["last_name"]);
    Console.WriteLine("Пол: {0}", row["sex"]);
    Console.WriteLine("Возраст: {0}", row["age"]);
  }
}

Using client As New SqlClient())
  client.CommandText = "SELECT first_name, last_name, age, sex FROM users WHERE age = @age AND sex = @sex"
  client.Parameters.Add("@age", SqlDbType.Int).Value = 30
  client.Parameters.Add("@sex", SqlDbType.VarChar, 6).Value = "Female" 
  Dim table As DataTable = client.GetTable()
  For Each row As DataRow In table.Rows
    Console.WriteLine("Имя: {0} {1}", row("first_name"), row("last_name"))
    Console.WriteLine("Пол: {0}", row("sex"))
    Console.WriteLine("Возраст: {0}", row("age"))
  Next 
End Using

Using client As New SqlClient())
  client.CommandText = "SELECT first_name, last_name, age, sex FROM users WHERE age = @age AND sex = @sex"
  client.Parameters.Add("@age", SqlDbType.Int).Value = 30
  client.Parameters.Add("@sex", SqlDbType.VarChar, 6).Value = "Female" 
  Dim table As DataTable = client.GetTable()
  For Each row As DataRow In table.Rows
    Console.WriteLine("Имя: {0} {1}", row("first_name"), row("last_name"))
    Console.WriteLine("Пол: {0}", row("sex"))
    Console.WriteLine("Возраст: {0}", row("age"))
  Next 
End Using