datatable Merge()

DataTable 여러개를 합칠때 사용할 수 있는 유용한 함수

 

                DataTable dtTemp = new DataTable();
                DataTable dtResult = new DataTable();

                dtResult.Columns.Add("PRODUCT_ID");
                dtResult.Columns.Add("PRODUCT_NAME");
                dtResult.Columns.Add("PART_ID");
                dtResult.Columns.Add("PART_NAME");
                dtResult.Columns.Add("PART_CNT");

                for (int i = 0; i < iRowCnt; i++)
                {
                    strProductId = TmsUtil.getSpreadCellData(fpPrtList, i, 1);
                    dtTemp = bllWorkOrderMgr.SelectWorkOrderStandBomQry(strProductId).Tables[0];
                    dtResult.Merge(dtTemp);
                }

                fpBomList.DataSource = dtResult;
                fpBomList.DataBind();