コード例 #1
0
        public void ODBC_ExecuteSqlGetDataTable()
        {
            StringBuilder    builder       = new StringBuilder();
            SqlAndParameters sqlParameters = new SqlAndParameters();

            System.Data.DataTable table = null;


            builder.Append("Select * from c02 where CFB='' and CF=1 ");

            sqlParameters.Sql = builder.ToString();

            table = queryBuilder.ExecuteSqlGetDataTable(sqlParameters);

            Assert.IsTrue(table.Rows.Count > 0);
        }
コード例 #2
0
        public void ExecuteSqlGetDataTable()
        {
            string           sql           = "select * from Aluno";
            List <Parameter> parameters    = new List <Parameter>();
            SqlAndParameters sqlParameters = new SqlAndParameters();

            System.Data.DataTable table = null;



            sqlParameters.Sql = sql;


            table = queryBuilder.ExecuteSqlGetDataTable(sqlParameters);

            Console.WriteLine(table.Rows.Count);

            Assert.IsTrue(table.Rows.Count > 0);
        }