Powershell SQL results comeback in hashtable i just need the value

Question

I have the following script that runs a stored procedure and returns a value. The problem is it returns a hash table and using result.answer returns nothing. How can I get the value without the hash table attached?

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server=server;Database=AspDotNetStoreFront;Integrated Security=True"
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = "exec dbo.[sp_ESC_CheckForOrderingIssues] 1"
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)
$SqlConnection.Close()
$Result = $DataSet.Tables[0]
$Result
If ($Result -eq 1 )
{PANIC}
else {Dont Panic}

Answer 1

This is the only way i could get it to work.

$Result = $DataSet.Tables[0] |
  select column1 $Result = $Result | 
    ConvertTo-Csv 
$Result = $Result[2] 
[int]$Result = $Result -replace ('"',' ') 
$Result If ($Result -eq 2)

If anyone knows a better way I would like to hear about it.