private void btnchange_Click(object sender, EventArgs e) { using (SqlConnection con = constr.getconnection()) { con.Open(); string query = "UPDATE userlogins SET pwdchange = @pwdS , password = @pwd WHERE email = @mail "; using (SqlCommand com = new SqlCommand(query, con)) { com.Parameters.AddWithValue("@pwd", txtcnp.Text); com.Parameters.AddWithValue("@pwds", 1); com.Parameters.AddWithValue("mail", loggingform.email); SqlDataAdapter adapter = new SqlDataAdapter(); if (!checkpwd()) { return; } adapter.UpdateCommand = com; adapter.UpdateCommand.ExecuteNonQuery(); MessageBox.Show("password changed"); Thread.Sleep(500); loggingform f = new loggingform(); f.Show(); this.Close(); } } }
private void btnlogout_Click(object sender, EventArgs e) { lastlog last = new lastlog(); last.insertlastlog(DateTime.Now, loggingform.email); loggingform log = new loggingform(); log.Show(); this.Close(); }