C # Querying Oracle stored procedures through OLE DB

Using system;using system.data;using System.Data.OleDb;

　　

        <summary>///query Oracle stored procedures via OLE///</summary>//<param name= "id" >&            lt;/param>//<returns></returns> public static DataTable gettodolist (string id) { String connString1 = "PROVIDER=ORAOLEDB.ORACLE.1; User id=test; Password=test;data source= (DESCRIPTION = (address_list= (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)) (CONN Ect_data = (service_name = ORCL)); Persist Security info=true; Extended properties= ' plsqlrset=1 ';            /' Plsqlrset=1 ' is important DataSet ds = new DataSet ();            DataTable dt = new DataTable ();            OleDbConnection conn = new OleDbConnection (CONNSTRING1);            OleDbCommand cmd = new OleDbCommand ("Gettodolist", conn);            Cmd.commandtype = CommandType.StoredProcedure; try {Conn.                Open (); Oledbparameter[] parms = {New OleDbParameter ("ID1", OLE DBType.                VarChar)}; Parms[0].                Value = ID; Parms[0].                Direction = ParameterDirection.Input; foreach (OleDbParameter parm in parms) {cmd.                Parameters.Add (Parm);                } OleDbDataAdapter ODA = new OleDbDataAdapter (cmd); Oda.            Fill (DS); } catch (Exception ex) {} finally {cmd.                Dispose (); Conn.            Close (); } return DS.        Tables[0]; }

　　

C # Querying Oracle stored procedures through OLE DB