private void Cancel_Click(object sender, EventArgs e) { Hide(); EmployeeDetails f2 = new EmployeeDetails(); f2.Show(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection vcn = new SqlConnection(); try { int eid = int.Parse(Eid.Text); string fname = Fname.Text; string lname = Lname.Text; int age = int.Parse(Age.Text); string email = Email.Text; long phoneNo = long.Parse(PhoneNo.Text); vcn.ConnectionString = "Data Source=DESKTOP-0KJOSO5;Initial Catalog=master;Integrated Security=True"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "insert into [dbo].[employee_data] values(" + eid + "," + "'" + fname + "'" + "," + "'" + lname + "'" + "," + age + "," + "'" + email + "'" + "," + phoneNo + ")"; cmd.CommandType = CommandType.Text; cmd.Connection = vcn; vcn.Open(); int result = cmd.ExecuteNonQuery(); MessageBox.Show(result.ToString() + "row affected"); Hide(); EmployeeDetails f2 = new EmployeeDetails(); f2.Show(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (vcn.State == ConnectionState.Open) { vcn.Close(); } } }