Powershell
17-Dec-1212 Leave a comment
Have used:
- dir
- dir somen* will change to somename
- copy-item
- Write-Host “Hello World”
- Write-Host gives you a new line
- Read-Host “Press a Key”
- $result = New-Object …
- To comment out use #
- To comment out a block use <# … #>
- foreach ($var in $enumerable)
{
<code here>
}
Powershell against SQL
$conn = New-Object System.Data.SqlClient.SqlConnection $conn.ConnectionString = "Data Source=(local);Initial Catalog=<dbname>;Integrated Security=True;" $conn.Open() $cmd = New-Object System.Data.SqlClient.SqlCommand $cmd.connection = $conn $cmd.commandtext = "SELECT ID, Title FROM Film.Films WHERE Title LIKE 'G%'" $adapter = New-Object System.Data.SqlClient.SqlDataAdapter $adapter.SelectCommand = $cmd $dataset1 = New-Object System.Data.DataSet $rowCount = $adapter.Fill($dataset1) #Write-Host $dataset1.Tables[0].Rows.Count foreach ($row in $dataset1.Tables[0]) { Write-Host $row['Title'].ToString() }
Tips
double-click on text with mouse selects it. Then right-click puts it in clipboard. Then go to new location in PowerShell and then right-click will paste it.