Testing DataSet and/or DataTable is null

Question

Testing DataSet and/or DataTable is null

Dave Gray 586

Hello

Can anyone please tell me how I can test a DataSet contains at least a .Tables[0] or a DataTable is not null?

For in the mocked up example, where 1=2 is always going to return null and therefore both the commands fail.

In production I would be returning null 99% of the time so I need to test for it and move on when null.

$DS = (Invoke-Sqlcmd -ServerInstance "server" -Username "user" -Password "password" -Database "database" -Query "select 1,2,3 where 1=2" -As DataSet)
$DS.GetType()

$DT = (Invoke-Sqlcmd -ServerInstance "server" -Username "user" -Password "password" -Database "database" -Query "select 1,2,3 where 1=2" -As DataSet).Tables[0]
$DT.GetType()

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Dave Gray 586

The obvious answer is below :-)

if ($DS -ne $null)

Andreas Baumgarten 129.5K Reputation points MVP Volunteer Moderator

2021-04-19T14:58:20.557+00:00
Hi @Dave Gray ,

sorry for being late.

These are "shorter" options to check if a variable is null or not null

# if $a contains someting (any value) if ($a) { # Do something } # if $a is empty/null if (!$a) { # Do something }

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Share via

Testing DataSet and/or DataTable is null

0 additional answers

Your answer