private void bttnAddNew_Click(object sender, System.EventArgs e) { FORMBarrowedBooks_New.sSY = cbYear.Text; FORMBarrowedBooks_New.sLevel = cbLevel.Text; FORMBarrowedBooks_New sForm = new FORMBarrowedBooks_New(); sForm.ShowDialog(); }
private void FORMBarrowedBooks_New_Load(object sender, System.EventArgs e) { picLOGO.Image = MDIFORM.i32x32.Images[13]; //Set Add OleDbCommand cmdAddBarrowed = new OleDbCommand("INSERT INTO tblBarrowed(BookNo,BarrowerID,DateBarrowed,DateDue,AddedBy,DateAdd) VALUES(@getBookNo,@getBarrowerID,@getDateBarrowed,@getDateDue,@getAddedBy,@getDateAdd)", clsConnections.CN); cmdAddBarrowed.Parameters.Add("@getBookNo", OleDbType.VarChar); cmdAddBarrowed.Parameters.Add("@getBarrowerID", OleDbType.VarChar); cmdAddBarrowed.Parameters.Add("@getDateBarrowed", OleDbType.Date); cmdAddBarrowed.Parameters.Add("@getDateDue", OleDbType.Date); cmdAddBarrowed.Parameters.Add("@getAddedBy", OleDbType.VarChar); cmdAddBarrowed.Parameters.Add("@getDateAdd", OleDbType.Date); publicBarrowedList = this; }