IT/C#

쿼리에서 DataTable 만들기(LINQ to DataSet)

밤톨순이 2018. 1. 16. 15:30

DataTable dt = db.SPExecuteDataSet("USP_ReportProcessRate_VIEW", oParams).Tables[0];
            IEnumerable<DataRow> query = dt.Select("ReportProcessRateGubun_M='전체' OR ReportProcessRateGubun_M='설계' OR ReportProcessRateGubun_M='구매' OR (ReportProcessRateGubun_M='시공' AND ReportProcessRateGubun_M='전체') OR ReportProcessRateGubun_M='시운전'");
            DataTable boundTable = query.CopyToDataTable<DataRow>();