public static FORMAdjustments Instance()
{
if (sForm == null)
{
sForm = new FORMAdjustments();
}
return(sForm);
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose(disposing);
sForm = null;
}
private void FORMAdjustments_Load(object sender, System.EventArgs e)
{
//Set Images
setImages();
//Set the Data Adapter
daAdjustList = new OleDbDataAdapter("", clsConnections.CN);
setTabControl();
loadBooks("SELECT tblCategory.CategoryName, tblBooks.BookNo, tblBooks.ISBN, tblBooks.BookTitle, tblBooks.Qty, tblBooks.Barrowed, ([Qty])-([Barrowed]) AS Available FROM tblCategory RIGHT JOIN tblBooks ON tblCategory.IndexCategory = tblBooks.CategoryIndex ORDER BY tblBooks.BookNo ASC");
publicAdjustList = this;
}