DropDownlist Fill with cursor data from table

andreas domevscek

12y1.6kOracle

I have a Oracle stored procedure spGetContinents (cur_continents out t_cursor).

now i want to store data in a drop downlist but how do i do that?

ddlContinents.DataSource =

GetData("CasCadingDropDownList.spGETCONTINENTS", "cur_continents", null);

private DataSet GetData(string spName, string crsName, OracleParameter spParameter)

{

string CS = ConfigurationManager.ConnectionStrings["ConStrNHAOrcl"].ConnectionString;

using (OracleConnection con = new OracleConnection(CS))

{

OracleCommand cmd = new OracleCommand(spName,con);

cmd.Parameters.Add(crsName, OracleType.Cursor).Direction = ParameterDirection.Output;

cmd.CommandType = CommandType.StoredProcedure;

DataSet ds = new DataSet();

OracleDataAdapter da = new OracleDataAdapter();

da.SelectCommand = cmd;

da.Fill(ds);

but it won't work. how can i do this?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Maruthi12y ago
Accepted answer
Hello andreas,

try in this way

DataSet ds = new DataSet();
using (OracleConnection con = new OracleConnection(CS))

{

OracleCommand cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = "spGETCONTINENTS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(crsName, OracleType.Cursor).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
OracleDataAdapter da = new OracleDataAdapter(cmd);
da.Fill(ds);
}
and am confused little bit what parameters do you pass to the stored proc ? if you have more than one parameters to pass just add the parameters to the oraclec ommand in this way:

foreach (OracleParameter param in parameters)
cmd.Parameters.Add(param);

+1
Ramesh Maruthi12y ago
thanks for accepting the answer andreas :)
0
andreas domevscek12y ago
none but i found the answer i had to add return(ds) at last I forgot
but thx anyway for giving me so quick answer!
+1