Posts

Showing posts from April, 2019

Insert update delete using OracleProvider in c#

public class OracleProvider : IDisposable { #region Designer Variables private OracleDataAdapter OrcDataAdapter; #endregion[Designer Variable] #region Constructor public OracleProvider () { OracleConnector oDBConnection = new OracleConnector(); OrcDataAdapter = new OracleDataAdapter(); OrcDataAdapter.SelectCommand = new OracleCommand(); OrcDataAdapter.SelectCommand.Connection = new OracleConnection(OracleConnector.strDataBaseConnectionString); OrcDataAdapter.SelectCommand.Connection.Open(); } #endregion[Constructor] #region Disposing public void Dispose () { Dispose( true ); GC.SuppressFinalize( true ); // as a service to those who might inherit from us } protected virtual void Dispose ( bool disposing ) { if (!disposing) return ; if (OrcDataAdapter != null ) { if (OrcDataAdapter.SelectCommand != null ) { if (OrcDataAdapter.SelectCommand.Connection != null ) ...