3
Answers

how to update userid and password using c# windowsform

hi guys im a new bie in programming and im maiking a project in which i want the user to be ableto change hes user id and password but im nt able to do it ,can ull plz help
this is my code:

private void button1_Click(object sender, EventArgs e)
  {
  try
  {
  OleDbCommand command = new OleDbCommand();

  string query = "select UserName from UserTable  where Password='"+ textBox2.Text +"'";

  command.CommandText = query;

  OleDbDataReader reader = command.ExecuteReader();

  if (reader.Read())
  {
  // string a= Convert.ToString(textBox1.Text);
  //string b = Convert.ToString(textBox2.Text);

  string UserName=reader["UserName"].ToString();
  string Password = reader["Password_U"].ToString();

  if (textBox1.Text== UserName)
  {
  connect.Open();
  command.CommandText = "update UserTable set UserName ='" + textBox4.Text + "'"; //where ManagerName = [Julius Fernandes]";

  command.ExecuteNonQuery();
  connect.Close();
 
  }

  if (textBox2.Text == Password)
  {
  connect.Open();
  command.CommandText = "update UserTable set Password_U ='" + textBox5.Text + "'";// where ManagerName = [Julius Fernandes]";

  command.ExecuteNonQuery();
  connect.Close();
 
  }
 
  }
  }

  catch (Exception ex)
  {
  MessageBox.Show("Invalid UserId or Password,Please Fill the Fields Correctly" + ex);
  connect.Close();

  }
  }
  }
}
Answers (3)