private void B_R_Register_Click(object sender, EventArgs e) { // OleDbDataReader myDR; try { myConn.ConnectionString = connectionDetails.establish_Connection; OleDbCommand myCmd = myConn.CreateCommand(); //This (more efficient) alternative uses stream-mode ADO.NET // SQL Insert command myCmd.CommandText = "INSERT INTO Customer(FirstName, LastName, DateOfBirth, Email,[Password])" + " VALUES (@firstname, @lastname, @dateofbirth, @email,@password);"; myCmd.Parameters.AddWithValue("firstname", T_R_FirstName.Text); myCmd.Parameters.AddWithValue("lastname", T_R_LastName.Text); myCmd.Parameters.AddWithValue("dateofbirth", T_R_dateOfBirth.Text); myCmd.Parameters.AddWithValue("email", T_R_Email.Text); myCmd.Parameters.AddWithValue("password", T_R_Password.Text); myConn.Open(); myCmd.ExecuteNonQuery(); myConn.Close(); MessageBox.Show("Welcome " + T_R_FirstName.Text + " To a world of Music!"); Login_Form login = new Login_Form(); this.Visible = false; login.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void B_S_LogOff_Click(object sender, EventArgs e) { MessageBox.Show("You have logged off!!"); Login_Form login = new Login_Form(); this.Visible = false; login.Show(); }