Create DataView through DataTable : DataView : Database C# Source Code

    

using System;
using System.Data;
using System.Data.SqlClient;

   class DataViewExample
   {
      static void Main()
      {
         string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
         string sql = @"select * from employee";
         SqlConnection conn = new SqlConnection(connString);

         try {
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = new SqlCommand(sql, conn);

            DataSet ds = new DataSet();
            da.Fill(ds, "employee");

            DataTable dt = ds.Tables["employee"];

            DataView dv = new DataView(dt,"lastname = 'Z'", "lastname", DataViewRowState.CurrentRows);

            foreach (DataRowView drv in dv)
            {
               for (int i = 0; i < dv.Table.Columns.Count; i++){
                  Console.Write(drv[i] + "\t");
               }   
            }
         }
         catch(Exception e)
         {
            Console.WriteLine("Error: " + e);
         }
         finally
         {
            conn.Close();
         }
      }
   }