//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); |