Not getting Output parameter value
-
Enterprise Library ExecuteDataSet method not setting Output parameter value. The value of output parameter is always null.
using (DbCommand cmd = db.GetStoredProcCommand("s_sProcName"))
{
DataSet ds = new DataSet()
db.AddInParameter(cmd, "@p_sFoo", DbType.String, "Bar");
db.AddOutParameter(cmd, "@po_iOut", DbType.Int32, 4)
ds = db.ExecuteDataSet(cmd);
}How can i get value of Output parameter? Can any one please !!
-
Enterprise Library ExecuteDataSet method not setting Output parameter value. The value of output parameter is always null.
using (DbCommand cmd = db.GetStoredProcCommand("s_sProcName"))
{
DataSet ds = new DataSet()
db.AddInParameter(cmd, "@p_sFoo", DbType.String, "Bar");
db.AddOutParameter(cmd, "@po_iOut", DbType.Int32, 4)
ds = db.ExecuteDataSet(cmd);
}How can i get value of Output parameter? Can any one please !!
You are actually giving it an output value in your SP aren't you? That one's caught me out before!
C# has already designed away most of the tedium of C++.