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

DataTableCollection.Indexer

 
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();
         }
      }
   }