title: C# DataTable Show Single Row in Console
body: <p>I have searched high and low for a method to show the entire row of a C# datatable, both by referencing the row number and by simply writing the row contents to a string variable and showing the string in the console. I can specify the exact row and field value and display that value, but not the whole row. This is not a list in C#, this is a datatable.</p>
  
  <p>For the simple code below, the output I get for the first WriteLine is "Horse", but the second two WriteLine commands, I get the console output of "System.Data.DataRow" instead of the whole row of data.</p>
  
  <p>What am I doing wrong? Any help would be appreciated.</p>
  
  <pre><code>using System;
  using System.Data;
  using System.Threading;
  
  namespace DataTablePractice
  {
      class Program
      {
          static void Main(string[] args)
          {
  
              // Create a DataTable.
              using (DataTable table = new DataTable())
              {
                  // Two columns.
                  table.TableName = "table";
                  table.Columns.Add("Number", typeof(string));
                  table.Columns.Add("Pet", typeof(string));
  
                  // ... Add two rows.
                  table.Rows.Add("4", "Horse");
                  table.Rows.Add("10", "Moose");
  
                  // ... Display first field of the first row in the console
                  Console.WriteLine(table.Rows[0].Field&lt;string&gt;(1));
  
                  //...Display the first row of the table in the console
                  Console.WriteLine(table.Rows[0]);
  
                  //...Create a new row variable to add a third pet
                  var newrow = table.Rows.Add("15", "Snake");
                  string NewRowString = newrow.ToString();
  
                  //...Display the new row of data in the console
                  Console.WriteLine(NewRowString);
  
                  //...Sleep for a few seconds to examine output
                  Thread.Sleep(4000);
  
              }
          }
      }
  }
  
  </code></pre>