第一种查询数据存储到DataSet中:
$sqlServer = "localhost"
$database = "DVRS"
$saPassword = "Tyco0101"
$sqlConnection = New-Object System.Data.SqlClient.SqlConnection
$cnnString = "Server=$sqlServer;Database=$database;User ID=sa;Password=$saPassword;Trusted_Connection=False"
$sqlConnection.ConnectionString = $cnnString
$sqlCmd = New-Object System.Data.SqlClient.SqlCommand
$sqlCmd.Connection = $sqlConnection
$sqlCmd.Connection.Open()
$sqlCmd.CommandText = "SELECT Top 10 GETDATE() FROM [DVRS].[dbo].[calllog]"
$adapter = New-Object System.Data.SqlClient.SqlDataAdapter $sqlCmd
$dataset = New-Object System.Data.DataSet
$adapter.Fill($dataSet)
$sqlConnection.Close()
for ($i=0; $i -lt $dataSet.Tables[0].Rows.Count; $i++)
{
$data= $dataSet.Tables[0].Rows[$i][0]
}
<