private bool AddSotrudniki()
{      
          
	OleDbConnection myCons = new OleDbConnection ( strCon );

if( textFam.Text != "" && textIm.Text != "" && textOtch.Text != "" &&
 textVozr.Text != "" && textBPlace.Text != "" && textTel.Text != ""&&
textStag.Text != "" && textZp.Text != "" && comboBL.Text !="" && comboOtd.Text !="" )
			
{
				
//the string to get values from the  textboxes and form an "INSERT INTO"
				// statement.
string sqlStr = "INSERT INTO Сотрудники (Фамилия, Имя, Отчество, Возраст, Место рождения, Телефон, Стаж, Отдел,Зарплата) VALUES ( '";
				sqlStr += ToSQL(textFam.Text) + "', '";
				sqlStr += ToSQL(textIm.Text) + "', '";
				sqlStr += ToSQL(textOtch.Text) + "', ";
				sqlStr += ToSQL(textVozr.Text) + ", '";
				sqlStr += ToSQL(textBPlace.Text) + "', ";
				sqlStr += ToSQL(textTel.Text) + ", ";
				sqlStr += ToSQL(textStag.Text) + ", ";
				sqlStr += ToSQL(textZp.Text) + ", '";
				sqlStr += ToSQL(comboOtd.Text) + "', '";
				sqlStr += ToSQL(comboBL.Text) + "')" ;
				OleDbCommand myCmds = new OleDbCommand( sqlStr , myCons ) ;
				try
				{
					myCons.Open();
					//Execute the statement 
					myCmds.ExecuteNonQuery();
					statusAdd.Text="Data added to database" ;
					//reset all the textboxes
					//int recordCount =int.Parse( t_bookid.Text );
					//recordCount++ ;
					textFam.Text="" ;
					textIm.Text="" ;
					textOtch.Text="" ;
					textVozr.Text="" ;
					textBPlace.Text="" ;
					textTel.Text="" ;
					textStag.Text="" ;
					textZp.Text="" ;
					comboOtd.Text="";
					comboBL.Text="" ;
					statusAdd.Text="Connected - Now you can add records";
				}
				
				catch( Exception ed )
				{
					MessageBox.Show("Error in inserting! "+ed.ToString(), "Error");
				}
			
				finally
				{
					myCmds.Dispose();
					myCons.Close() ;
					myCons.Dispose();
				}
			}
			else
			{
				MessageBox.Show("All fields must be completed.", "Error");
			}
			
			 
			
			return true;
		}
		private string ToSQL( string input )
		{
			return input.Replace( "'" , "''" ); 
		}