Sunday, September 27, 2015

There are uncommitted transactions. Do you wish to commit these before closing the window?

This happens when ANSI_DEFAULTS is set ON

which enables

SET ANSI_NULLS
SET CURSOR_CLOSE_ON_COMMIT
SET ANSI_NULL_DFLT_ON
SET IMPLICIT_TRANSACTIONS 
SET ANSI_PADDING
SET QUOTED_IDENTIFIER
SET ANSI_WARNINGS

and because of IMPLICIT_TRANSACTIONS transactions that are automatically opened as the result of this setting being ON must be explicitly committed or rolled back by the user at the end of the transaction

so you have to select commit and execute

List of known project type Guids visual studio

C#{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}
VB.NET{F184B08F-C81C-45F6-A57F-5ABD9991F28F}
C++{8BC9CEB8-8B4A-11D0-8D11-00A0C91BC942}
F#{F2A71F9B-5D33-465A-A702-920D77279786}
J#{E6FDF86B-F3D1-11D4-8576-0002A516ECE8}
JScript{262852C6-CD72-467D-83FE-5EEB1973A190}
Web Application{349C5851-65DF-11DA-9384-00065B846F21}
Web Site{E24C65DC-7377-472B-9ABA-BC803B73C61A}
Distributed System{F135691A-BF7E-435D-8960-F99683D2D49C}
Windows Communication Foundation (WCF){3D9AD99F-2412-4246-B90B-4EAA41C64699}
Windows Presentation Foundation (WPF){60DC8134-EBA5-43B8-BCC9-BB4BC16C2548}
Visual Database Tools{C252FEB5-A946-4202-B1D4-9916A0590387}
Database{A9ACE9BB-CECE-4E62-9AA4-C7E7C5BD2124}
Database (other project types){4F174C21-8C12-11D0-8340-0000F80270F8}
Test{3AC096D0-A1C2-E12C-1390-A8335801FDAB}
Legacy (2003) Smart Device (C#){20D4826A-C6FA-45DB-90F4-C717570B9F32}
Legacy (2003) Smart Device (VB.NET){CB4CE8C6-1BDB-4DC7-A4D3-65A1999772F8}
Smart Device (C#){4D628B5B-2FBC-4AA6-8C16-197242AEB884}
Smart Device (VB.NET){68B1623D-7FB9-47D8-8664-7ECEA3297D4F}
Workflow (C#){14822709-B5A1-4724-98CA-57A101D1B079}
Workflow (VB.NET){D59BE175-2ED0-4C54-BE3D-CDAA9F3214C8}
Deployment Merge Module{06A35CCD-C46D-44D5-987B-CF40FF872267}
Deployment Cab{3EA9E505-35AC-4774-B492-AD1749C4943A}
Deployment Setup{978C614F-708E-4E1A-B201-565925725DBA}
Deployment Smart Device Cab{AB322303-2255-48EF-A496-5904EB18DA55}
Visual Studio Tools for Applications (VSTA){A860303F-1F3F-4691-B57E-529FC101A107}
Visual Studio Tools for Office (VSTO){BAA0C2D2-18E2-41B9-852F-F413020CAA33}
SharePoint Workflow{F8810EC1-6754-47FC-A15F-DFABD2E3FA90}
XNA (Windows){6D335F3A-9D43-41b4-9D22-F6F17C4BE596}
XNA (XBox){2DF5C3F4-5A5F-47a9-8E94-23B4456F55E2}
XNA (Zune){D399B71A-8929-442a-A9AC-8BEC78BB2433}
SharePoint (VB.NET){EC05E597-79D4-47f3-ADA0-324C4F7C7484}
SharePoint (C#){593B0543-81F6-4436-BA1E-4747859CAAE2}
Silverlight{A1591282-1198-4647-A2B1-27E5FF5F6F3B}
ASP.NET MVC 1.0{603C0E0B-DB56-11DC-BE95-000D561079B0}
ASP.NET MVC 2.0{F85E285D-A4E0-4152-9332-AB1D724D3325}
ASP.NET MVC 3.0{E53F8FEA-EAE0-44A6-8774-FFD645390401}
ASP.NET MVC 4.0{E3E379DF-F4C6-4180-9B81-6769533ABE47}
Extensibility{82B43B9B-A64C-4715-B499-D71E9CA2BD60}
Store App Windows Phone 8.1{76F1466A-8B6D-4E39-A767-685A06062A39}
Store App Windows Phone 8.1 Silverlight (C#){C089C8C0-30E0-4E22-80C0-CE093F111A43}
Store App Windows Phone 8.1 Silverlight (VB.NET){DB03555F-0C8B-43BE-9FF9-57896B3C5E56}
Store App Windows 8.1{BC8A1FFA-BEE3-4634-8014-F334798102B3}
Store App Universal{D954291E-2A0B-460D-934E-DC6B0785DB48}
Store App Portable Universal{786C830F-07A1-408B-BD7F-6EE04809D6DB}
LightSwitch{8BB0C5E8-0616-4F60-8E55-A43933E57E9C}
LightSwitch Project{581633EB-B896-402F-8E60-36F3DA191C85}
Office/SharePoint App{C1CDDADD-2546-481F-9697-4EA41081F2FC}

Controlling order of serialization in asp net c#

use Order with XmlElement
public class ItemGroup
{
    [XmlElement(Order = 0)]
    public Reference Reference { getset; }
    [XmlElement(Order = 1)]
    public Reference None { getset; }
    [XmlElement(Order = 2)]
    public Reference Content { getset; }
    [XmlElement(Order = 3)]
    public Reference Compile { getset; }
}

The OutputPath property is not set for this project. Please check to make sure that you have specified a valid Configuration/Platform combination

Problem 1

when the OutputPath property of the project file(*.csproj) is blank.

Solution

Provide OutputPath property which normally is \bin\debug or \bin\release


Problem 3

When the OutputPath comes after Import declaration


Solution

Move Imports after all PropertyGroup declarations


A namespace does not directly contain members such as fields or methods

Change the Build Action to None

Saturday, September 26, 2015

How to serialize an object to XML without getting xsi and xsd

To remove namespaces all together

just add

var ns = new XmlSerializerNamespaces();
ns.Add("""");
and then

var xmlSerializer = new XmlSerializer(typeof(Project));

xmlSerializer.Serialize(fs, project, ns);

but if you want to keep xmlns only with xsi and xsd you should add default namespace to XmlSerializer like this

var defaultNamespace = "http://schemas.microsoft.com/developer/msbuild/003";
var xmlSerializer = new XmlSerializer(typeof(Project), defaultNamespace);
 
xmlSerializer.Serialize(fs, project, ns);

Saturday, September 19, 2015

Repeat row value in Cross-Tab crystal report

Create a new formula field.
In this formula field, joint all selected column i.e. column1 & column2 & column3. This will create a field which has all distinct values and include this field in your cross tab before the non repeating column.Now all required values will repeat in each row as you like.
Regards

Tuesday, September 8, 2015

What .NET version are you running (2.0, 4.5, 4.5.1 or 4.5.2)

From .NET 2.0 to 3.5

Right click on C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll and choose properties
Go to Details tab and look at file version

.NET 4.0, 4.5, 4.5.1 and 4.5.2

Right click on C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll and choose properties
Go to Details tab and look at file version