C # query Oracle stored procedures through OleDb,

C # query Oracle stored procedures through OleDb,

using System;using System.Data;using System.Data.OleDb;

　　

/// <Summary> /// query the Oracle stored procedure through OleDb /// </summary> /// <param name = "id"> </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 ))) (CONNECT_DATA = (SERVICE_NAME = orcl); Persist Security Info = True; Extended Properties = 'plsqlrset = 1 ';"; // 'plsqlrset = 1' 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", OleDbType. 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];}