Powershell连接数据库

最新推荐文章于 2024-02-06 09:14:36 发布

SchenkKim

最新推荐文章于 2024-02-06 09:14:36 发布

阅读量1.5k

点赞数

分类专栏： LINQ & SQL

本文链接：https://blog.csdn.net/Eric_K1m/article/details/38403769

版权

第一种查询数据存储到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]

}
<