Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function ReadData {
- Param (
- [string]$username
- )
- $DBServer = "WUSAZEATEQADB01"
- $DBName = "Helpdesk_UserTool"
- $sqlConnection = New-Object System.Data.SqlClient.SqlConnection
- $sqlConnection.ConnectionString = "Server=$DBServer;Database=$DBName;Integrated Security=False;User Id = HelpDesk_User;password = ZECqBDz1"
- $query = "SELECT EmpId FROM Employee WHERE UserName = @un;"
- $sqlCommand = New-Object System.Data.SqlClient.SqlCommand
- $sqlCommand.Connection = $sqlConnection
- $sqlCommand.CommandText = $query
- $sqlCommand.Parameters.Add("@un", $username)
- $sqlConnection.Open()
- $result = $sqlCommand.ExecuteReader()
- $sqlConnection.Close()
- Write-Host $result
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement