how to return the datatable from stored procedure in oracle by using c#

Question

Muralidharan Deenathayalan · Answer

OracleConnection con = new OracleConnection(connectionstring); con.Open() OracleCommand cmd = new OracleCommand(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText =SPName; //add parameters here... OracleDataAdapter adap = new OracleDataAdapter(); adap.SelectCommand = cmd; DataSet ds = new DataSet(); adap.Fill(ds); if (ds.Tables.Count > 0) { return ds.Tables[0]; //this will return the first data from the sp execution. } I'm not tested the code in system please test it once.