    Log.WriteLine(&quot;Value of CompanyName column:&quot; + thisReader[&quot;CompanyName&quot;]); 


You can also do this.

    //find the index of the CompanyName column
    int columnIndex = thisReader.GetOrdinal(&quot;CompanyName&quot;); 
    //Get the value of the column. Will throw if the value is null.
    string companyName = thisReader.GetString(columnIndex);

I want to set the favicon for a fairly large number of pages. But, instead of using the HTML `&lt;head&gt;` tag `&lt;link rel=&quot;shortcut icon&quot; href=&quot;favicon.ico&quot;&gt;`, I&#39;d like to set it in the CSS file. I have limited access to some of the html files, and limited control to their life cycle.

using favicon with css

Given a file with data like this (ie stores.dat file)

    sid|storeNo|latitude|longitude
    2tt|1|-28.0372000t0|153.42921670
    9|2t|-33tt.85t09t0000|15t1.03274200


What is the command that would return the number of occurrences of the &#39;t&#39; character per line?

eg. would return:

    count   lineNum
       4       1
       3       2
       6       3



------------------------------------
Also, to do it by count of occurrences by field what is the command to return the following results? 

eg. input of column 2 and character &#39;t&#39;

    count   lineNum
       1       1
       0       2
       1       3


eg. input of column 3 and character &#39;t&#39;

    count   lineNum
       2       1
       1       2
       4       3

Count occurrences of character per line/field on Unix

I use SqlDataReader.GetValue method to read values from DB:

    Log.WriteLine(&quot;Value of CompanyName column:&quot; + thisReader.GetValue(1)); 

As parameter GetValue get index of column.
How could I specify Column Name instead index?

How to get data by SqlDataReader.GetValue by column name

I use SqlDataReader.GetValue method to read values from DB:
<pre><code class="hljs language-arduino">Log.WriteLine("Value of CompanyName column:" + thisReader.GetValue(1)); 
</code></pre>
As parameter GetValue get index of column.
How could I specify Column Name instead index?

I am doing some performance tests and noticed that a LINQ expression like

    result = list.First(f =&gt; f.Id == i).Property

is slower than

    result = list.Where(f =&gt; f.Id == i).First().Property

This seems counter intuitive.  I would have thought that the first expression would be faster because it can stop iterating over the list as soon as the predicate is satisfied, whereas I would have thought that the `.Where()` expression might iterate over the whole list before calling `.First()` on the resulting subset.  Even if the latter does short circuit it should not be faster than using First directly, but it is. 

Below are two really simple unit tests that illustrate this.  When compiled with optimisation on TestWhereAndFirst is about 30% faster than TestFirstOnly on .Net and Silverlight 4.  I have tried making the predicate return more results but the performance difference is the same.

Can any one explain why `.First(fn)` is slower than `.Where(fn).First()`?  I see a similar counter intuitive result with `.Count(fn)` compared to `.Where(fn).Count()`. 

    private const int Range = 50000;

    private class Simple
    {
       public int Id { get; set; }
       public int Value { get; set; }
    }

    [TestMethod()]
    public void TestFirstOnly()
    {
       List&lt;Simple&gt; list = new List&lt;Simple&gt;(Range);
       for (int i = Range - 1; i &gt;= 0; --i)
       {
          list.Add(new Simple { Id = i, Value = 10 });
       }

       int result = 0;
       for (int i = 0; i &lt; Range; ++i)
       {
          result += list.First(f =&gt; f.Id == i).Value;
       }

       Assert.IsTrue(result &gt; 0);
    }

    [TestMethod()]
    public void TestWhereAndFirst()
    {
       List&lt;Simple&gt; list = new List&lt;Simple&gt;(Range);
       for (int i = Range - 1; i &gt;= 0; --i)
       {
          list.Add(new Simple { Id = i, Value = 10 });
       }

       int result = 0;
       for (int i = 0; i &lt; Range; ++i)
       {
          result += list.Where(f =&gt; f.Id == i).First().Value;
       }

       Assert.IsTrue(result &gt; 0);
    }

Why is LINQ .Where(predicate).First() faster than .First(predicate)?

Recently I&#39;ve been wondering if there is any significant difference between this code:

    public event EventHandler&lt;MyEventArgs&gt; SomeEvent;

And this one:

    public delegate void MyEventHandler(object sender, MyEventArgs e);
    public event MyEventHandler SomeEvent;

They both do the same thing and I haven&#39;t been able to tell any difference.
Although I&#39;ve noticed that most classes of the .NET Framework use a custom event handler delegate for their events. Is there a specific reason for this?

Custom EventHandler vs. EventHandler&lt;EventArgs&gt;

Is there a way to specify that my variable is a short int?
I am looking for something similar to M suffix for decimals. For decimals, I do not have to say

    var d = (decimal)1.23;

I can just write as follows:

    var d = 1.23M;

Is there a way to write this

       var s  = SomeLiteralWithoutCast

so that s is implied to be short int?

How to specify a short int literal without casting?

I have this class

    public class Overloaded
    {
        public void ComplexOverloadResolution(params string[] something)
        {
            Console.WriteLine(&quot;Normal Winner&quot;);
        }

        public void ComplexOverloadResolution&lt;M&gt;(M something)
        {
            Console.WriteLine(&quot;Confused&quot;);
        }
    }

If I call it like this:

            var blah = new Overloaded();
            blah.ComplexOverloadResolution(&quot;Which wins?&quot;);

It writes `Normal Winner` to the console. 

But, if I add another method:

        public void ComplexOverloadResolution(string something, object somethingElse = null)
        {
            Console.WriteLine(&quot;Added Later&quot;);
        }

I get the following error:

&gt; The call is ambiguous between the following methods or properties:   &gt; &#39;`Overloaded.ComplexOverloadResolution(params string[])`&#39; and &#39;`Overloaded.ComplexOverloadResolution&lt;string&gt;(string)`&#39;

I can understand that adding a method might introduce a call ambiguity, but it&#39;s an ambiguity between the two methods that already existed `(params string[])` and `&lt;string&gt;(string)`! Clearly neither of the two methods involved in the ambiguity is the newly added method, because the first is a params, and the second is a generic.

Is this a bug? What part of the spec says that this should be the case?

Why would adding a method add an ambiguous call, if it wouldn&#39;t be involved in the ambiguity

When I was working in enterprise, we used multiple projects in the solution - projects for UI, business logic, data access, database and printing.  Now I&#39;m in a new enterprise and the manager tells me that I don&#39;t have to make all these projects, but that I have to make them into seperate directories in one project in the solution.

I just want to know if I have to convince him to use multiple projects! 

What are the benefits of multiple projects and one solution?

How can we  check in a SQL Server `WHERE` condition whether the column is not null and not the empty string (`&#39;&#39;`)?
 

How to check for Is not Null And Is not Empty string in SQL server?

I want a random selection of rows in PostgreSQL, I tried this:

    select * from table where random() &lt; 0.01;

But some other recommend this:

    select * from table order by random() limit 1000;

I have a very large table with 500 Million rows, I want it to be fast.

Which approach is better?  What are the differences?  What is the best way to select random rows?

Best way to select random rows PostgreSQL

What is the difference between a natural join and an inner join?

Difference between natural join and inner join

Is it possible to rename a constraint in SQL Server? I don&#39;t want to have to delete and create a new one because this constraint affects other already existing constraints and I will have to recreate/alter those.

Rename a constraint in SQL Server?

I have a `books` table with a `returned_date` column. I&#39;d like to see the results for all of the books with a returned date that occurred in the past week.

Any thoughts? I tried doing some date math, but Postgres wasn&#39;t happy with my attempt.

Content Type	Original Author	Original Content on Stackoverflow
Question	algot	View Question on Stackoverflow
Solution 1 - C#	Mauricio Scheffer	View Answer on Stackoverflow
Solution 2 - C#	Ray	View Answer on Stackoverflow
Solution 3 - C#	user6943463	View Answer on Stackoverflow

How to get data by SqlDataReader.GetValue by column name

C# Problem Overview

C# Solutions

Solution 1 - C#

Solution 2 - C#

Solution 3 - C#

Count occurrences of character per line/field on Unix

using favicon with css

Attributions