Csharp/C Sharp by API/System.Data/DataTableCollection

DataTableCollection.Indexer

<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient;

  class FilterSort
  {
     static void Main(string[] args)
     {
        string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
        string sql1 = @"select * from employee;";
        string sql2 = @"select firstname, lastname from employee";
        string sql = sql1 + sql2;
        SqlConnection conn = new SqlConnection(connString);
        try {
           SqlDataAdapter da = new SqlDataAdapter();
           da.SelectCommand = new SqlCommand(sql, conn);
           DataSet ds = new DataSet();
           da.Fill(ds, "employee");
           DataTableCollection dtc = ds.Tables;
           Console.WriteLine("Results from Customers table:");
           Console.WriteLine("FirstName".PadRight(20) + "LastName".PadLeft(23) + "\n");
           string fl = "FirstName = "Z"";
           string srt = "LastName asc";
           foreach (DataRow row in dtc["Employee"].Select(fl, srt))
           {
              Console.WriteLine(
                 "{0}\t{1}", 
                 row["FirstName"].ToString().PadRight(25),
                 row["LastName"]);
           }
           Console.WriteLine("Results from Products table:");
           Console.WriteLine("FirstName".PadRight(20) + "LastName".PadLeft(21) + "\n");
           foreach (DataRow row in dtc[1].Rows){
              Console.WriteLine("{0}\t{1}", row["FirstName"].ToString().PadRight(25),
                 row["LastName"]);
           }
        } catch(Exception e) {
           Console.WriteLine("Error: " + e);
        } finally {
           conn.Close();
        }
     }
  }
  
  
 </source>