title: How to read Specific row from data set
body: <p>This is the code where I have created a table. This code returns the all rows but I want only specific row where Price of item is greater than 6.</p>
  
  <pre><code>class Program
  {
      static void Main(string[] args)
      {
          DataTable MyTable = GetTable(); // Get the data table.
  
          foreach (DataRow row in MyTable.Rows) // Loop over the rows.
          {
              Console.WriteLine("--- Row ---");
              foreach (var item in row.ItemArray) // Loop over the items.
              {
                  Console.Write("Item: "); 
                  Console.WriteLine(item);
              }
          }
  
          Console.Read(); // Pause.
      }
  
      static DataTable GetTable()
      {
          DataTable table = new DataTable();
          table.Columns.Add("Price", typeof(int));
          table.Columns.Add("Name", typeof(string));
  
          table.Rows.Add(15, "Bag");
          table.Rows.Add(4, "Candies");
          table.Rows.Add(2, "Cookies");
          table.Rows.Add(20, "Books");
          table.Rows.Add(8, "Chocolates");
          return table;
      }
    }
  }
  </code></pre>