Suppose a structure and an array are created with the code Structure Nation Dim name As String Dim continent As String Dim population As Double 'in millions Dim area As Double 'in square miles End Structure Dim nations(191) As Nation in the Declarations section of the Code editor and the array is filled with data for the 192 member nations of the UN. What will be displayed in the DataGridView control when the following code is executed? Dim query = From country In nations Where (country.continent = "Europe") And country.name.StartsWith("S") Let countryUC = country.name.ToUpper Let pop = FormatNumber(1000000 * country.population, 0) Let area = FormatNumber(country.area, 0) Order By countryUC Ascending Select countryUC, pop, area DataGridView1.DataSource = query.ToList DataGridView1.CurrentCell = Nothing
A.
Three columns, with headers countryUC, pop, and area. The grid will display the countries in Europe (along with their populations and areas) whose names begin with the letter S. The countries will be displayed capitalized in reverse alphabetical order and their populations and areas will be formatted with commas as thousands separators.
B.
Three columns, with headers country , population , and area. The grid will display the countries in Europe (along with their populations and areas) whose names begin with the letter S. The countries will be displayed capitalized in alphabetical order and their populations and areas will be formatted with commas as thousands separators.
C.
Four columns, with headers countryUC, continent, pop, and area. The grid will display the countries in Europe (along with their continents, populations and areas) whose names begin with the letter S. The countries will be displayed capitalized in alphabetical order and their populations and areas will be formatted with commas as thousands separators.
D.
Three columns, with headers countryUC, pop, and area. The grid will display the countries in Europe (along with their populations and areas) whose names begin with the letter S. The countries will be displayed capitalized in alphabetical order and their populations and areas will be formatted with commas as thousands separators.