C# (CSharp) ExcelExportorForWin ExportToExcelの例

コード例 #1

        private void btnExport_Click(object sender, EventArgs e)
        {
            ExportToExcel ee = new ExportToExcel();

            var mp = yltl.Common.ConfigHelper <MappingGroup> .ReloadFile();

            var dbo = yltl.DBUtility.DBFactory.Create(yltl.DBUtility.eDBType.Oracle, "Data Source=lan_189;User ID=user_ahdy_shi;Password=user_ahdy_shi");

            var dt = dbo.GetDataTable("select * from sys_dept");

            ee.Export(mp.Maps[0], dt);
        }

コード例 #2

ファイル: Form1.cs プロジェクト: howbigbobo/DailyCode

        private void btnExport_Click(object sender, EventArgs e)
        {
            ExportToExcel ee = new ExportToExcel();

            var mp = yltl.Common.ConfigHelper<MappingGroup>.ReloadFile();

            var dbo = yltl.DBUtility.DBFactory.Create(yltl.DBUtility.eDBType.Oracle, "Data Source=lan_189;User ID=user_ahdy_shi;Password=user_ahdy_shi");

            var dt = dbo.GetDataTable("select * from sys_dept");

            ee.Export(mp.Maps[0], dt);
        }