Help!!
I'm trying to convert a visual basic stand alone program
into a Web Program using C#. There are a lot of Oracle
packages already written that I am trying to use
(unsuccessfully ). Can someone point me in the right
direction on how to call an Oracle package into a
datagrid??
something like:
cnn.Open();
string sSelect = "{CALL DRM.PKG.LIST(?) }";
OracleCommand selectCommand = new OracleCommand(s Select ,
cnn);
selectCommand.C ommandType = CommandType.Sto redProcedure;
OracleParameter prm1 = new OracleParameter ();
prm1 = selectCommand.P arameters.Add(" prm_1",
OracleType.Int1 6);
prm1.Direction = ParameterDirect ion.Output;
prm1.Value = 0;
OracleDataReade r dr = selectCommand.E xecuteReader();
DataGrid1.DataS ource = dr;
DataGrid1.DataB ind();
Thanks Jeff.
I'm trying to convert a visual basic stand alone program
into a Web Program using C#. There are a lot of Oracle
packages already written that I am trying to use
(unsuccessfully ). Can someone point me in the right
direction on how to call an Oracle package into a
datagrid??
something like:
cnn.Open();
string sSelect = "{CALL DRM.PKG.LIST(?) }";
OracleCommand selectCommand = new OracleCommand(s Select ,
cnn);
selectCommand.C ommandType = CommandType.Sto redProcedure;
OracleParameter prm1 = new OracleParameter ();
prm1 = selectCommand.P arameters.Add(" prm_1",
OracleType.Int1 6);
prm1.Direction = ParameterDirect ion.Output;
prm1.Value = 0;
OracleDataReade r dr = selectCommand.E xecuteReader();
DataGrid1.DataS ource = dr;
DataGrid1.DataB ind();
Thanks Jeff.
Comment