Code: Select all
$buttonAddData_Click={
#TODO: Place custom script here
$name = $textbox1.Text
$LastName = $textbox2.Text
$DisplayName = $textbox3.Text
$insertquery = "
INSERT INTO [dbo].[Play]
([FirstName]
,[LastName]
,[DisplayName])
VALUES
('$name'
,'$LastName'
,'$displayname')
GO
"
Invoke-SQLcmd -ServerInstance 'W10-PC-HOME' -query $insertquery -U sa -P Year2000 -Database Playpen
$results = Invoke-Sqlcmd -ServerInstance "W10-PC-HOME" -Database "Playpen" -Query "SELECT * FROM Play"
$Results = Invoke-Sqlcmd -ServerInstance localhost -Database playpen -Query "SELECT * As Names FROM Play" | ForEach-Object {
$($_.Names)
}
# Display the results of the SQL Query
$datagridview1.Rows.Add($Results)
}
Product, version and build: 5.6.163
32 or 64 bit version of product: 64
Operating system: Windows 10
32 or 64 bit OS: 64Bit