Filter sort based on DataTableCollection

   
 
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) + "
");

            string fl = "FirstName = 'Z'";
            string srt = "LastName asc";
            foreach (DataRow row in dtc["Employee"].Select(fl, srt))
            {
               Console.WriteLine(
                  "{0}	{1}", 
                  row["FirstName"].ToString().PadRight(25),
                  row["LastName"]);
            }

            Console.WriteLine("Results from Products table:");
            Console.WriteLine("FirstName".PadRight(20) + "LastName".PadLeft(21) + "
");

            foreach (DataRow row in dtc[1].Rows){
               Console.WriteLine("{0}	{1}", row["FirstName"].ToString().PadRight(25),
                  row["LastName"]);
            }
         } catch(Exception e) {
            Console.WriteLine("Error: " + e);
         } finally {
            conn.Close();
         }
      }
   }