C#

DELIMITER $$
DROP PROCEDURE IF EXISTS `SP_NewPassLogin` $$
CREATE PROCEDURE SP_NewPassLogin (IN val_login VARCHAR(15), IN val_password VARCHAR(30))
BEGIN
DECLARE excessao SMALLINT DEFAULT 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET excessao = 1;
IF (val_login <> '' AND val_password <> '') THEN
START TRANSACTION;
UPDATE tbl_user SET password = val_password WHERE login = val_login;
IF excessao = 1 THEN
SELECT 'erro' AS Msg;
ROLLBACK;
ELSE
SELECT 'ok' AS Msg;
COMMIT;
END IF;
END IF;
END$$
DELIMITER;

private void btnSave_Click(object sender, EventArgs e)
        {
         using (MySqlConnection conexaoMySQL = Conexaodb.getInstancia().getConexao())
            {
                try
                {
                    conexaoMySQL.Open();
                    MySqlCommand cmd = new MySqlCommand("SP_NewPassLogin", conexaoMySQL);
                    cmd.CommandType = CommandType.StoredProcedure;
                    //this is the class that gets the login name so that the User can enter a password if the bank is NULL
                    cmd.Parameters.AddWithValue("val_login", frmLogin.NomeLogin.NomeUsuario.ToLower());
                    cmd.Parameters.AddWithValue("val_password", txtPassword.Text);
                    string retorno = cmd.ExecuteScalar().ToString();
                    if (retorno == "ok")
                    {
                        MessageBox.Show("Dados atualizados com sucesso!", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        this.Close();
                    }
                    else if (retorno == "erro")
                    {
                        MessageBox.Show("Informações Inválidas!", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Houve problemas. Erro: \n\n" + ex.Message);
                }
                finally
                {
                    if (conexaoMySQL.State == ConnectionState.Open) conexaoMySQL.Close();
                }
            }
}

string Con = ConfigurationManager.ConnectionStrings["myCon"].ConnectionString;
            using (OleDbConnection OleCon = new OleDbConnection())
            {
                OleCon.ConnectionString = Con;
                OleCon.Open();
                using (OleDbDataAdapter a = new OleDbDataAdapter("SELECT * FROM CustomerTable", OleCon))
                {
                    // Use DataAdapter to fill DataTable
                    DataTable myDataTable = new DataTable();
                    a.Fill(myDataTable);                  
                }
            } 
int i =1;

while(i<myDataTable.Count)
{
  //Do Something

 i++;
}  

List<RadioButton> List2 = new List<RadioButton>();
List<RadioButton> List1 = new List<RadioButton>();

            //Add a dummy value to first index
            List1.Add(0,null);
            List1.Add(1,RadioButton1);
            List1.Add(2,RadioButton2);
            List1.Add(3,RadioButton3);
            List1.Add(4,RadioButton4);

//Generate random List index 
int listIndex = RandNum.Next(1, 4);

int i=1;
while(i<List1.Count)
{
//Check if the radiobutton at index of Listindex in List1 is in List2
 if (!List2.Contains(List1(listIndex )))
     {
       //If radiobutton did not exist in List2, add it to List2
       List2.Add(List1(listIndex ));                               
       i++;
     }
}