PowerShell Pass Multiple Parameter using AddSript(store powershell OutPut In SQL table using Procedure and Table insertion Method)

By Procedure

param(

[string]$a,

[string]$CreatedBY,

[string]$LoginName,

[string]$RecID,

[string]$IsParticularsActionFlagvar

)

foreach ($i in $a) 

{

    #write  "User CN Parameter: $i" >>C:\NGOForm\NGOlogfile.txt

    $OU=$i

    #$OU='CN=NGOuser5,OU=ExitUsersOU,OU=NGO-TEST_OU,DC=NGO,DC=Test,DC=com'

}

foreach ($j in $CreatedBY) 

{

    #write  "User LoginName Parameter: $j" >>C:\NGOForm\NGOlogfile.txt

    #$VarCreatedBY='Shrawan'

    $VarCreatedBY=$j

}

foreach ($k in $LoginName) 

{

    #write  "User LoginName Parameter: $j" >>C:\NGOForm\NGOlogfile.txt

    #$UserName='NGO\ngoTest12'

    $UserName=$LoginName

}

foreach ($h in $RecID) 

{

    #write  "User LoginName Parameter: $j" >>C:\NGOForm\NGOlogfile.txt

    #$VarRecID=4

    $VarRecID=$h

}

foreach ($l in $IsParticularsActionFlagvar) 

{

    #write  "User LoginName Parameter: $j" >>C:\NGOForm\NGOlogfile.txt

    #$VarIsParticularsActionFlag=4

    $VarIsParticularsActionFlag=$l

}

# Start  Here Define The Passwoed Max Length

$length=Get-Content -Path C:\NGOForm\ResetPasswordMaxLength.txt

# End  Here Define The Passwoed Max Length

$currentDate = Get-Date

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) {

       Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

# End   Call The Fuction Of Rest Password

# Start  Fuction Of Rest Password

Function Set-ADAccountPassNew {

[CmdletBinding()]

param(

[parameter(ValueFromPipeline=$true,Position=0,Mandatory=$True,HelpMessage="Complete OU Path")][ValidateNotNullOrEmpty()] [string[]]$OU ,

[parameter(ValueFromPipeline=$true,Position=1,Mandatory=$True,HelpMessage="UserName")][ValidateNotNullOrEmpty()] [string[]]$UserName ,

[parameter(ValueFromPipeline=$true,Position=2,Mandatory=$True,HelpMessage="Length of Random Password which should be divisible by 3")][ValidateNotNullOrEmpty()] [int]$length ,

[parameter(ValueFromPipeline=$true,Position=3,Mandatory=$True,HelpMessage="Is Particulars Action Flag")][ValidateNotNullOrEmpty()] [int[]]$VarIsParticularsActionFlag ,

[parameter(ValueFromPipeline=$true,Position=4,Mandatory=$True,HelpMessage="Created BY")][ValidateNotNullOrEmpty()] [string[]]$VarCreatedBY ,

[parameter(ValueFromPipeline=$true,Position=5,Mandatory=$True,HelpMessage="Rec ID")][ValidateNotNullOrEmpty()] [int[]]$VarRecID )

process {

Function random-password {

[CmdletBinding()]

param( [parameter(Position=0,Mandatory=$True,HelpMessage="Length of Random Password which should be divisible by 3")]

          [ValidateScript({if( ($_ % 3) -eq 0 ) {  $TRUE  } else { Throw "Error!! Length of Random Password which should be divisible by 3" }})] [int]$length )

process {

       $len= $length/3

       $part1=-join ( (37..38) + (40..42) | Get-Random -Count $len | % {[char]$_})

       $part2=-join ((65..90) + (97..122) | Get-Random -Count $len | % {[char]$_})

       $part3=-join ((49..57) | Get-Random -Count $len | % {[char]$_})

       $array = "$part1$part2$part3".ToCharArray()

       [array]::sort($array)

       $pass1 = "$array" | Get-Random -Count $length

       $password = $pass1.replace(' ','')

       return $password

}

}

$random=random-password -length $length

$NewPassword = ConvertTo-SecureString -AsPlainText $random -Force

# Start Log File

 write  "User CN Parameter: $OU" >>C:\NGOForm\NGOlogfile.txt

write  "User Employee Name Parameter: $VarCreatedBY" >>C:\NGOForm\NGOlogfile.txt

write  "User Windows Login Name : $UserName" >>C:\NGOForm\NGOlogfile.txt

write  "User Parent Rec ID Parameter: $VarRecID" >>C:\NGOForm\NGOlogfile.txt

write  "User Is Particulars Action Flag Parameter: $VarIsParticularsActionFlag">>C:\NGOForm\NGOlogfile.txt

write  "Length Of Password: $length" >>C:\NGOForm\NGOlogfile.txt

write  "Reset Password : $random" >>C:\NGOForm\NGOlogfile.txt

# End  Log File

$DBServer = Get-Content -Path C:\NGOForm\DBServer.txt

$DBName = Get-Content -Path C:\NGOForm\DBName.txt

$Password = Get-Content -Path C:\NGOForm\DBPassword.txt

$UserID =Get-Content -Path C:\NGOForm\DBUserID.txt

$sqlConnection = New-Object System.Data.SqlClient.SqlConnection

$sqlConnection.ConnectionString = "Server=$DBServer;Database=$DBName;User ID=$UserID;Password=$Password; Integrated Security=True;"

$sqlConnection.Open()

if ($sqlConnection.State -ne [Data.ConnectionState]::Open) {

    Write-Error "SQL Connection Failed! Connection to DB is not open."

    Exit

}

if ($sqlConnection.State -eq [Data.ConnectionState]::Open) {

    Write-Output "SQL Connection successful! Connection to DB is open"

}

# Quit if the SQL connection didn't open properly.

$User = Get-Content -Path C:\NGOForm\AdminUserName.txt

$Pass = Get-Content -Path C:\NGOForm\AdminPassword.txt

$PWord = ConvertTo-SecureString -String "$Pass" -AsPlainText -Force

$mycred = New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $User,$PWord

$error.clear()

Set-ADAccountPassword "$OU" -Server NGO.Test.com -Reset -Credential $mycred -NewPassword$NewPassword -ErrorVariable PRError

if($?)

{

   

   $PStatus = Write-Output "Success! Password reset successfully"

   $sqlCommand = New-Object System.Data.SqlClient.SqlCommand

   $sqlCommand.Connection = $sqlConnection

   $sqlCommand.CommandText = "[uspPowershellExecutionHistory] @NGORecID = '$VarRecID', @WindowsLoginID = '$UserName', @OUName = '$OU', @PowerShellExcutionMessage = 'Success! Password reset successful', @ResetPassword = '$random', @CreatedBy = '$VarCreatedBY', @IsParticularsActionFlag ='$VarIsParticularsActionFlag';"

   $sqlCommand.ExecuteNonQuery()

   # close connection

   $sqlConnection.Close()

   write  "****************************Success! Password reset successfully On : $currentDate  ******************************" >>C:\NGOForm\NGOlogfile.txt

   }

else

{

   Write-Output "Failed! Password reset failed"

   $errorval = $error.exception

   $errorval

   $sqlCommand = New-Object System.Data.SqlClient.SqlCommand

   $sqlCommand.Connection = $sqlConnection

   $sqlCommand.CommandText = "[uspPowershellExecutionHistory] @NGORecID = '$VarRecID', @WindowsLoginID = '$UserName', @OUName = '$OU', @PowerShellExcutionMessage = 'Failed! Password reset failed', @ResetPassword = '$random', @CreatedBy = '$VarCreatedBY', @IsParticularsActionFlag ='$VarIsParticularsActionFlag';"

   $sqlCommand.ExecuteNonQuery()

   # close connection

   $sqlConnection.Close()

   write  "****************************Failed! Password reset failed On : $currentDate  ******************************" >>C:\NGOForm\NGOlogfile.txt

}

#$sqlConnection.Close()

}

}

# End   Fuction Of Rest Password

# Start  Call The Fuction Of Rest Password 

Set-ADAccountPassNew -OU "$OU" -UserName "$UserName" -length "$length" -VarIsParticularsActionFlag "$VarIsParticularsActionFlag" -VarCreatedBY "$VarCreatedBY" -VarRecID "$VarRecID"

By Table

param(

[string]$a,

[string]$CreatedBY,

[string]$LoginName,

[string]$RecID,

[string]$IsParticularsActionFlagvar

)

foreach ($i in $a) 

{

    #write  "User CN Parameter: $i" >>c:\NGOlogfile.txt

    $VarCN=$i

}

foreach ($j in $CreatedBY) 

{

    #write  "User LoginName Parameter: $j" >>c:\NGOlogfile.txt

    $VarCreatedBY=$j

   

}

foreach ($k in $LoginName) 

{

    #write  "User LoginName Parameter: $j" >>c:\NGOlogfile.txt

    $varLoginName=$k

   

}

foreach ($h in $RecID) 

{

    #write  "User LoginName Parameter: $j" >>c:\NGOlogfile.txt

    $VarRecID=$h

   

}

foreach ($l in $IsParticularsActionFlagvar) 

{

    #write  "User LoginName Parameter: $j" >>c:\NGOlogfile.txt

    $VarIsParticularsActionFlag=$l

   

}

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) {

       Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

#$randomObj = New-Object System.Random

#$NewPassword=""

#1..12 | ForEach { $NewPassword = $NewPassword + [char]$randomObj.next(33,126) }

#$NewPassword

# Open SQL connection (you have to change these variables)

$DBServer = "111.22.33.54"

$DBName = "DB_NGO"

$Password = "NGO"

$UserID = "NGO"

$sqlConnection = New-Object System.Data.SqlClient.SqlConnection

$sqlConnection.ConnectionString = "Server=$DBServer;Database=$DBName;User ID=$UserID;Password=$Password; Integrated Security=True;"

$sqlConnection.Open()

# Quit if the SQL connection didn't open properly.

if ($sqlConnection.State -eq [Data.ConnectionState]::Close) {

                $sqlConnection.Open()

            }

#if ($sqlConnection.State -ne [Data.ConnectionState]::Open) {

    #"Connection to DB is not open."

   # Exit

#}

#write  "Error: pa" >>c:\logfile.txt

$username = 'NGO\admin'

$Password = 'ngo' | ConvertTo-SecureString -Force -AsPlainText

$credential = New-Object System.Management.Automation.PsCredential($username, $Password)

Function random-password {

[CmdletBinding()]

param( [parameter(Position=0,Mandatory=$True,HelpMessage="Length of Random Password which should be divisible by 3")]

          [ValidateScript({if( ($_ % 3) -eq 0 ) {  $TRUE  } else { Throw "Error!! Length of Random Password which should be divisible by 3" }})] [int]$length )

process {

       $len= $length/3

       $part1=-join ( (37..38) + (40..42) | Get-Random -Count $len | % {[char]$_})

       $part2=-join ((65..90) + (97..122) | Get-Random -Count $len | % {[char]$_})

       $part3=-join ((49..57) | Get-Random -Count $len | % {[char]$_})

       $array = "$part1$part2$part3".ToCharArray()

       [array]::sort($array)

       $pass1 = "$array" | Get-Random -Count $length

       $password = $pass1.replace(' ','')

       return $password

}

}

$random=random-password -length $length

$NewPassword = ConvertTo-SecureString -AsPlainText $random -Force

write  "User NewPassword  Pass Parameter: $NewPassword" >>c:\NGOlogfile.txt

try

{

   $job = Start-Job -scriptblock {

         

          #Set-ADAccountPassword $args[0] -Server "NGO.Test.com" -Reset -NewPassword (ConvertTo-SecureString -AsPlainText $NewPassword -Force)

          #Set-ADAccountPassword  $args[0] -Server "NGO.Test.com" -Reset -NewPassword (ConvertTo-SecureString -AsPlainText "vinay@3708" -Force)

          Set-ADAccountPassword 'CN=Exit User1,OU=ExitUsersOU,OU=NGO-TEST_OU,DC=NGO,DC=Test,DC=com' -Server "NGO.Test.com" -Reset -NewPassword(ConvertTo-SecureString -AsPlainText "vinay@8852" -Force)

         }-ArgumentList $a -credential $credential

         Receive-Job $job

         Wait-Job $job

           

            if($?)

            {

            write  "User CN Parameter: $VarCN" >>c:\NGOlogfile.txt

            write  "User Employee Name Parameter: $VarCreatedBY" >>c:\NGOlogfile.txt

            write  "User Windows Login Name : $varLoginName" >>c:\NGOlogfile.txt

            write  "User Parent Rec ID Parameter: $VarRecID" >>c:\NGOlogfile.txt

            write  "User Is Particulars Action Flag Parameter: $VarIsParticularsActionFlag">>c:\NGOlogfile.txt

          

            $currentDate = Get-Date

            $sqlCommand = New-Object System.Data.SqlClient.SqlCommand

            $sqlCommand.Connection = $sqlConnection

            # This SQL query will insert 1 row based on the parameters, and then will return the ID

            # field of the row that was inserted.""

            #$sqlCommand.CommandText ="INSERT INTO dbo.tblPowershellExecutionHistory (NGORecID,WindowsLoginID,CN,PowerShellExcutionMessage,ResetPassword,CreatedBy,CreatedDate,IsParticularsActionFlag) VALUES ('$VarRecID','$varLoginName','$VarCN','Password reset successfully: $job','$pass','$VarCreatedBY','$currentDate','$VarIsParticularsActionFlag'); "

            $sqlCommand.CommandText ="INSERT INTO dbo.tblPowershellExecutionHistory (NGORecID,WindowsLoginID,CN,PowerShellExcutionMessage,ResetPassword,CreatedBy,CreatedDate,IsParticularsActionFlag,IsActive) VALUES ('$VarRecID','$varLoginName','$VarCN','Password reset successfully','$NewPassword','$VarCreatedBY','$currentDate','$VarIsParticularsActionFlag','YES'); "

            $sqlCommand.ExecuteNonQuery()

            write  "Reset Password Success: Password reset successfully" >>c:\NGOlogfile.txt

               #"Password reset successfully"

            }

            else

            {

             $sqlCommand = New-Object System.Data.SqlClient.SqlCommand

             $sqlCommand.Connection = $sqlConnection

             # This SQL query will insert 1 row based on the parameters, and then will return the ID

             # field of the row that was inserted.""

              $sqlCommand.CommandText ="INSERT INTO dbo.tblPowershellExecutionHistory (NGORecID,WindowsLoginID,CN,PowerShellExcutionMessage,ResetPassword,CreatedBy,CreatedDate) VALUES ('$VarRecID','$varLoginName','$VarCN','Password Reset  failed','$NewPassword','$VarCreatedBY','$currentDate'); "

             $sqlCommand.ExecuteNonQuery()

              write  "Reset Password  Error: Password reset failed" >>c:\NGOlogfile.txt

              #"Password reset failed"

            }

            # close connection

            if ($sqlConnection.State -eq [Data.ConnectionState]::Open) {

                $sqlConnection.Close()

            }

        #Set-ADAccountPassword 'CN=Exit User1,OU=ExitUsersOU,OU=NGO-TEST_OU,DC=NGO,DC=Test,DC=com' -Server "NGO.Test.com" -Reset -NewPassword (ConvertTo-SecureString -AsPlainText "vinay@8822" -Force)

}

catch [Exception]

{

            $sqlCommand = New-Object System.Data.SqlClient.SqlCommand

            $sqlCommand.Connection = $sqlConnection

            # This SQL query will insert 1 row based on the parameters, and then will return the ID

            # field of the row that was inserted.""

            $sqlCommand.CommandText ="INSERT INTO dbo.tblPowershellExecutionHistory (NGORecID,WindowsLoginID,CN,PowerShellExcutionMessage,ResetPassword,CreatedBy,CreatedDate) VALUES ('$VarRecID','$varLoginName','$VarCN','Error in  reset  password:$_.Exception.Message','$NewPassword','$VarCreatedBY','$currentDate'); "

            $sqlCommand.ExecuteNonQuery()

            write  "Error: $_.Exception.Message" >>c:\NGOlogfile.txt

   

}

      

Procedure

ALTER PROCEDURE [dbo].[uspPowershellExecutionHistory]

        @NGORecID                  int,

           @WindowsLoginID             nvarchar(200),

           @OUName                     nvarchar(500),

              @PowerShellExcutionMessage  nvarchar(4000),

              @ResetPassword              nvarchar(100)=null,

              @CreatedBy                  nvarchar(200),

              @IsParticularsActionFlag    int

       AS

BEGIN

INSERT INTO dbo.tblPowershellExecutionHistory

(

                     NGORecID,

                     WindowsLoginID,

                     CN,

                     PowerShellExcutionMessage,

                     ResetPassword,

                     CreatedBy,

                     CreatedDate,

                     IsParticularsActionFlag,

                     IsActive

)

 VALUES (

            @NGORecID,

                     @WindowsLoginID,

                     @OUName,

                     @PowerShellExcutionMessage,

                     @ResetPassword,

                     @CreatedBy,

                     GETDATE(),

                     @IsParticularsActionFlag,

                     'YES'

)

END

C# Code :

  // ps.AddScript(@"C:\temp\DisableUserAccountPSScript.ps1 '" + dynamicReplacementParameterInScript + "'");

                                        ps.AddScript(@"C:\temp\ChangePasswordPSScript.ps1 '" + dynamicReplacementParameterInScript + "' " + " '"+ CreatedBY + "' " + " '"+ LoginName + "' " + " '"+ RecID + "' ");

                                        var results = ps.Invoke();

                                        if (results.Count > 0)

                                        {

                                            ActionHappen = 1;

                                            PowerShellScriptOutPutResult = "Password reset successfully";

                                        }

                                        else

                                        {

                                            ActionHappen = 0;

                                            PowerShellScriptOutPutResult = " Password reset failed";

                                        }

When Data Load In Page Then Used Fliting By Using JQuery Method ( Grep,Map,Filter)

LoadAllDocument();

Call   LoadAllDocument() Before Document .Ready Fuction ()

{

}

 

  var glbDate='';

    function LoadAllDocument()

    {

                 $.ajax({

        url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('NGODocument')/items?$select=Title,Latitude/Latitude,longitude/Longitude,File/ServerRelativeUrl&$expand=Latitude,longitude,File",

        type: "GET",

        headers: {

            "accept": "application/json;odata=verbose",

        },

        success: function (data) {

            glbDate=data;

        },

        error: function (error) {

            //alert(JSON.stringify(error));

        }

    });

   

 

    function BindNGOOnFilter()

    {

                             var MasterLstName='NGOEmployee';

                            clientContext = new SP.ClientContext.get_current();

                                web = clientContext.get_web();

                                var list = web.get_lists().getByTitle(MasterLstName);

                                var camlQuery = new SP.CamlQuery();

                                //var q = '<View><Query><Where><Eq><FieldRef Name=\'Section\' /><Value Type=\'Choice\'>'+section+'</Value></Eq></Where></Query></View>';

                                //camlQuery.set_viewXml(q);

                                camlQuery.set_viewXml();

                                this.listItems = list.getItems(camlQuery);

                                clientContext.load(listItems);

                                clientContext.executeQueryAsync(Function.createDelegate(this, this.BindMapOnFilterSuccess),Function.createDelegate(this, this.BindMapOnFilterFailed));

    }

   

                function BindNGOOnFilterSuccess()

                {

                                var totalRow=this.listItems.get_count();

                                var listEnumerator = this.listItems.getEnumerator();

                                while (listEnumerator.moveNext()) {

                             var lstitem = listEnumerator.get_current();

                            var vDetail ='';

                          vDetail +='<div><b>Site Name:</b><span class=\'Italic\'>'+isCheckNull(lstitem.get_item("SiteName"))+'</span></div>';

                          var temparr=GetDocument(lstitem.get_item("Latitude"),lstitem.get_item("Longitude"));

                           $.each(temparr, function (key, value)

                                {

                                                vDetail +='<div class=\'Italic\'><a target=\'_blank\' href=\''+value.File.ServerRelativeUrl+'\'>'+value.Title+'</a></div>';      

                                });

        }

    

                }

                function BindNGOOnFilterFailed()

                {

               

                }

   

                function GetDocument(Latitude,longitude)

                {

                                                                var arr='';

                                                                arr = jQuery.grep(glbDate.d.results, function(key,value) {

                                                                                return ( key.Latitude.Latitude == Latitude && key.longitude.Longitude == longitude);

                            });

                            return arr;

                }

                  

Multiple Ajax Requests with Jquery

Last few days I have been working with APIs for instant search results, I had an idea to implement a super instant search with multiple APIs like twitter, youtube, yahoo and bing. But jquery older versions doesn’t support multiple ajax call-backs, luckily I had found Jquery 1.5 has released a new method called $.when finally I have developed super fast search at kokkoroko.com.

 Download Script     Live Demo

Javascript Code
Contains javascript and HTML code. $.when( yahoo(), bing()) is the method to call multiple ajax requests. Here $.when calling two functions called yahoo() and bing()callback objects $.done(yahoo_data, bing_data)

<script type="text/javascript" src="http://ajax.googleapis.com/
ajax/libs/jquery/1.5/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$(".search_input").keyup(function()
{
var search_input = $(this).val();
var keyword= encodeURIComponent(search_input);
// Yahoo Search API 
var yahoo_url='http://boss.yahooapis.com/ysearch/web/v1/'+keyword+'?appid=APP_ID&format=json&callback=myData'; 
var bing_url='http://api.search.live.net/json.aspx?JsonType=callback&JsonCallback=?&Appid=APP_ID&query='+keyword+'&sources=web&web.count=10';
// Yahoo API
function yahoo()
{ 
return $.ajax({
type: "GET",
url: yahoo_url,
dataType:"jsonp",
success: function(yahoo_data)
{
}
});
}
// Bing API
function bing()
{ 
return $.ajax({
type: "GET",
url: bing_url,
dataType:"jsonp",
success: function(bing_data)
{
}
});
}
// Multiple Ajax Requests 
$.when( yahoo(), bing()).done(function(yahoo_data, bing_data)
{
var yahoo=yahoo_data[0].ysearchresponse.resultset_web;
var bing=bing_data[0].SearchResponse.Web.Results;
// Yahoo results
if(yahoo)
{
$("#yahoo_result").html('');
$.each(yahoo, function(i,data)
{
var title=data.title;
var dis=data.abstract;
var url=data.url;
var dispurl=data.dispurl;
var final="<div class='webresult'><div class='title'><a href='"+url+"' target='_blank'>"+title+"</a></div><div class='desc'>"+dis+"</div><div class='url'>"+dispurl+"</div></div&gt;";
$("#yahoo_result").append(final); // Result
});
}
// Bing results
if(bing)
{
$("#bing_result").html('');
$.each(bing, function(i,data)
{
var title=data.Title;
var dis=data.Description;
var url=data.Url;
var DisplayUrl=data.DisplayUrl;
var final="<div class='webresult'><div class='title'><a href='"+url+"' target='_blank'>"+title+"</a></div><div class='desc'>"+dis+"</div><div class='url'>"+DisplayUrl+"</div></div&gt;";
$("#bing_result").append(final); // Result
});
}

});

});
});
</script>
// HTML code
<input type="text" class='search_input' />

<div>

<div id="yahoo_result"></div>

<div id="bing_result"></div>

</div>

CSS

#yahoo_result, #bing_result
{
float:left;
width:450px;
}
.search_input
{
border:2px solid #333;
font-size:20px;
padding:5px;
width:350px;
font-family:'Georgia', Times New Roman, Times, serif;
-moz-border-radius:5px;-webkit-border-radius:5px;
}

Unrecognized escape sequence in database connection string c#

When we connect sql database in asp.net web site and make connection on page then many type we face this type of problem.

If you are new and you want to create connection at first time then it is possible that you face this problem.

UNRECOGNIZED ESCAPE SEQUENCE:
As we know that we write fallowing code for make connection.

string connetionString = null;
            SqlConnection cnn ;
     
                     connetionString = "Data Source=PARIJAT-PC\PARIJAT;Initial Catalog=my_testing;Integrated Security=True";

            cnn = new SqlConnection(connetionString);

And get an Exaction or Unrecognized escape sequence error. Because you do not use  \ (forward sales) in string object.

For solving this here we give two option.

Use @ with connectionstring as like :


connetionString = @"Data Source=PARIJAT-PC\PARIJAT;Initial Catalog=my_testing;Integrated Security=True";

Use \\ sales in the place of single sales. Like as :

connetionString = "Data Source=PARIJAT-PC\\PARIJAT;Initial Catalog=my_testing;Integrated Security=True";