| //Establish Oracle DB connection. |
| int connectionCounter = 0; |
| bool boolUpdateData = true; |
| while (boolUpdateData && connectionCounter < 3) |
| { |
| try |
| { |
| localConnection = new OracleConnection(localFunction.localConnectionString); |
| localConnection.Open(); |
| |
| boolUpdateData = false; |
| } |
| catch (Exception localException) |
| { |
| localFunction.WriteEventLog(localException.ToString(), "OPCAlarmConfig"); |
| } |
| connectionCounter++; |
| } |
| |
| //??? |
| OleDbDataAdapter da = new OleDbDataAdapter(); |
| oleda.SelectCommand = cmd; |
| OleDbCommandBuilder cb = new OleDbCommandBuilder(da); |
| oleda.Fill(ds); |
| excelGridView.DataSource = ds.Tables[0]; |
| oleda.Update(ds); |