Using Boolean Values

[Paul]

Let's say I have a SPROC that returns a boolean value:
PROCEDURE [DBO].[StoreHasOwnMast erPageBool]
(
@StoreID int
)
AS
SET NOCOUNT ON;
SELECT HasOwnMasterPag e
FROM dbo.Stores
WHERE (StoreID = @StoreID)

Where the Column HasOwnMasterPag e is of type Boolean in SQL Server 2005.

In my XSD file, StorePresentati onDS.xsd, I have a TableAdapter called
StoreHasOwnMast erPageBoolTable Adapter, and off this I have a Query (a
GetMethodName) called GetBoolStoreMas terPage. It works.

In my Business Layer, I would like to retrieve a value from that dataset, to
then pass to a code-behind of an aspx page.
I guess that I could code something like this:
Public Function HasOwnMasterPag e(ByVal StoreID As Integer) As Boolean

Dim StoreMasterPage Bool As New
StorePresentati onDSTableAdapte rs.StoreHasOwnM asterPageBoolTa bleAdapter

If StoreMasterPage Bool.ToString = "True" Then

Return True

Else

Return False

End If

End Function

----
But is there something better? What is it best way to treat a boolean result
of a Stored Procedure? Somehow going from Bool to string looks wastful.

TIA, (I love this stuff, but wish I knew more)

Paul