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