Pages

Showing posts with label get parameter value from stored procedure. Show all posts
Showing posts with label get parameter value from stored procedure. Show all posts

Getting parameter value from store procedure using Enterprise library

1)Create object of Database class using dbfactory class and provide connectionstring in constructer 2)Create object DbCommand by calling the GetstoreProc... method from Database class object 3) Call AddInparm..... methods from database class object 4)To Reterive value from a parameter call a getParameter method from database class object convert to corresponding datatype
example bool succes=Convert.ToBoolean( objectDabase. getParmeterobjectCommand,"@statuts")