private void FORMBooks_View_Load(object sender, System.EventArgs e)
{
lvBooks.SmallImageList = MDIFORM.i16x16;
//Set the Data Adapter
daBooksList = new OleDbDataAdapter("", clsConnections.CN);
loadBooks("SELECT tblBooks.BookNo, tblBooks.ISBN, tblBooks.BookTitle, tblCategory.CategoryName, ([Qty])-([Barrowed]) AS Available FROM tblCategory RIGHT JOIN tblBooks ON tblCategory.IndexCategory = tblBooks.CategoryIndex ORDER BY tblBooks.BookNo ASC");
publicBooksList = this;
this.Refresh();
}
private void bttnBookNO_Click(object sender, System.EventArgs e)
{
FORMBooks_View sForm = new FORMBooks_View();
sForm.ShowDialog();
}
