public void btnAdd_Click()
{
try
{
Employee employee = new Employee();
employee.ID = Convert.ToInt32(presenter1.crudFormView.txtID.Text);
employee.FistName = presenter1.crudFormView.txtFirstName.Text;
employee.LastName = presenter1.crudFormView.txtLastName.Text;
employee.Sex = presenter1.crudFormView.txtSex.Text;
employee.Age = Convert.ToInt32(presenter1.crudFormView.txtAge.Text);
IDBManager db = new MySQLDBManager();
db.AddEmployee(employee);
BindingSource bindingsource = new BindingSource();
presenter1.crudFormView.dataGridView1.DataSource = null;
presenter1.crudFormView.dataGridView1.DataSource = bindingsource;
presenter1.crudFormView.dataGridView1.Refresh();
con = new MySqlConnection();
con.ConnectionString = @"datasource=127.0.0.1;port=3306;username=root;password=;database=assigment1;Convert Zero Datetime=True;";
con.Open();
adapt = new MySqlDataAdapter("select id,first_name,last_name,sex,age from employees", con);
ds = new System.Data.DataSet();
adapt.Fill(ds, "Employee_Details");
presenter1.crudFormView.dataGridView1.DataSource = ds.Tables[0];
MessageBox.Show("Created!", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}