Re: Stored Procedure Questions

On 8/29/07, Joel Cochran <joelcochran@xxxxxxxxx> wrote:

CREATE PROCEDURE GetCusName()

RESULT SETS 1
LANGUAGE SQL
BEGIN
DECLARE c1 CURSOR WITH RETURN FOR
SELECT cusnam FROM customer ORDER BY cusnam;
OPEN c1;
END

Does anyone have an example of consuming this in .NET? Is it a DataSet or a
IDataReader?

I use the Odbc classes. The sql procedure result set is read as rows
thru the OdbcDataReader class.

OdbcConnection conn = new OdbcConnection( strConn ) ;
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "CALL librayr.ProcedureName(?)";

OdbcParameter parm1 = new OdbcParameter("@SpeedNum", OdbcType.Char, 14);
parm1.Value = "KUE275";
cmd.Parameters.Add(parm1);

OdbcDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
string name = reader.GetString(0);
string order_num = reader.GetString(2);
string[] row = new string[2];
row[0] = name;
row[1] = order_num;
tbl.Rows.Add(row);
}
reader.Close();


.net is by far the best way to write interactive applications for the as400.

-Steve