C# - ComboBox with all countries

I suppose two posts won't hurt anyone, this one will be short don't worry. 

I am learnong C# on the side, and as a learning project  I am currently developing a program to help our Service desk automate Account creations and modifications. One of the fields that I want them to fill out when creating accounts is the Country where the user is located, but I honestly didn't want to trust their typing skills on this so I though I could try to create a drop down menu - or ComboBox as its called in the Toolbox - and I figured I should look online maybe there is a text list that I can find already made. 

It turns out there is a whole reference to get the list that you can use for this. Here is the Sauce where I found the information, and I'll put the information below in case you are looking for a quick answer:

Add reference

using System.Globalization;

Country combobox without list of country with NativeName and so more.

country.CurrencyEnglishName
            country.CurrencyNativeName              
            country.CurrencySymbol
            country.EnglishName
            country.GeoId
            country.ISOCurrencySymbol
            country.ThreeLetterISORegionName
            country.ThreeLetterWindowsRegionName
            country.TwoLetterISORegionName

Code :

private void PopulateCountryComboBox()
        {
            RegionInfo country = new RegionInfo(new CultureInfo("en-US", false).LCID);
            List countryNames = new List();
            foreach (CultureInfo cul in CultureInfo.GetCultures(CultureTypes.SpecificCultures))
            {
                country = new RegionInfo(new CultureInfo(cul.Name, false).LCID);
                countryNames.Add(country.DisplayName.ToString());
            }

            IEnumerable nameAdded = countryNames.OrderBy(names => names).Distinct();

            foreach (string item in nameAdded)
            {
                comboBox1.Items.Add(item);

            }
        }

Country dropdown HTML 

 Afghanistan Ã…Land Islands Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua And Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia And Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Cocos (Keeling) Islands Colombia Comoros Congo Congo, The Democratic Republic Of The Cook Islands Costa Rica Cote D'Ivoire Croatia Cuba Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands (Malvinas) Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern Territories Gabon Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard Island And Mcdonald Islands Holy See (Vatican City State) Honduras Hong Kong Hungary Iceland India Indonesia Iran, Islamic Republic Of Iraq Ireland Isle Of Man Israel Italy Jamaica Japan Jersey Jordan Kazakhstan Kenya Kiribati Korea, Democratic People'S Republic Of Korea, Republic Of Kuwait Kyrgyzstan Lao People'S Democratic Republic Latvia Lebanon Lesotho Liberia Libyan Arab Jamahiriya Liechtenstein Lithuania Luxembourg Macao Macedonia, The Former Yugoslav Republic Of Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia, Federated States Of Moldova, Republic Of Monaco Mongolia Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Palestinian Territory, Occupied Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Poland Portugal Puerto Rico Qatar Reunion Romania Russian Federation Rwanda Saint Helena Saint Kitts And Nevis Saint Lucia Saint Pierre And Miquelon Saint Vincent And The Grenadines Samoa San Marino Sao Tome And Principe Saudi Arabia Senegal Serbia And Montenegro Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia And The South Sandwich Islands Spain Sri Lanka Sudan Suriname Svalbard And Jan Mayen Swaziland Sweden Switzerland Syrian Arab Republic Taiwan, Province Of China Tajikistan Tanzania, United Republic Of Thailand Timor-Leste Togo Tokelau Tonga Trinidad And Tobago Tunisia Turkey Turkmenistan Turks And Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States United States Minor Outlying Islands Uruguay Uzbekistan Vanuatu Venezuela Viet Nam Virgin Islands, British Virgin Islands, U.S. Wallis And Futuna Western Sahara Yemen Zambia Zimbabwe 

Exchange 2010 - Set-MailContact

Today I received a request to upgrade over a 100 contacts to a new external email address as the companies email had change. So for course I would not ever do it manully, and I wrote a script for it. 

$ConfirmPreference = "None"

$contacts = Import-csv 'H:\FILENAME.csv'

Foreach($contact in $contacts)

{

    if($contact.CurrectExternalAddress.Length -gt 0)

    {

        Set-MailContact -Identity $contact.CurrectExternalAddress -ExternalEmailAddress $contact.NewExternalAddress -Confirm:$false -ForceUpgrade

    }

} 

But I just could not get it working automatically, it kept prompting to me to upgrade each contact to 2010. Which is fine, but it was making me press Enter for each change. I looked over it and I tried to do "ConfirmPreference" and "-Confirm:$true/$false" without much success. It wasn't until I read somewhere to try "-Force" that I found the "-ForceUpgrade" which allowed the upgrade to happen without a prompt. 

I honestly had never seen that parameter before. Maybe this will be useful to one of you, and might save you some time. 

Terminal Server has exceeded max number of connections

I received a call requesting assistance one of our users is unable to remote into an SQL server. He is receiving the following error:



I tried to remote as well but received the same error. Then I started researching on how to find the users that are logged in, so that he may communicate with them and ask them to log off, but this brought a very limited amount of information. I found out that the class Win32_LoggedOnUsers doesn't really give you that information, but then I found out that there is a way to bypass the maximum number of connections by using the following command:

%systemroot%\system32\mstsc.exe /admin

Once I logged in I was able to go through the Task Manager and find and log off the extra user, but I was not happy with this solution. I feel like it might not always work. After further looking into this issue I found in Learn-PowerShell that I was able to use the WMI Class Win32_Process to get the Explorer.exe process and get the Owner, thus revealing the logged on users. 

Script found in sauce:

Function Get-WMIComputerSessions {

<#

.SYNOPSIS

    Retrieves tall user sessions from local or remote server/s

.DESCRIPTION

    Retrieves tall user sessions from local or remote server/s

.PARAMETER computer

    Name of computer/s to run session query against.

.NOTES

    Name: Get-WmiComputerSessions

    Author: Boe Prox

    DateCreated: 01Nov2010

.LINK

https://boeprox.wordpress.org

.EXAMPLE

Get-WmiComputerSessions -computer "server1"

Description

-----------

This command will query all current user sessions on 'server1'.

#>

[cmdletbinding(

    DefaultParameterSetName = 'session',

    ConfirmImpact = 'low'

)]

    Param(

        [Parameter(

            Mandatory = $True,

            Position = 0,

            ValueFromPipeline = $True)]

            [string[]]$computer

    )

Begin {

    #Create empty report

    $report = @()

    }

Process {

    #Iterate through collection of computers

    ForEach ($c in $computer) {

        #Get explorer.exe processes

        $proc = gwmi win32_process -computer $c -Filter "Name = 'explorer.exe'"

        #Go through collection of processes

        ForEach ($p in $proc) {

            $temp = "" | Select Computer, Domain, User

            $temp.computer = $c

            $temp.user = ($p.GetOwner()).User

            $temp.domain = ($p.GetOwner()).Domain

            $report += $temp

          }

        }

    }

End {

    $report

    }

}

But I didn't quite need all this so I simply made a one line :




(gwmi win32_process -computer SERVERNAME -Filter "Name = 'explorer.exe'").GetOwner().User 

Now I am able to find out the users that are logged in without having to remote into the server. 

Hope this might help other people out there!