public static FORMLibrarian Instance() { if (sForm == null) { sForm = new FORMLibrarian(); } return(sForm); }
protected override void Dispose(bool disposing) { if (disposing) { if (components != null) { components.Dispose(); } } base.Dispose(disposing); sForm = null; }
private void FORMLibrarian_Load(object sender, System.EventArgs e) { //Set Images setImages(); //Create Directory sFunctions.CreateDirectory("\\@Pictures\\@Librarian"); //Set the Data Adapter daLibrarianList = new OleDbDataAdapter("", clsConnections.CN); //Load List of Librarian loadLibrarians("SELECT tblLibrarian.LibrarianID, [LastName] & ', ' & [FirstName] & ' ' & [MiddleName] AS Fullname, tblLibrarian.StreetAddress, tblZipCodeList.CityTown, tblZipCodeList.Province, tblZipCodeList.ZipCode, tblLibrarian.ContactNo, tblLibrarian.EmailAddress, tblLibrarian.UserName FROM tblZipCodeList RIGHT JOIN tblLibrarian ON tblZipCodeList.ZipCode = tblLibrarian.ZipCode ORDER BY tblLibrarian.LibrarianID ASC"); publcLibrarianList = this; }