System.Net.WebException: The operation has timed out

I have modified below values in my Web.config, it has resolved my issue.

  <httpRuntime maxRequestLength="60000000" executionTimeout="60000000" />

 <requestFiltering>
       <requestLimits maxAllowedContentLength="60000000" />
     </requestFiltering>

Then you need to change applicationHost.config

open the %windir%\System32\inetsrv\config\applicationHost.config file

Change this:

From
<section name="requestFiltering" overrideModeDefault="Deny" />

To

<section name="requestFiltering" overrideModeDefault="Allow" />

If still you are facing error..try this..

HttpServerConnection objConn;
objConn.Timeout = 60000000;
ServicePointManager.MaxServicePointIdleTime = 60000000;

Ref:http://ajaxuploader.com/large-file-upload-iis-debug.htm

aras innovator System.Net.WebException: The operation has timed out

Case 1:
If you are using StreamReader or any request objects, you need to close it.

  HttpWebRequest r = WebRequest.Create("URL");
        HttpWebResponse w = r.GetResponse()

Close that objects..
 w.Close(); // Close connection  here.

Case 2: You are running your code from remote system, which is giving time out error..

Case 3: Your AML might be very big, split your AML in to 2 and try it..
Case 4: Your AML might be very big, split your AML in to 2 and try it and try to get only properties which are required in the select, if you don't specify the properties, aras will get all properties which will give time out error

Windows will report error #1053

Srvany is a utility developed by Microsoft that can start almost any regular, non-service application as a Windows Service.

Since a Windows Service must be specially constructed to interface with the operating system (to allow Windows to start, stop or pause it on demand), a regular application without this interface will not function properly as a Service. To solve the problem, Microsoft developed Srvany - an "adapter" (or "wrapper") that can accept the Windows Service commands and translate those into actions that a regular executable can understand.

Like any good adapter, Srvany is installed in between Windows and the application and handles all interaction between them. For example, when Windows says "Start the service", Srvany intercepts the request and starts the application as if you had double-clicked on it yourself.

Srvany was developed in the late 1990's for Windows NT and remains mostly unchanged to this day. It is available as part of the Windows Server 2003 Resource Kit Tools package.

Ref: http://www.coretechnologies.com/WindowsServices/FAQ.html#WhatIsSrvany

create service to run exe file

Open Command Prompt
Go to this path: C:\Windows\SysWOW64>
Type: sc.exe
 You will get all help commands..

To create a service you have to use..

sc.exe create  command

Ex: 

sc.exe create ServiceName binPath= "D:\myexeFile.exe" DisplayName= "MyService"

Make sure you give space after =

sc.exe start ServiceName
sc.exe stop ServiceName
sc.exe delete ServiceName

Good one: https://www.youtube.com/watch?v=X6o1AvZ06zc

Aras innovator is current value is 1 for all rows

When i update an item in aras innovator, it was creating new row in the database and when i check the aras  is_current value, it was 1 for all rows.

Root Cause: you have not enabled Versionable
Solution: It should be 1 for latest row

Open Aras innovator
Go to Administration
Go to System Events--> Item Types
Search for your Item type.
Open it.
Unlock
Check "Versionable" check box
Save

Now you will see only one row  is_current =1

The type initializer for 'MyClass' threw an exception

Solution:

This problem can be caused if a class tries to get value of a key in web.config or app.config which is not present there.

An error occurred. Detailed message: 2 conflicts prevent checkout

Git error: An error occurred. Detailed message: 2 conflicts prevent checkout
Solution:

Close all your solutions
Open new visual studio
Connect to team foundation server
Connect to Git
Click on Home
Go to changes
If you see any Untracked files, those file are giving problem to you...
Take the back up of all your projects<Code>
Now delete Untracked files from Git.
Now Pull and sync

C# Translating from One XML Schema to Another

Input XML

	<?xml version="1.0"?>
	<investments>
	<item type="stock" exch="nyse" symbol="ZCXM" company="zacx corp"
	price="28.875"/>
	<item type="stock" exch="nasdaq" symbol="ZFFX" company="zaffymat inc"
	price="92.250"/>
	<item type="stock" exch="nasdaq" symbol="ZYSZ" company="zysmergy inc"
	price="20.313"/>
	</investments>

view raw gistfile1.xml hosted with ❤ by GitHub

Translator

	using System;
	using System.Collections.Generic;
	using System.IO;
	using System.Linq;
	using System.Web;
	using System.Web.UI;
	using System.Web.UI.WebControls;
	using System.Xml;
	using System.Xml.Linq;
	namespace XMLtoXML
	{
	public partial class Translate : System.Web.UI.Page
	{
	protected void Page_Load(object sender, EventArgs e)
	{
	//Input XML
	string strInputXMLPath = "C:\\input.xml";
	//Conver XML to string
	string strInputXML = File.ReadAllText(strInputXMLPath);
	//strInputXML = strInputXML.Replace("&", "&"); //Replace special charecters..
	//Create XElement using XML string
	File.WriteAllText("dummy.xml", strInputXML);
	XElement inputXMLdummy = XElement.Load("dummy.xml");
	//Create OutPut XML
	//Create Output XML XElement
	XDocument outPutDoc = new XDocument();
	XElement outPutRoot = new XElement("portfolio");
	outPutDoc.Add(outPutRoot);
	//Read all nodes in dummy XML
	IEnumerable<XElement> dummyXMLNodes =
	from ele in inputXMLdummy.Elements()
	select ele;
	//Iterate each node in dummy XML
	foreach (XElement element in dummyXMLNodes)
	{
	outPutRoot = OutPutXML(outPutRoot, element);
	}
	//Now we have out put xml in outPutDoc object
	//Now save outPutDoc as XML
	string strOutPutXMLPathwithName = "C:\\output.xml";
	XmlWriterSettings settings = new XmlWriterSettings();
	settings.Indent = true;
	settings.NewLineOnAttributes = true;
	settings.OmitXmlDeclaration = false;
	XmlWriter writer = XmlWriter.Create(strOutPutXMLPathwithName, settings);
	outPutDoc.Save(writer);
	writer.Close();
	}
	public static XElement OutPutXML(XElement outPutRoot, XElement inputElementNode)
	{
	var varInputElementNode = XElement.Parse(inputElementNode.ToString());
	//Create new XElement for stock
	XElement outputStockElement = new XElement("stock");
	//Add exchange attribute for stock node, attribute name as exchange and value from input exch
	outputStockElement.SetAttributeValue("exchange", varInputElementNode.Attribute("exch").Value);
	//Add stock to portfolio (root)
	outPutRoot.Add(outputStockElement);
	//Create new XElement for name
	XElement outputNameElement = new XElement("name");
	//Set value for name
	outputNameElement.SetValue(varInputElementNode.Attribute("company").Value);
	//Add name to stock
	outputStockElement.Add(outputNameElement);
	//Create new XElement for symbol
	XElement outputSymbolElement = new XElement("symbol");
	//Set value for symbol
	outputSymbolElement.SetValue(varInputElementNode.Attribute("symbol").Value);
	//Add symbol to stock
	outputStockElement.Add(outputSymbolElement);
	//Create new XElement for price
	XElement outputPriceElement = new XElement("price");
	//Set value for price
	outputPriceElement.SetValue(varInputElementNode.Attribute("price").Value);
	//Add price to stock
	outputStockElement.Add(outputPriceElement);
	return outPutRoot;
	}
	}
	}

view raw gistfile1.cs hosted with ❤ by GitHub

Output XML

	<?xml version="1.0"?>
	<portfolio>
	<stock exchange="nyse">
	<name>zacx corp</name>
	<symbol>ZCXM</symbol>
	<price>28.875</price>
	</stock>
	<stock exchange="nasdaq">
	<name>zaffymat inc</name>
	<symbol>ZFFX</symbol>
	<price>92.250</price>
	</stock>
	<stock exchange="nasdaq">
	<name>zysmergy inc</name>
	<symbol>ZYSZ</symbol>
	<price>20.313</price>
	</stock>
	</portfolio>

view raw gistfile1.xml hosted with ❤ by GitHub

You have insufficient permissions to perform 'add' operation." type="Aras.Server.Core.InsufficientPermissionsException”

Go to Aras Innovator UI

Click on Administrator -->Item Type

Search for “Manufacturer Part”

Select Manufacturer Part

Unlock

In the properties windows : “Can Add” you will find

Click on “Can Add”

Click on + icon

Search for Administrator

Add Administrator

Search for Component*

Add Component  Engineer

Save

Lock.

SQL Error String or binary data would be truncated. The statement has been terminated.

message =" String or binary data would be truncated. The statement has been terminated. " type =" System.Data.SqlClient.SqlException "

Root Cause:
Some if your input data is exceeding the length of the column.
In My came, i was having one column with name and length as 100, but i was sending 110 length name to database.

Solution: Increase the column size or trim input value..

Download SharePoint Server 2013

http://www.microsoft.com/en-us/evalcenter/evaluate-sharepoint-server-2013

Run Exe from bat file

Create a .bat file. ex: MyApp.bat
Call powershell script from batch file.

	@Set exePath="C:\My.exe"
	Echo "Call PS1"
	PowerShell.exe Set-ExecutionPolicy RemoteSigned; "C:\MyScript.PS1" -exePath %exePath%
	Echo "End PS1"
	PAUSE

view raw gistfile1.ps1 hosted with ❤ by GitHub

Now create a PS1 script ex" MyScript.PS1

Calling exe from Powershell

	Param
	(
	[string]$exePath = $null
	)
	write-host “Calling exe”
	$startTime = Get-Date
	Write-Host "Start time " + $startTime.ToString("u")
	$exePath = $exePath
	& $exePath
	$endTime = Get-Date
	Write-Host "End time " + $endTime.ToString("u")
	write-host “End exe”

view raw gistfile1.ps1 hosted with ❤ by GitHub

Powershell script to run exe

	cls
	$startTime = Get-Date
	Write-Host "Start " + $startTime.ToString("u")
	$exePath = "C:\My.exe"
	& $exePath
	$endTime = Get-Date
	Write-Host "End " + $endTime.ToString("u")

view raw gistfile1.ps1 hosted with ❤ by GitHub

C# Deploy Class library with app config

While developing Class library, add app config and add all parameters.
Use all parameters in u r class library.
Now build, you will get dll (Run in release mode)

Now copy all dlls, exe and exe.config (Important), no need of app.config
Paste in to server.(All your config values will be available in exe.config)
Now run the exe from server.
Your code will execute...

Deployment using power-shell and batch file.
http://microsoft-techies.blogspot.com/2015/04/run-exe-from-bat-file.html

Open Event Viewer and Export logs to CSV file

Right-click the "Computer" icon on the desktop. If the "Computer" icon is not on the desktop, click the "Start" button to locate the "Computer" icon from within the Start Menu programs.

Click "Manage" from the options box to open the Computer Management Tools console

Click the right-facing arrow in front of the group "Event Viewer" to open the available Event Viewer logs

 Right-click the log to be exported, such as the "Security event log." From the available options, click "Save all Events as... ."

Click the down arrow in the "Save as type:" box and select "CSV (Comma Separated Value) (*CSV)."

 Click in the "File name:" box and type a file name and save location for the file. For example: "c:\SecurityEventLog" will save the file called SecurityEventLog and place it on the C: drive.

 Click "Save" to save the CSV file to the C: drive.
 Close the Computer Management Console by clicking the "X" in the upper right-hand corner of the console box.


Open CSV File in Excel and Sort by Event ID

1.Open CSV file. Select column data.
2.Click on Data in the top.
3.Click on Text to Columns

4. Select "Delimited" in the Wizard and click "Next."

5. Select "Comma" and deselect "Tab" under the Delimiters options and click "Next."

6. Select "General" under the Column data format box and click "Finish" to open the Event Viewer log in Excel.

7. Click on the "Event ID" column heading to highlight the entire column of Event IDs.

8. Click "Data" from the menu options at the top of the Excel application.

9. Click "Sort" from the Data menu tab, select "Expand the selection" when the Sort Warning box appears and click "Sort."

10. Click "Event ID" in the "Sort by" drop-down box, specify the sort order by selecting from the available options under the "Order" drop-down box and click "OK."

11. Review the list of Windows event IDs in Excel and save the file for future use.

Add custom revision ids in Aras Innovator

Open Aras
Go to Administration -->Revision
Right click "New Revision.."
Enter any name: CustomPartRevision
Under Revisions, Provide values: 1 2 3 4 5 6 7 8 9 10 11
your wish
A1 A2 A3 A4 A5
Save.

Now map above revision to Part.

Go to Administration -->ItemType
Run
Select Part
Unlock
Under revisions
Select ...
Run
Select new one
Save

You can do same way for Document and other Items...

c# xml to string

 string strIp = File.ReadAllText("c:\\a.xml");

Difference between Asp.Net and SharePoint execution

ASP.Net

SharePoint

c# xml to string XmlNodeType.EndElement is null

	XmlTextReader objreader = new XmlTextReader("c:\\a.xml");
	StringBuilder strBuilXML = new StringBuilder();
	while (objreader.Read())
	{
	if (objreader.IsStartElement())
	{
	if (objreader.IsEmptyElement)
	{
	Console.WriteLine("<{0}/>", objreader.Name);
	strBuilXML.Append("<" + objreader.Name);
	for (int attInd = 0; attInd < objreader.AttributeCount; attInd++)
	{
	objreader.MoveToAttribute(attInd);
	strBuilXML.Append(" " + objreader.Name + "=");
	strBuilXML.Append("\"" + objreader.Value + "\"");
	}
	strBuilXML.Append(">");
	strBuilXML.Append("</" + objreader.Name);
	strBuilXML.Append(">");
	}
	else
	{
	switch (objreader.NodeType)
	{
	case XmlNodeType.Element:
	strBuilXML.Append("<" + objreader.Name);
	for (int attInd = 0; attInd < objreader.AttributeCount; attInd++)
	{
	objreader.MoveToAttribute(attInd);
	strBuilXML.Append(" " + objreader.Name + "=");
	strBuilXML.Append("\"" + objreader.Value + "\"");
	}
	strBuilXML.Append(">");
	break;
	case XmlNodeType.Text:
	string value = objreader.Value;
	if (string.IsNullOrEmpty(value))
	{
	strBuilXML.Append("</" + objreader.Name);
	strBuilXML.Append(">");
	break;
	}
	else
	strBuilXML.Append(value);
	break;
	case XmlNodeType.EndElement:
	strBuilXML.Append("</" + objreader.Name);
	strBuilXML.Append(">");
	break;
	}
	}
	}
	}
	objreader.Close();
	Console.WriteLine(strBuilXML);

view raw gistfile1.cs hosted with ❤ by GitHub

Visual Studio 2013 git, only Master branch listed

One of my team member has created new branch, now i want to use that branch.
When i open Visual Studio, i am able to see only master branch.
Solution:
Open Visual Studio
Connect to TFS
Click on Home.
Click on Branches
Click on Actions
Open command prompt
Type this command:
git checkout <Your Branch Name>
Or
Click on the the New Branch dropdown, and you will see all the remote branches.
Enter your Branch Name
Create Branch
Now you will see your branch.

There is an error in XML document (2,

I was trying to read XML file.
I have converted XML in to string, then i have Deserialize the string.
I was getting above error.

Solution:
While reading XML in to string, some of the XML values are decoding.
So those values are giving the error,i replaced actual values...

    XmlTextReader strreader = new XmlTextReader("c:\myxml.xml");
string temp = strreader.Value;

temp = temp.Replace("'", "&apos;").Replace("&", "&amp;").Replace("\"", "&quot;").Replace(">", "&gt;").Replace("<", "&lt;");

Ref more: http://microsoft-techies.blogspot.com/2015/04/read-special-characters-back-from.html

Read special characters back from XmlDocument in c#

	To Get escapded values
	public string EscapeXMLValue(string value)
	{
	if (string.IsNullOrEmpty(s)) return s;
	string temp = s;
	temp = temp.Replace("'","&apos;").Replace( "\"", "&quot;").Replace(">","&gt;").Replace( "<","&lt;").Replace( "&","&amp;");
	return temp ;
	}
	To get the unescaped value
	public string UnescapeXMLValue(string xmlValue)
	{
	if (string.IsNullOrEmpty(s)) return s;
	string temp = s;
	temp = temp.Replace("&apos;", "'").Replace("&quot;", "\"").Replace("&gt;", ">").Replace("&lt;", "<").Replace("&amp;", "&");
	return temp ;
	}

view raw gistfile1.cs hosted with ❤ by GitHub

Convert class library function into exe?

In the properties of the project -> application tag, change the Output type to console Application.
You need to create a static Main() method as a starting point.

static void Main(string[] args)
    {
    }

c# linq sequence contains no elements

c# linq sequence contains no elements
Where condition on List using linq
Solution:

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Web;
	using System.Web.UI;
	using System.Web.UI.WebControls;
	namespace Test.linq
	{
	public partial class WebForm1 : System.Web.UI.Page
	{
	public List<Cars> myCars = new List<Cars>{
	new Cars(){Name="Honda",Color="Red"},
	new Cars(){Name="Nisan",Color="Red"},
	new Cars(){Name="Toyota",Color="Silver"},
	new Cars(){Name="BMW",Color="Black"}
	};
	protected void Page_Load(object sender, EventArgs e)
	{
	//Find my car color from myCars list
	int iIndex = 0;
	//First i am checking whether my Car is exist or not in myCars list.
	var idump = myCars.FirstOrDefault(p => p.Name == "Honda");
	//If exist it will not be null or it will be null
	if (idump != null)
	{
	iIndex = myCars.Select((Value, Index) => new { Value, Index }).Single(p => p.Value.Name == "Honda").Index;
	}
	else
	{
	iIndex = -1;
	}
	if (iIndex != -1)
	{
	string strCarColor = myCars[iIndex].Color.ToString();
	Response.Write("Your car color" + strCarColor);
	}
	else
	{
	Response.Write("Your car is no available.");
	}
	}
	}
	public class Cars
	{
	public string Name { get; set; }
	public string Color { get; set; }
	}
	}

view raw gistfile1.cs hosted with ❤ by GitHub

c# dictionary add if not exist

	if (variables == null)
	{
	variables = new Dictionary<string, object>();
	}
	if(variables.ContainsKey(name))
	{
	variables[name] = value;
	}
	else
	{
	Debug.LogError("Added new Data to Global Data"+value);
	variables.Add(name,value);
	}

view raw gistfile1.cs hosted with ❤ by GitHub

c# xml read There is an error in XML document (2, 2).

This is my xml
<?xml version='1.0' encoding='utf-16'?>
<Message>
<FirstName>Hunt</FirstName>
<LastName>DAvid</LastName>
</Message>
This is my code...
string xml = File.ReadAllText("c:\\Message.xml");
var result = DeserializeFromXml<Message>(xml);
I was getting error..
Solution:
Message class is missing XmlRoot

[Serializable, XmlRoot("Message")]
public class Message
{
public string FirstName { get; set; }
public string LastName { get; set; }
}

Delete a Git branch both locally and remotely

To delete any branch from VSO, you have to enable Alternate Authentication Credentials
Open VSO web browser.
Click on your name in the top right
Click on My Profile
Click on Credentials
Configure Alternate Authentication Credentials
Now open Visual Studio
Connect VSO.
Click on Team Explorer
Click on Home
Click on Branches
Click on Actions
Click on Open Command prompt
Now run below command to delete branch from GIT
git push origin --delete <Branch Name>

dataSet.GetXml() doesn't return xml for null or blank columns

	First clone the DataTable, make all columns of type string, replace all null values with string.empty, then call GetXml on a new DataSet.
	//First bind XML data in to data set..objDataSet
	DataTable dt = objDataSet.Tables[0];
	DataTable dtCloned = dt.Clone();
	foreach (DataColumn dc in dtCloned.Columns)
	dc.DataType = typeof(string);
	foreach (DataRow row in dt.Rows)
	{
	dtCloned.ImportRow(row);
	}
	foreach (DataRow row in dtCloned.Rows)
	{
	for (int i = 0; i < dtCloned.Columns.Count; i++)
	{
	dtCloned.Columns[i].ReadOnly = false;
	if (string.IsNullOrEmpty(row[i].ToString()))
	row[i] = string.Empty;
	}
	}
	DataSet ds = new DataSet();
	ds.Tables.Add(dtCloned);
	string xml = ds.GetXml();

view raw gistfile1.cs hosted with ❤ by GitHub

C# XML Deserialize in to Object - xmlns='' was not expected

<root element xmlns=''> was not expected.
{" was not expected.} XML Deserialize in C#

	XmlRootAttribute xRoot = new XmlRootAttribute();
	xRoot.ElementName = "RootElementName";
	xRoot.IsNullable = true;
	XmlSerializer objSer = new XmlSerializer(typeof(Result), xRoot);
	FileStream objF = new FileStream("C:\\a.xml", FileMode.Open);
	Result varResult = (Result)serializer.Deserialize(objF);

view raw gistfile1.cs hosted with ❤ by GitHub

Change from standalone="yes"?> encoding="utf-8" ?>

Change from <?xml version="1.0" standalone="yes"?>  to <?xml version="1.0" encoding="utf-8" ?>

If you use Dataset.WriteXml("C:\\a.xml"); you will get  <?xml version="1.0" standalone="yes"?>

 objDataSet.WriteXml("C:\\a.xml");


If you use ..you will get <?xml version="1.0" encoding="utf-8" ?>

 XmlWriterSettings settings = new XmlWriterSettings();
                            settings.OmitXmlDeclaration = false;
                            XmlWriter objwriter = XmlWriter.Create("C:\\a.xml", settings);
                            objDataSet.WriteXml(objwriter);
                            objwriter.Close();

There are multiple root elements. Line 1, position 33

Solution:

Some where you are closing your element tag.
Ex:
Error: <Root/><Child>Hi</Child></Root>
Correct: <Root><Child>Hi</Child></Root>

C# XML read and remove namespace

	XmlDocument xmlD = new XmlDocument();
	xmlD.Load("C:\\a.xml");
	string strxml = xmlD.OuterXml.ToString();
	Regex regEx = new Regex(@"< \?xml.*?\?>");
	strxml = regEx.Replace(strxml, " ");

view raw gistfile1.txt hosted with ❤ by GitHub

DataSet WriteXML generates 'NewDataSet' root element

Solution:

 System.Data.DataSet myDs = new System.Data.DataSet("MyRoot");

c# convert excel to xml

	OleDbConnection objConnection;
	DataSet objDs;
	OleDbDataAdapter objCommand;
	string strExcelPath = "C:\\MyExcel.xlsm";
	if (Path.GetExtension(strExcelPath) == ".xls")
	{
	objConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strExcelPath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"");
	}
	else if (Path.GetExtension(strExcelPath) == ".xlsx")
	{
	objConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strExcelPath + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';");
	}
	else if (Path.GetExtension(strExcelPath) == ".xlsm")
	{
	objConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strExcelPath + ";Extended Properties='Excel 12.0 Macro;IMEX=1;';");
	}
	objCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", objConnection);
	objCommand.TableMappings.Add("Table", "Product");
	objDs = new System.Data.DataSet();
	objCommand.Fill(objDs);
	objConnection.Close();
	objDs.WriteXml("Product.xml");

view raw gistfile1.cs hosted with ❤ by GitHub

C# read excel OleDbConnection connection for .xls and .xlsx

	using System.Threading.Tasks;
	using System.Data.OleDb;
	using System.Data;
	using System.IO;
	//Code
	OleDbConnection oledbConn;
	string path = "C:\\MyExcel.xlsx";
	if (Path.GetExtension(path) == ".xls")
	{
	oledbConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"");
	}
	else if (Path.GetExtension(path) == ".xlsx")
	{
	oledbConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';");
	}
	oledbConn.Open();

view raw gistfile1.cs hosted with ❤ by GitHub