Filter sort based on DataTableCollection : DataTable « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. DataTable

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



           
         
  

Related examples in the same category