I've populated the datagridview with an excel sheet and now i want to update the datagridview to a similiar table at Oracle DB.
I have establish a connection with the Oracle database...wher e should i proceed to do next?
Any help or advice is appreciated.
Code:
private void updateOracleBtn_Click(object sender, EventArgs e)
{
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++;
}
}
Any help or advice is appreciated.