一段简单的访问数据库查询数据的代码:
$sqlServer = "192.168.0.1/SQLExpress"
$database = "DBDemo"
$saPassword = ******"
$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 * FROM [DBDemo].[DBO].[TableName]"
$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]
}
插入数据
# $sqlCmd = New-Object System.Data.SqlClient.SqlCommand
# $sqlCmd.CommandText = "INSERT INTO [DBDemo].[DBO].[TableName] ([Kye1], [Kye2], [Kye3], [key4]) VALUES ('$value1', '$value2, '$value3, '$value4)"
$sqlCmd.Connection = $sqlConnection
$sqlCmd.ExecuteNonQuery()