C#

// Declaring and initializing to an empty dataview
DataView dv = new DataView(); 

// Chucking the DataView you just initialized and doing it again
dv = new DataView(ds.Tables["Query5"], "EVENT_DATE='14/10/2005'","",DataViewRowState.CurrentRows);

using System;
using System.Data;

class Class1
{
	/// <summary>
	/// The main entry point for the application.
	/// </summary>
	[STAThread]
	static void Main(string[] args)
	{
		
		DataTable t1 = new DataTable();
		t1.Columns.Add("Age", typeof(int));
		t1.Columns.Add("Name", typeof(string));
		t1.Columns.Add("SomeLetter", typeof(string));

                // Fills the first table with useless data
		for (int x=0; x<10; x++)
		{
			DataRow row = t1.NewRow();
			row[0] = 10-x;
			row[1] = "John " + x.ToString();
			row[2] = new string((char)(65 + x), x + 1);
			t1.Rows.Add(row);
		}

		// Surfaces a filtered, sorted view of table t1
		DataView view = new DataView(t1, "Age > 5", "Age DESC", DataViewRowState.CurrentRows);

		// Create a new table to receive copies.
		DataTable t2 = new DataTable();
		t2.Columns.Add("Age", typeof(int));
		t2.Columns.Add("Name", typeof(string));
		t2.Columns.Add("SomeLetter", typeof(string));

                // Copies the rows from the DataView to the new Table in 
                // sorted order.
		for(int p = 0, pc = view.Count; p<pc; p++)
		{
			DataRow newRow = t2.NewRow();

			DataRowView rowV = view[p];
			newRow.ItemArray = rowV.Row.ItemArray;
			t2.Rows.Add(newRow);
		}

		Console.ReadLine();
	}
}