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>();