. Net Discussion

TypeError: Failed to execute 'fetch' on 'Window': Request with GET/HEAD method cannot have body.

2021-02-24T22:50:00.001-08:00

Getting error when I try to execute GET Method,

TypeError: Failed to execute 'fetch' on 'Window': Request with GET/HEAD method cannot have body.

SOLUTION : Example

[HttpGet]

[Route("Appointment")]

[SwaggerOperation(Tags = new[] { "Hospital/Scheduling" })]

public ActionResult<List<Appointment>> GetAppointmentsV1([FromBody] GetAppointmentsRequest request)

{

try

{

var result = appointmentApi.GetAppointments(request);

return result.Result;

}

catch (Exception Ex)

{

throw Ex;

}

Change [FromBody] to [FromQuery]

How to debug Windows Service as a console application in .Net?.

2019-09-26T08:44:00.000-07:00

How to debug Windows Service as a console application?.

Step 1: Add a public `RunAsConsole` method to your service class.

        public void RunAsConsole(string[] args)
        {
            OnStart(args);
            Console.WriteLine("Press any key to exit...");
            Console.ReadLine();
            OnStop();
        }

Step 2: Opt out of the ServiceBase when running as a console

Change Program.cs main method so it opts out of full service mode when running in interactive mode (i.e. as a console), while falling back to normal service behaviour when run by the Service Controller:

 static class Program
    {
        static void Main(string[] args)
        {
            MyService service = new MyService();
            if (Environment.UserInteractive)
            {
                service.RunAsConsole(args);
            }
            else
            {
                ServiceBase[] ServicesToRun;
                ServicesToRun = new ServiceBase[] { service };
                ServiceBase.Run(ServicesToRun);
            }
        }
    }

Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool

2019-09-25T08:46:00.000-07:00

I have a .NET Windows app that is using MSTDC and it is throwing an exception:

System.Transactions.TransactionManagerCommunicationException: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool ---> System.Runtime.InteropServices.COMException (0x8004D024): The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024) at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction(UInt32 propgationTokenSize, Byte[] propgationToken, IntPtr managedIdentifier, Guid& transactionIdentifier, OletxTransactionIsolationLevel& isolationLevel, ITransactionShim& transactionShim)....

Use this for windows Server 2008 r2 and Windows Server 2012 R2

Click Start, click Run, type dcomcnfg and then click OK to open Component Services.
In the console tree, click to expand Component Services, click to expand Computers, click to expand My Computer, click to expand Distributed Transaction Coordinator and then click Local DTC.
Right click Local DTC and click Properties to display the Local DTC Properties dialog box.
Click the Security tab.
Check mark "Network DTC Access" checkbox.
Finally check mark "Allow Inbound" and "Allow Outbound" checkboxes.
Click Apply, OK.
A message will pop up about restarting the service.
Click OK and That's all.

Reference : https://msdn.microsoft.com/en-us/library/dd327979.aspx

Note: Sometimes the network firewall on the Local Computer or the Server could interrupt your connection so make sure you create rules to "Allow Inbound" and "Allow Outbound" connection for C:\Windows\System32\msdtc.exe

Still Not working Then Use below Enlist=False in the connection string like below

Data Source=<<SQLSERVERNAME>>;Initial Catalog=<<DBNAME>>;Integrated Security=SSPI;Enlist=False;"

Microsoft.VisualStudio.QualityTools.UnitTestFramework.dll' or one of its dependencies. The system cannot find the file specified.

2019-09-09T13:47:00.002-07:00

Microsoft.VisualStudio.QualityTools.UnitTestFramework.dll' or one of its dependencies. The system cannot find the file specified.?

Solutions:

1. Edit the unit test .csproj and change the item references from <Shadow Include="Test References\namespace.accessor" /> to <None Include="Test References\namespace.accessor" /> (Shadow => None).

2 Better yet, simply delete all the .accessor files from the unit test project's Test References folder.

This really works for me.

NService Bus publish failed. Check Inner Exception-Exception has been thrown by the target of an invocation.

2019-02-05T12:42:00.000-08:00

If anyone got the below error when using the Nservice to send MSMQ message into Queue.

Error Error Message: Exception has been thrown by the target of an invocation. Broker EnrollMember: Message: Message: NService Bus publish failed. Check Inner Exception.

Resolution :

Delete the Temp files from the given folders.

Introduction to SASS

2015-12-26T10:53:00.001-08:00

Introduction to SASS

SASS (Syntactically Awesome Stylesheets) is a stylesheet scripting language for CSS. With SASS you get the power to use features like variables, mixins, nesting etc. thereby decreasing the overall complexity and length CSS sheets. It creates reusable functions and thus increasing code maintainability. The initial version of SASS had an intended syntax, but the later version a new syntax was introduced which did not care about indentation levels or white-space. It uses brackets and semi-colons just like CSS. This version of SASS is called SCSS (Sassy CSS).

The official implementation of Sass is open-source and coded in Ruby, however, other implementations exist, including PHP, and a high-performance implementation in C called libSass. There's also a Java implementation called JSass. Additionally, Vaadin has a Java implementation of Sass. Sass supports integration with the Firefox extension Firebug.

So we will start with few features of this scripting language for CSS. We have following features which will be discussing in little details below.

Variables

Just like in other scripting or object oriented languages now in CSS we can have variables to store information that could be reused. You can assign any font, color, or any other CSS attribute to a variable which you may use throughout the code. SASS uses $ symbol to denote a variable.

E.g

$red-color: #ff0000;

.menu-navigation {

border-color: $red-color;

color:

darken($red, 10%);

}

Interesting fact here is that in variable names hyphen and underscores can be used interchangeably. Variable could be made global with !global keyword.

Rules and Directives

You can think of Mixins as functions which can also take parameters if required. A Mixin helps you create a group of CSS declarations which you may want to reuse throughout you code multiple times. To create a mixin we use @mixin directive. We may pass a parameter in the same which can be used in code below. Once you create a mixin you can call it using @include

a. @import

This rule is used to import scss and sass files at the top of file

b. Nested @import

To import within CSS rule

c. Partials

Partials are similar to partial views in MVC. To modularize large CSS files one may create a separate partial class containing small code snippets.

Partials classes are created with a prefix underscore like _Partial.scss. These partials are then used using @import directive.

d. @media

To add media style without repeating them

e. @extend

To add style of one class into another class

f. @debug

To print value in output.

g. @warn

This is same as @debug with the difference that they could be turned off with –quiet command

h. @error

This is used to throw error with stack trace

Mixins

E.g

@mixin border-radius($radius) {

-webkit-border-radius: $radius;

-moz-border-radius: $radius;

-ms-border-radius: $radius;

border-radius: $radius;

}

.box { @include border-radius(10px); }

Control Expressions

We can use control statements which we use in any oops language like If-Else, For, each, while, etc

div {

@if $Company == avanade {

color: orange;

} @else if $type == accenture {

color: blue;

} @else {

color: black;

}

Output Style

The output style is used to define how do you want your output CSS to be structured. It has three different options

:Nested - It add the indentation to each rule

:Expanded - it add indentation to each property within the rule

:Compact - Each rule appear in single line

:Compressed – It is kind of minified version of CSS with no whitespaces

Function

User defined functions could be created as in other programming languages and it contains collection of statements as below

@function double-pix($n) {

@return $n * 2;

}

#sidebar { width: double-pix(5); }

Example for practical implementation

Below we have tried to show an example how can we use SASS in our page say an application form.

Let’s say I define a class for validation error in my .scss file with following attributes

.css-validation-arrow {

border-color: $red-color;

position: absolute;

top: 0;

left: rem-calc(40);

}

Now when this SCSS file is compiled, it would get compiled to following class in your.css file.

.css-validation-arrow {

border-color: #FF0000;

position: absolute;

top: 0;

left: 2.5em;

}

Now let’s say I have a span in my .cshtml file of .net project which I would like to highlight for a validation error occurring in my input field of my application form.

I will just have to define this class just like my normal css class and it would fire validation error as specified in css.

You must select the sender account

</small>

SASS Installation

We would need to follow following steps for SASS installation using ruby

1. Download Ruby, http://rubyinstaller.org/downloads/ (NB! Not x64 version)

2. Run installation

2.1. Add Ruby executables to your path

2.2. Associate .rb and .rbw files with Ruby installation

3. Run cmd

3.1. Write: gem update --system

3.2. gem install sass -v "3.2.13"

(The source files can be found under C:\[RUBY]\lib\ruby\gems\[VERSIONNUMBER]\gems)

We would now need to install compass to watch over our changes. Follow following steps for compass install

1. In cmd, write: gem install compass -v "0.12.2"

To compile and watch our changes we can use following commands in command prompt Compass compile

● Compile: compass compile [path/to/project]

● Watch the project for changes and compile whenever it does: compass watch [path/to/project]

When a compass project is created a file called config.rb is created. The file contains settings for the compass project that will be used during compilation.

SASS Intellisense in Visual Studio 2012

There are various extension available for SASS Intellisense which could be used. Below is example for mindscape

1. Download Visual Studio extension Web Workbench from Mindscape (is used for Syntax highlighting, intellisense etc),

http://www.mindscapehq.com/products/webworkbench

2. Since Compass will be used for compilation, uncheck all checkboxes from the compile

column in the “Mindscape/Web Workbench Settings” menu option in Visual Studio.

Or we can extend compass watch tool in Visual Studio using following steps:-

1. Go to Tools/External Tools/Add in visual studio

1.1. Give title: Compass Watch

1.2. Command: C:\[RUBYROOT]\bin\compass.bat

1.3. Arguments: watch $(ProjectDir)

1.4. Initial directory: $(ItemDir)

1.5. Uncheck “close on exit”

1.6. Check “Use output window”

2. Right click on toolbar in Visual Studio and choose “Customize”

2.1. New/Toolbar name: Compass

2.2. Tab Commands

2.2.1. Toolbar: Compass

2.2.2. Add command…

2.2.3. Tools

2.2.4. External command X (X is the index of Compass Watch in External Tools)

Limitations with hosting WCF Service on Visual Studio Development Server

2014-12-31T07:57:00.001-08:00

Scenario

For uploading large files using WCF service, Microsoft recommends to use Stream objects and implement streamed transfer mode. We created a sample POC using

Message Contracts passing streams and writing a stream to a folder. We also created a Sample Console application to consume the WCF service and to write large files

to a folder. Both WCF service and Sample Console application were part of a single solution file.

Issue

We started the WCF service over the Visual Studio Development Server and then run the console application to test the WCF service. We repeatedly got the

following error:

The remote server returned an error: (400) Bad Request

We checked all the configurations in both Client and Service and everything was fine. One major limitation was we were not able to debug the service, since it was

not hitting the breakpoint.

Resolution

We then hosted the WCF service on IIS and the service started working. We were able to debug the code and the functionality worked as expected.

The recommendation would be to always host WCF service on IIS, since there are some limitations while hosting it on File-System. When the WCF service is hosted

on File-System, we were unable to debug the code, even if we attach the process. We were spending a lot of time in analysis and debugging even when there

was no issue.

Cross browser compatibility - Well-formed HTML in IE8< vs. IE 9

2014-12-31T07:56:00.000-08:00

Cross browser compatibility - Well-formed HTML in IE8< vs. IE 9.

Applies To:
This issue applies to all the browsers that support HTML 5 specification.

Problem:
Browsers typically detect the well-formed characteristics of XML. But when it comes to html, lots of pre-html5 based browsers used to ignore the tags that are not well formed. In some cases it might not result in a visible issue and might not be very evident as well. Typically when these are opened in Visual studio it will highlight and the catch is when the html is huge or when it is dynamically rendered.

For ex. The business wanted to show a few text in bold, but that was not visible as bold to the users using that. Also the contents of the page beyond the error are not submitted back. Consider the snippet below

...

<table>

<thead>

<tr><td><b>Employee ID<\td><td><b>Employee ID<\b><\td><\tr>

</thead>

</table>

....

....

You can expect issues that the text or other controls below are not part of the request collection. IE9 breaks on all errors and anything beyond the error don’t find a place in the list of values posted back. This might not be the case with IE8< browsers or on IE9 compatibility modes.

Solution:
The solution is to identify all HTML issues and ensure that the HTML is well formed(example: closing tags are present). This applies to Script tags as well.

Issue in Javascript function when called from XSLT in IE browser

2014-12-31T07:53:00.000-08:00

In IE browser, We are facing an issue where JavaScript function when gets called from XSLT returns incomplete JavaScript parameters. However if the same JavaScript function when gets called through the C# code then it returns the complete JavaScript parameters.

Please note this anomalous behavior is observed when we have JavaScript parameter having character limit crossing 4000 chars. For parameter having lesser characters are working fine in both the cases mentioned above.

Please note that we are able to get the parameters in the XSLT variables. But the issue occurs when we try to pass the XSLT variables in javascript function.

e.g.Suppose we have to pass 5 parameters, then

In Internet Explorer browser, javascript function is truncating in between:

javascript:showAlertMessage('<div> Content exceeding 4000 characters<div>', 'Var2','Var3','var4 {var 4 is truncating in between}

But in Non-IE browsers, it is passing all parameters successfully:

javascript: showAlertMessage('<div> Content exceeding 4000 characters<div>', 'Var2','Var3', 'Var4', 'Var5');

Early help would be highly appreciated.

SOLUTION 1:

Generally we are using below way to call the JavaScript in XSLT.

<script type="text/ecmascript">

formatDt('param1',’aparam2’);

</script>

Hope that helps you.

SSIS Upgrade SQL Server 2012

2014-12-29T14:35:00.000-08:00

Here are a few tips that can help to make the upgrade successful. This article covers only few of the upgrade features to SSIS 2012.

1. Edit Package Configuration and Data Source after upgrading

The first step to upgrade an SSIS solution is to run the SSIS Package Upgrade Wizard. The SSIS Package Upgrade Wizard makes appropriate changes to package properties and upgrades the package format. The wizard launches when you open a pre-SQL Server 2012 package in the SQL Server Data Tools for the first time. SQL Server Data Tools replaces (BIDs). The wizard can also be launched manually by running SSISUpgrade.exe, which is located under %ProgramFiles%\Microsoft SQL Server\110\DTS\Binn.It is critical to note that the SSIS Package Upgrade Wizard does not upgrade settings such as connection strings that are defined in the package configurations. After a package upgrade, you may need to make some manual changes to the package configuration to run the upgraded package successfully. For example, you have an SSIS 2005 package. The package uses an OLE DB connection manager to connect to the SampleDB database in a local SQL Server 2005 instance. The package also uses an XML package configuration file to dynamically configure the Connection String property of the OLE DB connection manager. The following shows the contents of the XML package configuration file.

You have set up a machine with a standalone SQL Server 2012 installation. You move the SSIS 2005 package to the machine and run the SSIS Package Upgrade Wizard to upgrade the package to SQL Server 2012. When the wizard finishes, you need to manually change the provider name from SQLNCLI.1 to SQLNCLI11.1 in the XML package configuration file to run the upgraded package successfully. The wizard does not update package configuration files. If you don’t update the provider name in the configuration file, the file configures the OLE DB connection manager to use the SQLNCLI.1 provider that is the SQL Server 2005 Native Client Library. SQLNCLI11.1 is the SQL Server 2012 Native Client Library. Because the SQL Server 2005 Native Client Library is not included in SQL Server 2012, the following error message will appear when you open or execute the upgraded package on the machine where SQL Server 2012 is installed:

The requested OLE DB provider SQLNCLI.1 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". So, if your pre-SQL Server 2012 package uses any kind of package configurations, it is important to remember that you may need to manually update the content of the package configurations after you upgrade the package to SQL Server 2012. This applies to the different types of configurations, such as XML configuration files.

Connection strings that require updates and are stored in data source files or set by expressions, need to be updated manually.

2. Convert to project deployment model using Project Conversion Wizard

SQL Server 2012 SSIS supports two deployment models: the package deployment model and the project deployment model. The package deployment model was available in previous releases of SSIS and is the default deployment model for upgraded packages. In this model, the unit of deployment is the package. The project deployment model is new in SQL Server 2012 and provides additional package deployment and management features such as parameters and the Integration Services catalog. The unit of deployment is the project.

To convert a package to the project deployment, right click the project in Solution Explorer and then click Convert to Project Deployment Model. The Project Conversion Wizard launches and walks you through the conversion process.

3. Update Execute Package Task to use project reference and use parameter to pass data from parent package to child package

If an SSIS package contains an Execute Package Task, the Project Conversion Wizard prompts you to update the task to use the project reference.

For example, your SSIS project contains several packages. Inside the project, one package (typically called the parent package) runs another package (typically called the child package) by using an Execute Package Task. In Pre-SQL Server 2012 releases of SSIS, the parent package references the child package by using a File connection manager. At deployment, you need to remember to update the File connection manager to ensure that it points to the new location of the child package.

In SQL Server 2012 Integration Services you can configure the parent package to reference the child package by name when the child package is included in the same project as the parent package. Using this project reference makes the deployment experience much smoother. You don’t need to remember to update the reference between the parent package and the child package at deployment. For a thorough explanation of the project reference in the Execute Package Task.

In previous releases of SSIS, you pass data from the parent package to the child package by creating a package configuration that uses the parent variable configuration type. This enables a child package that is run from a parent package to access a variable in the parent.

It is recommended that you configure the Execute Package Task to use parameter binding to pass data from the parent package to the child package. Parameters make this task easier. For example, you want a parent package to dynamically determine the number of days in a current month and have the child package perform a task for that number of times. You can create a variable in the parent package that represents the number of days and create a parameter in the child package. Then in the Execute Package Task, you bind the parameter in the child package to the variable in the parent package.

4. Parameterize PackageName property of Execute Package Task to dynamically configure which child package to run at execution time

Suppose your SSIS 2008 package has an Execute Package Task, and the package uses a File connection manager to connect to a child package.

You dynamically assign which child package the Execute Package Task runs by configuring the connection string property of the File connection manager.

The following is the content of the XML package configuration file used by your SSIS 2008 package.

When the Project Conversion Wizard converts the package to the project deployment model and updates the Execute Package Task to use the project reference, the File connection manager that was used to connect to the child package is no longer used by the Execute Package Task. To continue to dynamically determine which child package the task runs, you create a parameter and map that parameter to the PackageName property of the Execute Package Task as shown in the following image.

5. Convert package configuration to parameter when possible

Parameters are new to SQL Server 2012 Integration Services and are the replacement for package configurations. You use parameters to assign values to package properties, whether at design time or run time. The values are pushed to a package when it is executed rather than having the package pull values from the package configurations.

The Project Conversion Wizard prompts you to optionally convert package configurations to parameters. It is possible that you might choose to keep a package configuration as an intermediate step of upgrading to SQL Server 2012. When your package has both configuration values and parameter values, it is important to understand the order in which these values are applied. Package configuration values will be applied first. If there are also parameter values for the same properties, these values will be applied next and will overwrite the package configuration values.

Server Error in '/CustomReports' Application.

2014-10-14T13:46:00.001-07:00

Server Error in '/CustomReports' Application.

Error info:

Failed to map the path '/'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Failed to map the path '/'.

Source Error:

An unhandled exception was generated during the execution of the
  current web request. Information regarding the origin and location of the
  exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Failed to map the path '/'.]

   System.Web.Configuration.ProcessHostConfigUtils.MapPathActual(String siteName, VirtualPath path) +253

   System.Web.Configuration.ProcessHostMapPath.MapPathCaching(String siteID, VirtualPath path) +669

   System.Web.Configuration.ProcessHostMapPath.GetPathConfigFilenameWorker(String siteID, VirtualPath path, String& directory, String& baseName) +19

   System.Web.Configuration.ProcessHostMapPath.System.Web.Configuration.IConfigMapPath.GetPathConfigFilename(String siteID, String path, String& directory, String& baseName) +37

   System.Web.Configuration.HostingPreferredMapPath.GetPathConfigFilename(String siteID, String path, String& directory, String& baseName) +75

   System.Web.Configuration.WebConfigurationHost.GetStreamName(String configPath) +8941366

   System.Configuration.Internal.DelegatingConfigHost.GetStreamName(String configPath) +13

   System.Configuration.BaseConfigurationRecord.InitConfigFromFile() +154

[ConfigurationErrorsException: An error occurred loading a configuration file: Failed to map the path '/'.]

   System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal) +655924

   System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors) +31

   System.Configuration.Configuration..ctor(String locationSubPath, Type typeConfigHost, Object[] hostInitConfigurationParams) +356

   System.Configuration.Internal.InternalConfigConfigurationFactory.System.Configuration.Internal.IInternalConfigConfigurationFactory.Create(Type typeConfigHost, Object[] hostInitConfigurationParams) +29

   System.Web.Configuration.WebConfigurationHost.OpenConfiguration(WebLevel webLevel, ConfigurationFileMap fileMap, VirtualPath path, String site, String locationSubPath, String server, String userName, String password, IntPtr tokenHandle) +775

   System.Web.Configuration.WebConfigurationManager.OpenWebConfigurationImpl(WebLevel webLevel, ConfigurationFileMap fileMap, String path, String site, String locationSubPath, String server, String userName, String password, IntPtr userToken) +84

   System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(String path) +36

   Microsoft.Practices.CompositeWeb.Services.WebConfigModuleInfoStore.GetConfiguration(String configFilePath) +242

   Microsoft.Practices.CompositeWeb.Services.WebConfigModuleInfoStore.PopulateSection(ModulesConfigurationSection section, String rootDirectory) +188

   Microsoft.Practices.CompositeWeb.Services.WebConfigModuleInfoStore.GetModuleConfigurationSection() +101

   Microsoft.Practices.CompositeWeb.Services.WebModuleEnumerator.EnumerateModules() +173

   Microsoft.Practices.CompositeWeb.WebClientApplication.LoadModules() +240

   Microsoft.Practices.CompositeWeb.WebClientApplication.Application_Start(Object sender, EventArgs e) +162

SOLUTION STEP1 :

Right Click on Web Project, -> Properties -Web - Make sure following is set.

Recaptcha Implementation | Need Guidance

2014-10-14T13:08:00.001-07:00

For recaptcha security change, please go to the page (.aspx) of the application where you want to implement it and follow below steps :

- Firstly, add a reference for Recaptcha.dll to the project. You can download the latest .dll version from the net. Please be sure that the dll version is compatible with the application that you are developing in.

- Now on the aspx page, insert the following on top next to the page directive :

<%@ Register TagPrefix="recaptcha" Namespace="Recaptcha" Assembly="Recaptcha" %>

- Now add below reCAPTCHA control inside of the webform (i.e.<form runat="server">) tag

<recaptcha:RecaptchaControl

ID="recaptcha"

runat="server"

PublicKey="your_public_key" (Enter the public key here)

PrivateKey="your_private_key" (Enter the private key here)

Please generate your own public and private keys from this link

https://accounts.google.com/ServiceLogin?service=recaptcha&passive=1209600&continue=https://www.google.com/recaptcha/admin/list&followup=https://www.google.com/recaptcha/admin/list

- Go to the code behind of the page and search for the imb_continue button(/or next button) and place below condition in the beginning for the validation of the recaptcha tool by using (Page.isvalid) condition:

imb_continuebuttonclick()

{

(constant variables if any)

If (Page.isvalid)

{

whole body of the button.

}

else

{

string displaytext="Please check that the recaptcha tool is added correctly and matches the two words provided."

errordiv.display= displaytext; // You will need to define an errordiv in aspx page first or please check how other error messages are being shown in the page and display this message in the same manner.

}

Also helps

http://stackoverflow.com/questions/13018047/recaptcha-ip-addresses

Excel exception while opening file from sharepoint

2014-10-14T13:06:00.002-07:00

I am trying to open an excel file from Sharepoint 2010 using Excel 2010. I am getting the following exception:

Excel found unreadable content in ‘[filename].xls’. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

Any idea why I am getting this exception. Do you know the solution?

SOLUTION :

Have you tried below:

1. Open the file in Excel 2010

2. Go to File: Save

3. Change the Save As type to Web Page (.html), save and close the file

4. Open the .html file in Excel

5. Save the file as a .xlsx (with a new name so the original isn't lost)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;820741

Reading special characters from a flat file

2014-10-14T13:02:00.002-07:00

have a requirement of comparing a flat file with a word document.

I am using StreamReader to read the flat file and Microsoft.Office.Interop.Word.Application to read the word document.

The issue I am facing is the special characters are not read properly from the flat file. If I change the encoding of the content that is read, while I debug I am able to see the special character as it is supposed to be, but it doesn’t match with that from the word document and it is shown as a difference.

Is somebody aware of a solution for this?

ANS :

Because of Word document format you may get the difference while compare the special characters of flat file and word-doc file.

So convert those special characters into ASCII/Unicode of both flat file and word-doc file and then compare those values.

Building .VDPROJ file using Command Line

2014-10-14T12:58:00.003-07:00

I have a requirement of building my project setup file using Command Line or C# code.

I tried using "devenv", but it didn't work.

Can any one please provide any suggestions?

ANSWER:

To build single project use this

devenv samplesolutionfile.sln /build "Debug|Win32" /project sampleSetup "Debug|Win32" in your MSBuild script.

Hari

Microsoft Infopath: Need help

2014-10-14T12:56:00.003-07:00

I have forms in microsft infopath and currently I want to see if any filed in the path is filled or not and need to maintain in Excel. There are 250 microsoft infopath files need to processed. Please help if I can write any code or any inbuilt functions can be used to see if any filed is filled or not.

SOLUTION :

InfoPath forms internally getting maintained as XML. You may use following procedure for your requirement.

1) Put all InfoPath Xmls in a folder.

2) Using VB Script Iterate thru each file by for each loop, read the xml and get the value for required field as substring.

3) Also based on the field value or required condition, you can write extracted substring into the excel.

Bulk upload for .xlsx and .csv format

2014-10-14T12:47:00.003-07:00

We have a requirement in the project in which we want to upload data from file having .xlsx format (or.csv format) into database table. But we want to do bulk upload rather than row by row upload, because we have over 1 lakh records in the file.

We have to do that using 2 methods

1. .net code

2. SSIS package

In .net code we are using SQLBulkCopy class for doing bulk upload for excel file(i.e. file with .xls and.xlsx extension). This approach works fine when we have excel file in .xls format, but when I use .xlsx format I am not able to do that because it requires some component to be installed on the machine where application is deployed. And this installation thing can create issues when we go to higher environments.

But in case of csv format the processing is done on row by row format which has a performance impact on an application.

Using SSIS package we can use Data flow task. But we have following issues in this approach.

- Rows get inserted one by one

- Lot of performance issues faces due to large amount of data.

So my question is

1. Can we do bulk upload the data from excel file(both .xls and .xlsx extension) and .csv file using .net code?

2. Can we do bulk upload the data from excel file(both .xls and .xlsx extension) and .csv file using SSIS package?

SOLUTION'S 1:

Try using Linq to Excel functionality. It will load the excel file data into linq object and at one go you can save it in database.

SOLUTION'S 2:

You can use bulk copy as mentioned below:

public void GetinsertADValuetoSql()
        {
            //throw new NotImplementedException();
            DataTable dtSQLvalue = new DataTable();

dtSQLvalue = ReadValueFromExcel();

            int count = dtSQLvalue.Rows.Count;
            if (count > 0)
            {
                //Get connection string from web.config file
                string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
                TraceService("Another entry at " + strcon);
                int iSucess = 0;
                int ItemID = 0;
                for (int irow = 0; irow < count; irow++)
                {
                    //create new sqlconnection and connection to database by using connection string from web.config file
                    using (SqlConnection openCon = new SqlConnection(strcon))
                    {
                                               string saveADValue = "INSERT INTO [PWR].[dbo].[Adopt Decision]([XYZID],[Asset],[Adopted],[Remarks] ,[Savings Realized],[Date of Decision])      VALUES   (@XYZID,@Asset,@Decision,@DecidersComments,@Anticipatedsavings,@DateofDecision)";
                        using (SqlCommand querySaveADValue = new SqlCommand(saveADValue))
                        {
                            querySaveADValue.Connection = openCon;
                            openCon.Open();

/// Bulk copy operation
                              using (SqlBulkCopy copy = new SqlBulkCopy(openCon))
                              {
                                  copy.ColumnMappings.Add("XYZID", "XYZID");
                                  copy.ColumnMappings.Add("Asset", "Asset");
                                  copy.ColumnMappings.Add("Adopted", "Decision");
                                  copy.ColumnMappings.Add("Remarks", "Deciders Comments");
                                  copy.ColumnMappings.Add("Savings Realized", "Anticipated savings");
                                  copy.ColumnMappings.Add("Date", "Date of Decision");

                                  copy.DestinationTableName = "[Adopt Issue]";
                                  copy.WriteToServer(dtSQLvalue);
                              }
                              openCon.Close();

                }
            }
        }

Hosting WCF Services in IIS using MSI

2014-10-14T12:45:00.000-07:00

SOLUTION 1:

Out the box MSI installers are discontinued from VSTS2012, so you won’t be able to use those, however you have option to revert back to VSTS 2010 just for deployment project.

For VSTS2012, I recommend using WIX, you could google out WIX, there is plenty of resources available. For quickstart below is some important WIX steps –

//copy all the Assemblies

</Component>

</Directory>-->

</Directory>

//copy all the Service specific files

</Component>

//Create IIS component like Application pool,website nd virtual directory

<iis:WebAppPool Id="WebAppPool" Name="ServicePool" ManagedRuntimeVersion="v4.0" IdleTimeout="0" RecycleMinutes="0" ManagedPipelineMode="integrated">

</iis:WebAppPool>

<iis:WebSite Id ='Service' Directory ='INSTALLATION FOLDER' Description= 'Website Description'>

<iis:WebAddress Id="AllUnassigned" Port="8019" />

</iis:WebSite>

<iis:WebVirtualDir Id="Virtual" Alias="VD" Directory="INSTALLATION FOLDER" WebSite="Service">

<iis:WebApplication Id="MyWebAppApplication" WebAppPool="WebAppPool" Name="WebSiteVirtual" />

<iis:WebDirProperties Id="MyWebSite_Properties" AnonymousAccess="yes" WindowsAuthentication="no" />

</iis:WebVirtualDir>

</Component>

</Directory>

Please check out the link for more information - http://www.codeproject.com/Articles/115036/Creating-WIX-Installer-for-ASP-NET-Web-Application

SOLUTION 2:

n order to achieve this you can write your service as an Installer Class custom action and install it using a ".NET Installer Class Action" predefined custom action. Also, you can take a look on "How to: Host a WCF Service in a Managed Windows Service" article which should be useful for you.

Refresh Cache when data is changed in the the data base using System.Runtime.Caching

2014-10-14T12:42:00.000-07:00

For one of my requirement in WCF service I need to implement caching using new functionality System.Runtime.Caching in don’t.net 4.0.

For which my caching should be refreshed only when the data base values are changed in the data base.

I am able to get my data from the table using a stored procedure and then cache the data, But I need to refresh the data when the data is changed in the data base.

I have tried using the below to implement. But I am not able to get the values when the data base values are changed.

SqlDependency sqlDep = new SqlDependency();

SqlChangeMonitor monitor = new SqlChangeMonitor(sqlDep);

If anyone has implemented this functionality , please share the details. I are using Visual Studio – 2012, C#.

SOLUTION :

SqlCacheDependency class should help, Please refer to the link below:

http://msdn.microsoft.com/en-us/library/ms178604.aspx

Error while running LightSwitch application

2014-10-14T12:40:00.004-07:00

I am facing the below error while running my local Lightswitch application. I am using VS2010, SQL server 2008 R2, Windows 7 on my machine.

I've verified the SQL version with my other team mates, they all have SQL server 2008 R2 running in their systems. The versions also match but I do not see User Instance option SQL server, rest all have it.

I’ve read in some post that User Instance is only enabled if you have a SQL express version on your system but none of my teammates have it and code is working fine on their local machine.

I've read some other post about installing SQL express version but in that case, I’ll need to provide another instance name to SQL. Even after that it's giving the same error. Installing SQL express over SQL 2008 R2 does not make any difference.

I've also tried removing the "UserInstance" flag in connectionstring but then it gives another error = "Access denied to .mdf file", though I've provided all the rights to the user.

I've also tried reinstalling SQL server 2008 R2 but even then I don't see "User instance" in SQL server to enable it.

Please let me know what else can I try to resolve this issue.

SOLUTION :

You have to provide Instance name while installing SQL Server 2008 R2.

Please check that SQL Server was un-installed properly or not.

When you un-install SQL Server then please remove all local folders of SQL Server in system and restart your system.

The URL-encoded form data is not valid. at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at

2014-10-14T12:34:00.003-07:00

Requirement: I have implemented an asp.net page where inside Ajax Tab Panel control I am displaying ~27 grid views loaded with the data.

Grid Columns ranges from 20 to 60 columns. For Editing purpose I have added Editable Checkboxes and on Click of each checkbox individual record becomes editable.

There is a global Save button for saving all the changes in one time.

Everything is working fine no issue with the Ajax.

But when I have added JavaScript code on page for performance optimization like making rows editable ,all intermediate data manipulation etc.

Then for few of data while saving I am getting below error and it seems it’s because of a particular grid view data where the number of columns are 60 and number of records are more than 50.

Error:

“HttpException

The URL-encoded form data is not valid. at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() “

I have also set the below settings in web.config file but it’s also not working.

SOLUTION

Try setting AllowPaging property to true also try to increase maxHttpCollection Keys and give it a try. What version of .NET you are using?

timeout error while updating 45k records using sp

2014-10-14T12:31:00.002-07:00

I am trying to upload 45k records through csv(or excel) using SQLBulkCopy class. Once the data goes into a table I am updating a field in all 45k records based on some logic(we are using stored procedure for that). But when I do that, I am getting this error - Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I have done some R & D on the same and based on that I have changed some tags in web.config file like

1. Change the value of maxItemsInObjectGraph attribute in dataContractSerializer tag to 2,147,483,647.

2. Change the value of closeTimeout, openTimeout, receiveTimeout, sendTimeout, maxBufferSize, maxBufferPoolSize and maxReceivedMessageSize attribute in binding tag tag to 2,147,483,647.

3. Change the value of maxDepth, maxStringContentLength, maxArrayLength, maxBytesPerRead and maxNameTableCharCount in readerQuotas tag. You can check both the binding tags in web.config file tag to 2,147,483,647.

4. Add an attribute executionTimeout="600" in HTTPRuntime .

5. Set Connection Timeout=90; in connection string

Note - There is one more point that I want to highlight is when I run the stored procedure through SSMS I can run it successfully and there is no time out error.

Still I am getting the same issue. Is there anything that I have missed? Please advice.

URLs from outlook not working issue - Solution!!

2014-10-14T12:29:00.001-07:00

Followthe steps.

Control Panel -> Programs -> Default programs

What is Regular expression-Why Regular Expression-How Regex Works

2014-10-14T12:27:00.000-07:00

What is Regular expression

• A regular expression is a pattern that the regular expression engine attempts to match in input text. A pattern consists of one or more character literals, operators, or constructs.

Why Regular Expression

• Regular expression provides powerful, flexible and efficient method for processing text.

• The extensive pattern-matching notation of regular expressions enables you to quickly parse large amounts of text to find specific character patterns.

• To validate text to ensure that it matches a predefined pattern (such as an e-mail address); to extract, edit, replace, or delete text substrings.

• To add the extracted strings to a collection in order to generate a report.

How Regex Works

• The centre piece of text processing with regular expressions is the regular expression engine, which is represented by the System.Text.RegularExpressions.Regex object in the .NET Framework.

• At a minimum, processing text using regular expressions requires two items of information:

– The regular expression pattern to identify in the text.

– The text to parse for the regular expression pattern.

• The methods of the Regex class let you perform the following operations:

– determine whether the regular expression pattern occurs in the input text by calling the IsMatch method

– Retrieve one or all occurrences of text that matches the regular expression pattern by calling the Match or Matches method.

– Replace text that matches the regular expression pattern by calling the Replace method.

Regex Sections

• Character escapes

• Character classes

• Anchors

• Grouping constructs

• Quantifiers

• Backreference constructs

• Alternation constructs

• Substitutions

• Regular expression options

• Miscellaneous constructs

Character Escapes

• The character that follows it is a special character, as shown in the table in the following section. For example, \b is an anchor that indicates that a regular expression match should begin on a word boundary and \t represents a tab. The backslash (\) in a regular expression indicates one of the following:

Escaped Character	Pattern	Description	Example
\a	\a	Matches a bell character, \u0007.	"\u0007" in "Error!" + '\u0007'
\b	[\b]{3,}	In a character class, matches a backspace, \u0008.	"\b\b\b\b" in "\b\b\b\b"
\t	(\w+)\t	Matches a tab, \u0009.	"item1\t", "item2\t" in "item1\titem2\t"
\r	\r\n(\w+)	Matches a carriage return, \u000D. (\r is not equivalent to the newline character, \n.)	"\r\nThese" in "\r\nThese are\ntwo lines."

Character Classes :-

• A character class defines a set of characters, any one of which can occur in an input string for a match to succeed. The regular expression language in the .NET Framework supports the following character classes:

– Positive character groups. A character in the input string must match one of a specified set of characters.

– Negative character groups. A character in the input string must not match one of a specified set of characters.

– Any character. The . (dot or period) character in a regular expression is a wildcard character that matches any character except \n.

– A word character. A character in the input string can belong to any of the Unicode categories that are appropriate for characters in words.

– A non-word character. A character in the input string can belong to any Unicode category that is not a word character.

– A white-space character. A character in the input string can be any Unicode separator character, as well as any one of a number of control.

– A non-white-space character. A character in the input string can be any character that is not a white-space character.

– A decimal digit. A character in the input string can be any of a number of characters classified as Unicode decimal digits.

– A non-decimal digit. A character in the input string can be anything other than a Unicode decimal digit.

Character Classes regex :-

Escaped Character	Pattern	Example
[Character group]	[ae]	"a" in "gray
[^ character_group ]	[^aei]	"r", "g", "n" in "reign"
[ first - last ]	[A-Z]	A", "B" in "AB123"
.	a.E	"ave" in "nave"
\p{ name }	\p{Lu}	"C", "L" in "City Lights"
\P{ name }	\P{Lu}	"i", "t", "y" in "City"
\w	\w	"I", "D", "A" in "ID A"
\W	\W	" ", "." in "ID A1.3"
\s	\w\s	"D " in "ID A1.3"
\S	\s\S	" _" in "int __ctr"
\d	\d	"4" in "4 = IV"
\D	\D	" ", "=", " ", "I", "V" in "4 = IV"

Anchor:

• Anchors specify a position in the string where a match must occur.

• When you use an anchor in your search expression, it looks for a match in the specified position only. For example, ^ specifies that the match must start at the beginning of a line or string.

Anchor	Description
^	The match must occur at the beginning of the string or line
$	The match must occur at the end of the string or line, or before \n at the end of the string or line.
\A	The match must occur at the beginning of the string only (no multiline support).
\Z	The match must occur at the end of the string, or before \n at the end of the string.
\z	The match must occur at the end of the string only.
\G	The match must start at the position where the previous match ended.
\b	The match must occur on a word boundary.
\B	The match must not occur on a word boundary.

Learning Windows PowerShell online with easy steps

2014-10-14T09:36:00.001-07:00

Introduction

•Windows PowerShell is Microsoft's task automation and configuration management framework, consisting of a command-line shell and associated scripting language built on .NET Framework. It enables administrators to perform administrative tasks on both local and remote Windows systems.

•

•In PowerShell, administrative tasks are generally performed by cmdlets (pronounced command-lets), which are specialized .NET classes implementing a particular operation. Sets of cmdlets may be combined together in scripts.

Power shell command mode

Important Keyboard Shortcuts

Power shell short cut keys

•Along with the commands, a number of characters in the console have special meanings.

•

Piping: The vertical bar "|" symbol pipes the results of a command to the next.

Ex. Dir | Sort-Object Length | Select-Object Name, Length

•

Redirection: The symbol ">" redirects the results of a command to a file. You can then open and view the file contents. The symbol ">>" appends information to an existing file.

Ex. Help > help.txt

Ex. Help >> help.txt

Interactive Power Shell

•PowerShell as a Calculator- You can use the PowerShell console to execute arithmetic

operations the same way you would with a calculator.

Ex.- 2+4, (12+5) * 3 / 4.5

•Parentheses play a special role in PowerShell as they always works from the inside out:

the results inside the parentheses are produced before evaluating the expressions outside

of the parentheses, i.e. (2*2)*2 = 4*2.

•

•Operators:-

Operator	Description
+	Adds two values
-	Subtracts two values
*	Multiplies two values
/	Divides two values
%	Supplies the rest of division

• Cmdlets: "Genuine" PowerShell Commands- PowerShells internal commands are called 'cmdlets'. The "mother" of all cmdlets is called Get-Command:

syntax:- Get-Command -commandType cmdlet

• Cmdlet names always consist of an action (verb) and something that is acted on (noun). This naming convention helps you to find the right command. Let's take a look at how the system works.

ex. Get-Command -verb get

ex. Get-Command -noun service

The powerful command- “Get-help”

• You can look up help for any cmdlet using Get-Help:

ex. Get-Help Get-Command –detailed

ex. Get-Help Get-service –full

ex. Get-Help Get-service –examples

• You can easily discover commands for certain actions because Get-Command also allows wildcards:

ex. Get-Command *help* -CommandType cmdlet

• Using Named Parameters: Named parameters really work like key-value pairs. You specify the name of a parameter (which always starts with a hyphen), then a space, then the value you want to assign to the parameter.

• Let's say you'd like to list all files with the extension *.exe that are located somewhere in the folder c:\windows or in one of its subdirectories, you could use this command:

ex. Get-ChildItem -path c:\windows -filter *.exe -recurse –name

Note- recurse is one of the most famous parameters meaning: repeat the procedure on sub-folders.

Aliases: Giving Commands Other Names:

• In every day admin life, you want short and familiar commands. This is why PowerShell has a built-in alias system as it comes with a lot of predefined aliases.

Get-ChildItem c:\

Dir c:\

ls c:\

• You can also get the list of aliases using the cmdlet Get-Alias.

• Just use the PowerShell pipeline which feeds the result of a command into the next one and chains together commands.

ex. Get-Alias | Where-Object {$_.Definition -eq "Get-ChildItem"}

• Anyone can create a new alias, which is a shortcut for another command. The cmdlet Set-Alias adds additional alias definitions.

ex. Set-Alias edit notepad.exe

• You can simply delete it using Remove-Item:

ex- Remove-item alias:edit

Variables

• Variables store information temporarily so you can take the information contained in a variable and process it in further steps.

Example1:

# Create variables and assign to values

$amount = 120

$VAT = 0.19

# Calculate:

$result = $amount * $VAT

# Output result

$result

22.8

Example2:

# Replace variables in text with values:

$text = "Net amount $amount matches gross amount $result"

$text

Net amount 120 matches gross amount 142.8

• PowerShell creates new variables automatically so there is no need to specifically "declare“ variables. Simply assign data to a variable. The only thing you need to know is that variable names are always prefixed with a "$".

Assigning and Returning Values:

The assignment operator "=" sets a variable to a specified value. You can assign almost anything to a variable, even complete command results:

Example:

# Temporarily store results of a cmdlet:

$listing = Get-ChildItem c:\

$listing

Populating Several Variables with Values Simultaneously:

You could set a whole series of variables to one shared initial value:

# Populate several variables with the same value in one step:

$a = $b = $c = 1

Exchanging the Contents of Variables:

Traditional Programming-

In traditional programming languages, that would require several steps:

$Value1 = 10

$Value2 = 20

$Temp = $Value1

$Value1 = $Value2

$Value2 = $Temp

Simple steps with Power Shell-

With PowerShell, swapping variable content is much easier. First of all, you can write several statements in one line if you separate the statements from each other by semi-colon. Second, assignment operators will accept several variables on each side that replace each other:

# Exchange variable values:

$Value1 = 10; $Value2 = 20

$Value1, $Value2 = $Value2, $Value1

Overview of Variables in Use:

PowerShell keeps a record of all variable assignments, which is accessible via a virtual drive called variable:

To see all currently defined variables, you should just output this drive to a list:

Dir variable:

Finding Variables:

Dir variable:value*

Dir variable: -include value* -exclude *1*

Verify Whether a Variable Exists:

Similar to files, variables are stored in their own "drive" called variable:and every variable has a path name that you can verify with Test-Path:

Examples:

# Verify whether the variable $value2 exists:

Test-Path variable:\value2

True

# verify whether the variable $server exists:

Test-Path variable:\server

False

Deleting Variables:

Because variables are deleted automatically as soon as you exit PowerShell, you don't necessarily need to clean them up manually. If you'd like to delete a variable immediately, again, do exactly as you would in the file system:

Examples

# create a test variable:

$test = 1

# verify that the variable exists:

Dir variable:\te*

# delete variable:

del variable:\test

# variable is removed from the listing:

Dir variable:\te*

PowerShell Commands Return Arrays

If you store the result of a command in a variable and then output it, you might at first think that the variable contains plain text:

$a = ipconfig

Storing Results in Arrays

This is how you identify arrays:

$a = "Hello"

$a -is [Array]

False

$a = ipconfig

• $a -is [Array]

True

If the result is an array, you can find the number of elements stored in it by using the Count property:

• $a.Count

Creating New Arrays:

You can create your own arrays, too. The easiest way is to use the comma operator:

$array = 1,2,3,4

$array

There's even a special shortcut for sequential numbers:

$array = 1..99

$array

Polymorphic Arrays:

Just like variables, individual elements of an array can store any type of value you assign. This way, you can store whatever you want in an array, even a mixture of different data types. You can separate the elements using commas:

Examples:

$array = "Hello", "World", 1, 2, (Get-Date)

$array

Note:-Parentheses identify a sub-expression and tell PowerShell to evaluate and process it first. So “Get-Date” cmdlet enclosed in a parentheses.

Addressing Array Elements:

Every element in an array is addressed using its index number. Negative index numbers count from last to first. You can also use expressions that calculate the index value:

Examples:

$array[0] $array = -5..12

# Access the first element:

$array[0]

# Access the last element

$array[-1], $array[$array.Count-1],

Choosing Several Elements from an Array:

You can use square brackets to select multiple elements in an array.

# Store directory listing in a variable:

$list = dir

# Output only the 2nd, 5^th and 8th entry:

$list[1,4,7]

Adding Elements to an Array and Removing Them

You can simply use the "+=" operator to do that and then add new elements to an existing array but remove is littlie tricky.

$array += "New Value“

$array=$array|?{$_ -ne “Element to remove”}

PowerShell Pipeline

Pipeline(|) is used for passing the result of one step to next step for execution.

Example:

Dir | Sort-Object Length | Select-Object Name, Length |

ConvertTo-Html | Out-File report.htm

.\report.htm

Formatting Pipeline Results:

Transforming objects produced by the pipeline is carried out by formatting cmdlets. There are four choices:

Get-Command -verb format

Examples-

Dir | Format-Table Name, Length

Grouping Information

Group-Object works by grouping similar objects and then reporting their number.

Get-Service | Group-Object Status

Conditions

Formulating a Condition with Where-Object

The name of a process can be found in the Name property. If you're just looking for the processes of the Notepad, your condition should be name -eq 'notepad'. Now, supply this condition to Where-Object:

Get-Process | Where-Object { $_.name -eq 'notepad' }

Get-Process | Where-Object { $_.company -like 'micro*' } | Format-Table name, description, company

ForEach

The simplest and most useful loop is foreach. These loop performs an operation for each of input objects. For example:

$array = 1,2,3,4,5
$array | ForEach {Write-Host $_}

For

For loop is standard loop to execute a specific number of times

For ($i=1; $i -lt 5; $i++) {Write-Host $i}

While

The While statement performs an operation until the condition is true.

$i = 1
While($i -lt 5) {Write-Host $i; $i++}

While loop can be used in several different variants: do while and do until.

Do while

Do while is executes as long as condition is true but in first time is always execute.

$i = 1
do {Write-Host $i; $i++}
while ($i -lt 5)

Do Until

Do until works almost the same like do while but is executes until the condition is not true.

$i = 1
do {Write-Host $i; $i++}
until ($i -gt 5)

. Net Discussion

TypeError: Failed to execute 'fetch' on 'Window': Request with GET/HEAD method cannot have body.

How to debug Windows Service as a console application in .Net?.

How to debug Windows Service as a console application?.

Step 1: Add a public RunAsConsole method to your service class.

Step 2: Opt out of the ServiceBase when running as a console

Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool

I have a .NET Windows app that is using MSTDC and it is throwing an exception:

Use this for windows Server 2008 r2 and Windows Server 2012 R2

Still Not working Then Use below Enlist=False in the connection string like below

Microsoft.VisualStudio.QualityTools.UnitTestFramework.dll' or one of its dependencies. The system cannot find the file specified.

Microsoft.VisualStudio.QualityTools.UnitTestFramework.dll' or one of its dependencies. The system cannot find the file specified.?

Solutions:

NService Bus publish failed. Check Inner Exception-Exception has been thrown by the target of an invocation.

Introduction to SASS

Limitations with hosting WCF Service on Visual Studio Development Server

Cross browser compatibility - Well-formed HTML in IE8< vs. IE 9

Issue in Javascript function when called from XSLT in IE browser

SSIS Upgrade SQL Server 2012

Server Error in '/CustomReports' Application.

Server Error in '/CustomReports' Application.

Failed to map the path '/'.

Recaptcha Implementation | Need Guidance

Excel exception while opening file from sharepoint

Reading special characters from a flat file

Building .VDPROJ file using Command Line

Microsoft Infopath: Need help

Bulk upload for .xlsx and .csv format

Hosting WCF Services in IIS using MSI

Refresh Cache when data is changed in the the data base using System.Runtime.Caching

Error while running LightSwitch application

The URL-encoded form data is not valid. at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at

timeout error while updating 45k records using sp

URLs from outlook not working issue - Solution!!

What is Regular expression-Why Regular Expression-How Regex Works

What is Regular expression

Why Regular Expression

How Regex Works

Regex Sections

Character Escapes

Character Classes :-

Character Classes regex :-

Anchor:

Learning Windows PowerShell online with easy steps

Variables

Assigning and Returning Values:

Populating Several Variables with Values Simultaneously:

Verify Whether a Variable Exists:

Deleting Variables:

PowerShell Commands Return Arrays

Storing Results in Arrays

Creating New Arrays:

Polymorphic Arrays:

Addressing Array Elements:

Choosing Several Elements from an Array:

Adding Elements to an Array and Removing Them

PowerShell Pipeline

Formatting Pipeline Results:

Conditions

Formulating a Condition with Where-Object

Step 1: Add a public `RunAsConsole` method to your service class.