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(); }