My goal for this is to Update a Database table in Oracle with a DataGridView.
I have a datagridview1 containing the same column as the Oracle database.
I stuck @ how to fill the datatable with the DataGridView and Deleting everything from the current Oracle Database and insert the New DataTable.
OracleCommand oraclecmd = new OracleCommand("SELECT * FROM LOCATION", localConnection);
oracleda.SelectCommand = oraclecmd;
DataTable oracledt = new DataTable();
//Fill DataTable with datagridview1
//Delete everything from existing data then insert