{"id":128323,"date":"2023-05-04T16:42:43","date_gmt":"2023-05-04T11:12:43","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=128323"},"modified":"2024-04-12T14:15:25","modified_gmt":"2024-04-12T08:45:25","slug":"returning-the-country-names-with-no-repeats","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/","title":{"rendered":"Returning the Country Names with no Repeats"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong>Returning the Country Names with no Repeats<\/strong><\/h4>\n\n\n\n<p>To return the country names with no repeats from the Customers table in the Northwind database, you can use the DISTINCT keyword in your SQL query. Here&#8217;s an example query:<\/p>\n\n\n\n<p>SELECT DISTINCT Country FROM Customers ORDER BY Country<\/p>\n\n\n\n<p>This query retrieves all distinct values of the &#8220;Country&#8221; column from the &#8220;Customers&#8221; table and orders them alphabetically by country name.<\/p>\n\n\n\n<p>In ASP.NET, you can execute this query using a SqlCommand object and read the results using a SqlDataReader object. Here&#8217;s an example:<\/p>\n\n\n\n<p>string connectionString = ConfigurationManager.ConnectionStrings[&#8220;NorthwindConnectionString&#8221;].ConnectionString;<\/p>\n\n\n\n<p>string query = &#8220;SELECT DISTINCT Country FROM Customers ORDER BY Country&#8221;;<\/p>\n\n\n\n<p>List&lt;string&gt; countryNames = new List&lt;string&gt;();<\/p>\n\n\n\n<p>using (SqlConnection connection = new SqlConnection(connectionString))<\/p>\n\n\n\n<p>{<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; SqlCommand command = new SqlCommand(query, connection);<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; connection.Open();<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; SqlDataReader reader = command.ExecuteReader();<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; while (reader.Read())<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; {<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string countryName = reader.GetString(0);<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; countryNames.Add(countryName);<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; }<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; reader.Close();<\/p>\n\n\n\n<p>}<\/p>\n\n\n\n<p>\/\/ Do something with the list of country names, such as binding it to a control<\/p>\n\n\n\n<p>In this example, the query is executed using a SqlCommand object and the SqlDataReader object is used to read the results. The values of the &#8220;Country&#8221; column are added to a list of strings using the GetString method of the SqlDataReader object. Finally, the list of country names can be used in your application, such as by binding it to a control.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Apply for ASP.NET Certification Now!!<\/h3>\n\n\n\n<p><a href=\"https:\/\/www.vskills.in\/certification\/certified-aspnet-programmer\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.vskills.in\/certification\/certified-aspnet-programmer<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/asp-net\/\" target=\"_blank\" rel=\"noreferrer noopener\">Back to Tutorial<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>Returning the Country Names with no Repeats To return the country names with no repeats from the Customers table in the Northwind database, you can use the DISTINCT keyword in your SQL query. Here&#8217;s an example query: SELECT DISTINCT Country FROM Customers ORDER BY Country This query retrieves all distinct values of the &#8220;Country&#8221; column&#8230;<\/p>\n","protected":false},"author":22,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[3339],"tags":[],"class_list":["post-128323","page","type-page","status-publish","hentry","category-asp-net-2"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Returning the Country Names with no Repeats - Tutorial<\/title>\n<meta name=\"description\" content=\"Returning the Country Names with no Repeats\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Returning the Country Names with no Repeats - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Returning the Country Names with no Repeats\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:45:25+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/\",\"name\":\"Returning the Country Names with no Repeats - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2023-05-04T11:12:43+00:00\",\"dateModified\":\"2024-04-12T08:45:25+00:00\",\"description\":\"Returning the Country Names with no Repeats\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Returning the Country Names with no Repeats\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Returning the Country Names with no Repeats - Tutorial","description":"Returning the Country Names with no Repeats","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/","og_locale":"en_US","og_type":"article","og_title":"Returning the Country Names with no Repeats - Tutorial","og_description":"Returning the Country Names with no Repeats","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:45:25+00:00","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/","name":"Returning the Country Names with no Repeats - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2023-05-04T11:12:43+00:00","dateModified":"2024-04-12T08:45:25+00:00","description":"Returning the Country Names with no Repeats","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/returning-the-country-names-with-no-repeats\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Returning the Country Names with no Repeats"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=128323"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128323\/revisions"}],"predecessor-version":[{"id":128327,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128323\/revisions\/128327"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=128323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=128323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=128323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}