Connect Oracle in Web.config in Web.config public system.data.OracleClient.OrcleConnection CNN;
/// /// Open database connection /// public void open () {cnn = new oracleConnection (System.configuration.configurationSettings.AppSettings ["Oracle"]); cnn.open (); } /// /// Open the database connection, return CNN /// public oracleConnection OpenCNN () {CNN = New OracleConnection (System.configuration.configurationSettings.AppSettings ["Oracle"]); CNN. Open (); return (CNN);
/// /// Close database connection /// public void close () {cnn.close ();}
/// /// Returns DataSet /// /// /// // / public DataSet GetDataSet (string cmdString, string TableName) {Open (); OracleDataAdapter myDa = new OracleDataAdapter (); myDa.SelectCommand = new OracleCommand (cmdString, cnn); DataSet myDs = new DataSet () Ieda.fill (myds, tablename); close (); return myds;}
/// /// Return OLEDBDataReader /// /// /// public oracleDataReader getDataReader (String cmdstring) {Open (); oracleCommand mycmd = new OracleCommand (cmdstring, cn); oracleDataReader mydr = mycmd.executeReader (); return mydr;}
/// /// Return to the number of rows affecting the database /// /// /// public int executesql (String cmdstring) {open (); oracleCommand mycmd = new OracleCommand (cmdstring, cn); int cmd = mycmd.executenonQuery (); close (); return cmd;} /// /// Bond DRODOWNLIST / // /// Control name /// connection string // table name /// provides data source field /// to provide a value of the list item the data source field public void DroList (DropDownList DroDList, string sql, string TableName, string DataTextFd, string DataValueFd) {Open (); OracleDataAdapter myDa = new OracleDataAdapter (sql, cnn); myDa.SelectCommand.CommandType = CommandType.Text; DataSet myDs = new DataSet (); try {myDa.Fill (myDs, TableName); DroDList.DataSource = myDs.Tables [TableName]; DroDList.DataTextField = DataTextFd; DroDList.DataValueField = DataValueFd; DroDList .DATABIND (); Catch (Exception E) {response.write (E.MESSAGE);} finally {close ();}}
