public void displayexcel_Load(object sender, EventArgs e)
        {
            try
            {
                string connString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + gotdirectory + @";Extended Properties=""Excel 8.0;HDR=YES;""";
                OleDbConnection oledbConn = new OleDbConnection(connString);

// Connection to Oracle DB   
 int connectionCounter = 0;   
                bool boolUpdateData = true;   
                while (boolUpdateData && connectionCounter < 3)   
                {   
                    try   
                    {

        private void updateOracleBtn_Click(object sender, EventArgs e)
        {
                int connectionCounter = 0;
                bool boolUpdateData = true;
                while (boolUpdateData && connectionCounter < 3)
                {

        public Boolean validatetext;
        public Boolean validacombobox;


private void locacodeBox_TextChanged(object sender, EventArgs e) 
{
    if (textBox1.Text.Length == 0)
        validatetext = false;
    else
        validatetext = true;
    ValidateButton();

private void locacodeBox_TextChanged(object sender, EventArgs e)
        {
            TextBox textBox = sender as TextBox;
            if (locacodeBox.Text.Length == 0)
                locacodeBox.Tag = false;
            else
                locacodeBox.Tag = true;

 try 
{ 
localSQL = "SELECT table_name FROM user_tables"; 
OracleCommand cmdOracle = new OracleCommand(localSQL, localConnection); 
cmdOracle.CommandType = CommandType.Text;