// DataTableによるメモリ上のデータベース
//
//  2006/ 1/21 宍戸　輝光

using System;
using System.Drawing;
using System.Data;

public class DataTest {

	static void Main() {

		DataTable dtTest = new DataTable();

		dtTest.Columns.Add("No", typeof(Int32));
		dtTest.Columns.Add("Name", typeof(String));

		DataRow drAdd;

		drAdd = dtTest.NewRow();

		drAdd["No"] = 1;
		drAdd["Name"] = "abc";

		dtTest.Rows.Add(drAdd);

		drAdd = dtTest.NewRow();

		drAdd["No"] = 2;
		drAdd["Name"] = "def";

		dtTest.Rows.Add(drAdd);

		drAdd = dtTest.NewRow();

		drAdd["No"] = 3;
		drAdd["Name"] = "ghi";

		dtTest.Rows.Add(drAdd);

		drAdd = dtTest.NewRow();

		drAdd["No"] = 4;
		drAdd["Name"] = "jkl";

		dtTest.Rows.Add(drAdd);

		drAdd = dtTest.NewRow();

		drAdd["No"] = 5;
		drAdd["Name"] = "mno";

		dtTest.Rows.Add(drAdd);

		Console.WriteLine("全データ表示");

		foreach (DataRow drItem in dtTest.Rows) {
			Console.WriteLine("No-" + drItem["No"] + " Name-" + drItem["Name"]);
		}

		DataView dvTest = dtTest.DefaultView;

		dvTest.RowFilter = "No > 3";

		Console.WriteLine("No > 3のデータ表示");

		for (int i = 0;i < dvTest.Count;i++) {
			Console.WriteLine("No-" + dvTest[i]["No"] + " Name-" + dvTest[i]["Name"]);
			
		}

	}

}