C# (CSharp) Group4_Lab4.DAL DAOの例

コード例 #1

        public static DataTable GetDataTableCopy()
        {
            string cmd = "select * from Copy";

            return(DAO.GetDataTable(cmd));
        }

コード例 #2

        internal static DataTable GetDataTableReserve(int borrowerNumber)
        {
            string cmd = "SELECT top 1  * FROM [Reservation] where borrowerNumber = " + borrowerNumber + " and status = 'R' order by ID desc";

            return(DAO.GetDataTable(cmd));
        }