using System;

using System.Data;

public class Program

{

    public static void Main()

    {

                    Console.WriteLine("Hello World");

​

            DataSet ds = new DataSet();

            DataTable dt = new DataTable("GlobalCodes");

            dt.Columns.Add(new DataColumn("CodeName", typeof(string)));

            dt.Columns.Add(new DataColumn("Active", typeof(string)));

            dt.Columns.Add(new DataColumn("Category", typeof(string)));

​

            DataRow DataRowDr30 = dt.NewRow();

            DataRowDr30["Category"] = "PHONETYPE";

            DataRowDr30["CodeName"] = "Home";

            DataRowDr30["Active"] = "Y";

            dt.Rows.Add(DataRowDr30);

​

            DataRow DataRowDr31 = dt.NewRow();

            DataRowDr31["Category"] = "PHONETYPE";

            DataRowDr31["CodeName"] = "Business";

            DataRowDr31["Active"] = "Y";

            dt.Rows.Add(DataRowDr31);

​

            DataRow DataRowDr32 = dt.NewRow();

            DataRowDr32["Category"] = "PHONETYPE";

            DataRowDr32["CodeName"] = "Home 2";

            DataRowDr32["Active"] = "N";

            dt.Rows.Add(DataRowDr32);

​

            DataRow DataRowDr33 = dt.NewRow();

            DataRowDr33["Category"] = "PHONETYPE";

            DataRowDr33["CodeName"] = "Business 2";

            DataRowDr33["Active"] = "N";

            dt.Rows.Add(DataRowDr33);

​

            DataRow DataRowDr34 = dt.NewRow();

            DataRowDr34["Category"] = "PHONETYPE";

            DataRowDr34["CodeName"] = "Mobile";

            DataRowDr34["Active"] = "Y";

            dt.Rows.Add(DataRowDr34);

​

            DataRow DataRowDr35 = dt.NewRow();

            DataRowDr35["Category"] = "PHONETYPE";

            DataRowDr35["CodeName"] = "Mobile 2";

            DataRowDr35["Active"] = "N";

            dt.Rows.Add(DataRowDr35);

​

            DataRow DataRowDr36 = dt.NewRow();

            DataRowDr36["Category"] = "PHONETYPE";

            DataRowDr36["CodeName"] = "Fax";

            DataRowDr36["Active"] = "N";

            dt.Rows.Add(DataRowDr36);

​

            DataRow DataRowDr37 = dt.NewRow();

            DataRowDr37["Category"] = "PHONETYPE";

            DataRowDr37["CodeName"] = "School";

            DataRowDr37["Active"] = "N";

            dt.Rows.Add(DataRowDr37);

​

            DataRow DataRowDr38 = dt.NewRow();

            DataRowDr38["Category"] = "PHONETYPE";

            DataRowDr38["CodeName"] = "Other";

            DataRowDr38["Active"] = "N";

            dt.Rows.Add(DataRowDr38);

​

​

            ds.Tables.Add(dt);

​

            DataView DataViewGlobalCodes = new DataView(ds.Tables[0]);

            DataViewGlobalCodes.RowFilter = "Category ='PHONETYPE' AND Active = 'Y'";

            for (int i = 0; i < 4; i++)

            {

                Console.WriteLine(DataViewGlobalCodes[i]["CodeName"].ToString());

​

            }

​

​

​

            Console.ReadLine();

    }

}