Re: How to have a stored procedure in Interbase return a result when invoking ExecuteNonQuery in ASP.Net

[Mark Rowe]

I could be wrong about his, however I think you need to use stored functions.


If you are looking at howto return a ScalarValue MyAdapter.[WHatever]Command.ExecuteScalar()

or a cheapie way I used to do it
MySqlCommand SetMySqlSelectCommand = new MySqlCommand(sScalarStatement, conMySqlConnection);
this.adtMyAdapter.SelectCommand = SetMySqlSelectCommand;
this.adtMyAdapter.Fill(dsMyDataSet, "SCALAR");
this.sScalarResult = dsMyDataSet.Tables["SCALAR"].Rows[0][0].ToString().Trim();

It Always returns to the first row first column so [0][0] works, if you need it in int just Int16.Parse(sScalarResult)



Edited 2 time(s). Last edit at 01/22/2007 05:45PM by Mark Rowe.