try { myOracleConnection = gcnew OracleConnection("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=1.1.1.1)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SCDB)));User Id=user;Password=pw;"); myOracleConnection->Open(); myTransaction = myOracleConnection->BeginTransaction(); myDataAdapter = gcnew OracleDataAdapter(); selectionString = "select * from db.tablename FOR UPDATE"; OracleCommand ^selectCommand = gcnew OracleCommand(selectionString); myDataAdapter->SelectCommand = selectCommand; myDataAdapter->SelectCommand->Transaction = myTransaction; myDataAdapter->SelectCommand->Connection = myOracleConnection; myDataAdapter->SelectCommand->ExecuteNonQuery(); myDataSet = gcnew DataSet("sample"); myDataAdapter->FillSchema(myDataSet,SchemaType::Source, "pele_misc"); myDataAdapter->Fill (myDataSet,"pele_misc"); dt = myDataSet->Tables["pele_misc"]; myDataSet->WriteXml("G:/data10.xml"); updateString = "update db.tablename set value = 'http://www.yahoo.co.in' where name like 'XEN_SUPPORT_URL'"; OracleCommand ^updateCommand = gcnew OracleCommand(updateString); updateCommand->Connection = myOracleConnection; myDataAdapter->UpdateCommand = updateCommand; myDataAdapter->UpdateCommand->Transaction = myTransaction; myDataAdapter->UpdateCommand->ExecuteNonQuery(); System::Threading::Thread::Sleep(20000); myTransaction->Commit(); } catch(Exception ^ e) { myTransaction->Rollback(); Console::Write(e->ToString () ); } __finally { myOracleConnection->Close(); }
MSDN:ExecuteNonQuery returns no rows
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)