DataTable 및 foreach

DataTable dt = new DataTable();

dt.Columns.Add("EMPLOYEE_ID", typeof(int));
dt.Columns.Add("FIRST_NAME", typeof(string));
dt.Columns.Add("LAST_NAME", typeof(string));
dt.Columns.Add("HIRE_DATE", typeof(DateTime));
dt.Columns.Add("SALARY", typeof(int));

dt.Rows.Add(100, "Steven", "King", "2003-06-17", 24000);
dt.Rows.Add(101, "Neena", "Kochhar", "2005-09-21", 17000);
dt.Rows.Add(102, "Lex", "De Haan", "2001-01-13", 17000);
dt.Rows.Add(103, "John", "Chen", "2006-01-03", 9000);
dt.Rows.Add(104, "Bruce", "Ernst", "2007-05-21", 6000);

foreach (DataRow row in dt.Rows)
{
    string employeeId = row["EMPLOYEE_ID"].ToString();
    string firstName = row["FIRST_NAME"].ToString();
    string lastName = row["LAST_NAME"].ToString();  
}

 

참조 사이트 : https://gent.tistory.com/314

 

 

DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("Id", typeof(int)));
            dt.Columns.Add(new DataColumn("Message", typeof(string)));

            DataRow row = null;
            row = dt.NewRow();
            row["Id"] = 1;
            row["Message"] = "some message";
            dt.Rows.Add(row);

            row = dt.NewRow();
            row["Id"] = 2;
            row["Message"] = "some message2";
            dt.Rows.Add(row);

  

            var focusPackingNo = (  from dt in mergeOrderInfo.AsEnumerable()
                                    select new
                                    {
                                        packing_no = dt.Field("packing_no")
                                    }).Distinct();