private void bttnBarrowed_Click(object sender, System.EventArgs e) { FORMBarrowedBooks_Barrowers.sBookNumber = txtBookNO.Text; FORMBarrowedBooks_Barrowers sForm = new FORMBarrowedBooks_Barrowers(); sForm.ShowDialog(); }
private void FORMBarrowedBooks_Barrowers_Load(object sender, System.EventArgs e) { //Set the Icon on Listview. lvBooks.SmallImageList = MDIFORM.i16x16; //Set the Data Adapter daHistory = new OleDbDataAdapter("", clsConnections.CN); //Set the Combo Box sFunctions.FillCombo(cbYear, "SELECT tblSchoolYear.IndexSY, [YearStart] & ' - ' & [YearEnd] AS SY FROM tblSchoolYear ORDER BY [YearStart] & ' - ' & [YearEnd] ASC", "tblSchoolYear", 1); sFunctions.FillCombo(cbLevel, "SELECT * FROM tblLevel ORDER BY LevelName ASC", "tblLevel", 1); //Set to Load Books History loadBooks("SELECT tblBarrowed.BookNo, tblBarrowers.BarrowerID, [LastName] & ', ' & [FirstName] & ' ' & [MiddleName] AS Fullname, tblCourse.CourseName, tblBarrowed.DateBarrowed, tblBarrowed.DateRetured, [YearStart] & ' - ' & [YearEnd] AS SY, tblLevel.LevelName FROM tblSchoolYear RIGHT JOIN (tblLevel RIGHT JOIN (tblCourse RIGHT JOIN (tblBarrowers RIGHT JOIN tblBarrowed ON tblBarrowers.BarrowerID = tblBarrowed.BarrowerID) ON tblCourse.IndexCourse = tblBarrowers.Course) ON tblLevel.IndexLevel = tblBarrowers.LevelIndex) ON tblSchoolYear.IndexSY = tblBarrowers.SchoolYear WHERE [YearStart] & ' - ' & [YearEnd] LIKE '" + cbYear.Text + "' AND tblLevel.LevelName LIKE '" + cbLevel.Text + "' AND tblBarrowed.BookNo LIKE '" + sBookNumber + "' ORDER BY tblBarrowers.BarrowerID ASC"); publicHistory = this; }