Name Space: SYSTEM.DATA. OracleClientC # Connect Oracle String: String Constr = "User ID = User Name; Password = Password; Data Source = Service Name"; Oracle Returns a Record Set Storage Process: 1. Define Cursor Type TableScursor Is Ref Cursor; 2. custom stored procedures Create or Replace procedure stored procedure name (pCursor out tablesCursor) is begin open pCursor for select * from tables; end the stored procedure name; C # to call a stored procedure OracleCommand oraCmd = new OracleCommand (); oraCmd.CommandText = "stored procedure name"; oraCmd.CommandType = CommandType.StoredProcedure; OracleParameter cursor = new OracleParameter ( "pCursor", OracleType.Cursor, 2000, ParameterDirection.Output, true, 0,0, "", DataRowVersion.Default, Convert.DBNull Oracmd.Parameters.Add (CURSOR);
oracleDataAdapter1.SelectCommand.Connection.Open (); oracleDataAdapter1.Fill (dataSet1, "person"); dataGrid1.DataSource = dataSet1.Tables [ "person"]; //dataGrid1.DataMember=person; oracleDataAdapter1.SelectCommand.Connection.Close ( );
