Dealing with MS SQL Tables that contain Duplicate Rows — DatabaseJournal.comDealing with MS SQL Tables that contain Duplicate RowsBy Gregory A. Larsen Every so often, you might have to deal with tables that contain duplicate rows. In one case, you might only need to identify the duplicate rows. In other cases, you might need to remove the duplicate rows. This article will show you some different techniques for dealing with duplicate...
Monday, June 23, 2014
[ StackOverflow ] - Use ListForEach to add element to HashTable
c# - Use ListForEach to add element to HashTable - Stack Overflow
Try this:
valueList.ForEach(x => htable.Add(valueList.FindIndex(y => y == x), x));
Although, there's really no reason not to use a for here
for(var index =0; index < valueList.Count; index++){
htable.Add(index, valueList[index]);}...
[ StackOverflow ] - Know if an attribute contains a value in HTMLAgilityPack's C# Node Collection
xml - What is the correct XPath for choosing attributes that contain "foo"? - Stack OverflowThe link above is quite interesting for HTMLAgilityPack C# beginners, helps a lot !Another thing to note is that while the XPath above will return the correct answer for that particular xml, if you want to guarantee you only get the "a" elements in element "blah", you should as others have mentioned also use/bla/a[contains(@prop,'Foo')]This...
[ HTML Agility Pack on Codeplex.com ] - Html Agility Pack - Problem selecting within a node
Check out the link for more informationHtml Agility Pack - Problem selecting within a n...
[ Microsoft's MSDN ] - Recommended Tags for Documentation Comments
Recommended Tags for Documentation Comments (C# Programming Guide)The C# compiler processes documentation comments in your code and formats them as XML in a file whose name you specify in the /doc command-line option. To create the final documentation based on the compiler-generated file, you can create a custom tool, or use a tool such as Sandcastle.Here are some Recommended Tags for Documentation Comments<c><para&g...
[ Microsoft's MSDN ] The Summary Tag in C#
(C# Programming Guide)The <summary> tag should be used to describe a type or a type member. Use <remarks> to add supplemental information to a type description. Use the cref Attribute to enable documentation tools such as Sandcastle to create internal hyperlinks to documentation pages for code elements.The text for the <summary> tag is the only source of information about the type in IntelliSense, and is also...
Thursday, June 19, 2014
[ Stack Overflow ] What is the difference between explicit and implicit type casts?
Explicit cast:int x =0;float y =3.8f;
x +=(int) y;//Explicit cast.This tells the compiler that the cast was intentional and that you know that the fractional part will go lost. The compiler won't complain.Implicit cast:int x =0;float y =3.8f;
x += y;//Implicit castThe compiler will complain because the fractional part will be lost when converting float to int.c# - What is the difference between explicit and implicit type casts?...
[ C# Reference ] Explicit Reference
Visual Studio 2013The explicit keyword declares a user-defined type conversion operator that must be invoked with a cast. For example, this operator converts from a class called Fahrenheit to a class called Celsius:explicit (C# Referen...
[ Stack Overflow ] c# - What is the difference between explicit and implicit type casts?
c# - What is the difference between explicit and implicit type casts? - Stack OverflowWhat is the difference between explicit and implicit type casts?What's the difference between the President of the United States and the President of Canada?Since there is no President of Canada, it's hard to answer the question. The right thing to do is to push back and ask for clarification of the question. By "the President of Canada", does...
Friday, June 13, 2014
[ Stack Overflow ] - c# - httpWebRequest (The underlying connection was closed: The connection was closed unexpectedly.)
In beginning coding in C# DotNet, we usually come across such errors, and it's good to look into them, see link below for more detailsc# - httpWebRequest (The underlying connection was closed: The connection was closed unexpectedly.) - Stack Overflow.NET has a bug where it expects that the server will include a Connection: close response header if it will close the connection after the response is complete. If the server closes...
Thursday, June 12, 2014
[ MSDN.Microsoft.com ] The Conditional Operator in CSharp
Check out this page for more details => ?: Operator (C# Reference)int input = Convert.ToInt32(Console.ReadLine());string classify; // if-else construction.if (input > 0) classify = "positive";else classify = "negative";// ?: conditional operator. classify = (input > 0) ? "positive" : "negativ...
[ MSDN.Microsoft.com ] The Conditional Operator in CSharp and how it help in the if-else statement
The condition must evaluate to true or false. If condition is true, first_expression is evaluated and becomes the result. If condition is false, second_expression is evaluated and becomes the result. Only one of the two expressions is evaluated.Either the type of first_expression and second_expression must be the same, or an implicit conversion must exist from one type to the other.You can express calculations that might otherwise...
[ 4GuysFromRolla.com ] Parsing HTML Documents with the Html Agility Pack
The Html Agility Pack contains a number of classes, all in the HtmlAgilityPack namespace. Therefore, start by adding a using statement (or Imports statement if you are using VB) to the top of your code-behind class:Using HtmlAgilityPackTo download a web page from a remote server, use the HtmlWeb class's Load method, passing in the URL to download.[ example ] var webGet = new HtmlWeb();[ example ] var document = webGet.Load(url);The...
Crawling a web sites with HtmlAgilityPack
This is the part that I wanted to lay emphasis onto, as follows:
Linq to Objects approach
public string GetInnerTextWithLinq() { var document = new HtmlDocument(); document.Load(new FileStream("test.html", FileMode.Open)); var node = document.DocumentNode.Descendants("div").Where( d => d.Attributes.Contains("class") && d.Attributes["class"].Value.Contains("required")).SingleOrDefault();...
