Esempi in C# (CSharp) per Sql2Excel

Esempio n. 1

File: Sql2ExcelTests.cs Progetto: theorigin/Sql2Excel

            public void Test()
            {
                var sql2Excel = new Sql2Excel();

                sql2Excel
                    .AddQuery(new Query {Name = "Import", CommandText = "SELECT * FROM Import"})
                    .AddQuery(new Query {Name = "ImportLines", CommandText = "SELECT * FROM ImportLine"})
                    //.Execute()
                    .Save(@"c:\temp\queryoutput.xlsx", true);
            }

Esempio n. 2

            public void Test()
            {
                var sql2Excel = new Sql2Excel();

                sql2Excel
                .AddQuery(new Query {
                    Name = "Import", CommandText = "SELECT * FROM Import"
                })
                .AddQuery(new Query {
                    Name = "ImportLines", CommandText = "SELECT * FROM ImportLine"
                })
                //.Execute()
                .Save(@"c:\temp\queryoutput.xlsx", true);
            }