# Define input parameters
$ProductName = Read-Host "Enter product name"
$ProductCode = Read-Host "Enter product code"
$Quantity = Read-Host "Enter quantity"

# Create SqlConnection object, define connection string, and open connection
$con = New-Object System.Data.SqlClient.SqlConnection
$con.ConnectionString = "Server=.; Database=AdventureWorks;
  Integrated Security=true"
$con.Open()

# Create SqlCommand object, define command text, and set the connection
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.CommandText = "INSERT INTO Production.Inventory
  (ProductName, ProductCode, Quantity)
  VALUES (@ProductName, @ProductCode, @Quantity)"
$cmd.Connection = $con

# Add parameters to pass values to the INSERT statement
$cmd.Parameters.AddWithValue("@ProductName", $ProductName) | Out-Null
$cmd.Parameters.AddWithValue("@ProductCode", $ProductCode) | Out-Null
$cmd.Parameters.AddWithValue("@Quantity", $Quantity) | Out-Null

# Execute INSERT statement
$RowsInserted = $cmd.ExecuteNonQuery()

Write-Host

# Display the number of rows inserted
Write-Host Number of rows inserted: $RowsInserted 

Write-Host

# Close the connection
$con.Close()