Database Oracle Functions

        StaticOracleConnection mqracleconnecting =NULL;  Public Staticoracleconnection qracleconnecting {Get            {                Try                {                    if(Mqracleconnecting = =NULL) mqracleconnecting=NewOracleConnection (JKSG); if(Mqracleconnecting.state! =ConnectionState.Open) Mqracleconnecting.open (); returnmqracleconnecting; }                Catch(Exception) {return NULL; }            }        }         Public StaticDataTable dbgetdatatable (stringSqlstringconn) {DataTable DataSet=NewDataTable (); OracleDataAdapter Orada=Neworacledataadapter (SQL, conn);            Orada.fill (DataSet); returnDataSet; }         Public StaticDataTable dbgetdatatable (stringSQL, OracleConnection conn) {DataTable DataSet=NewDataTable (); OracleDataAdapter Orada=Neworacledataadapter (SQL, conn);            Orada.fill (DataSet); returnDataSet; }        //executes the SQL statement, returning the number of rows affected         Public Static intExecuteSQL (stringSQL) {            intCMD =0; OracleCommand command=Neworaclecommand (SQL, qracleconnecting); Try{CMD=command.            ExecuteNonQuery (); }            Catch            {            }            returnCMD; }          Public Static intExecutesql_update (stringSQL) {OracleDataAdapter Orada=Neworacledataadapter (SQL, qracleconnecting); returnOraDA.UpdateCommand.ExecuteNonQuery (); }         Public Static intExecutesql_insert (stringSQL) {OracleDataAdapter Orada=Neworacledataadapter (SQL, qracleconnecting); returnOraDA.InsertCommand.ExecuteNonQuery (); }

Database Oracle Functions