Update DB from datagridview

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • csharp learner
    New Member
    • Feb 2009
    • 8

    #1

    Update DB from datagridview

    I've populated the datagridview with an excel sheet and now i want to update the datagridview to a similiar table at Oracle DB.

    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++;
                    }
    }
    I have establish a connection with the Oracle database...wher e should i proceed to do next?

    Any help or advice is appreciated.
Working...