public DataTable GetDataTable(string memberCode)
{
string cmd = @"SELECT [ID]
,[borrowerNumber]
,[bookNumber]
,[date]
,[status]
FROM [Library].[dbo].[Reservation]
WHERE [borrowerNumber] = " + memberCode;
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select * from Book";
return(DAO.GetDataTable(cmd));
}
public DataTable FilterMembers()
{
string cmd = "select * from Borrower ORDER BY borrowerNumber";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select * from CirculatedCopy";
return(DAO.GetDataTable(cmd));
}
