Создай в Access таблицу "Employess(firstName,lastName,idNumber,Years)"



private void B_Enter_Click(object sender, System.EventArgs e)
{
int temp;

string sql="insert into Employess(firstName,lastName,idNumber,Years)
values('"+T_Name.Text+"' , '"+T_Family.Text+"' ,
'"+T_Id.Text+"' , "+T_Years.Text+" )";

oleDbCommand1.CommandText=sql;
oleDbCommand1.Connection=oleDbConnection1;

oleDbConnection1.Open();
temp=oleDbCommand1.ExecuteNonQuery();

if(temp==1)
L_text.Text="Yes";
else L_text.Text="No";

oleDbConnection1.Close();
T_Name.Text=""; // TextBox
T_Family.Text="";
T_Id.Text="";
T_Years.Text="";
}


код нажатия кнопки для внесения инфы в таблицу