public void fetchReferenceTableInfowithIdAndCode(String schemaName, String tableName, out DataTable dtRet, out String sID) { DataTable ret = null; String ID = string.Empty; var storedProcedure = new StoredProcedure(); storedProcedure.StoredProcedureName = schema + ".[AdministrativeFunctions.EditReferenceTableForm.Load]"; storedProcedure.Parameters.Add(new StoredProcedureParameter("@schemaName", ParameterType.DBString, schemaName)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@tableName", ParameterType.DBString, tableName)); storedProcedure.ExecuteDataSetWithOutputParam(out ret, out ID); dtRet = ret; sID = ID; }