{"id":128251,"date":"2023-05-04T16:14:42","date_gmt":"2023-05-04T10:44:42","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=128251"},"modified":"2024-04-12T14:15:25","modified_gmt":"2024-04-12T08:45:25","slug":"adding-the-northwind-database-to-your-application","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/","title":{"rendered":"Adding the Northwind Database to Your Application"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong>Adding the Northwind Database to Your Application<\/strong><\/h4>\n\n\n\n<p>To add the Northwind database to your ASP.NET application, you can follow these general steps:<\/p>\n\n\n\n<p>Download a copy of the Northwind database, as described in the previous answer.<\/p>\n\n\n\n<p>Restore the Northwind database to your SQL Server instance using SQL Server Management Studio or another tool. This will create the database on the server and populate it with tables and data.<\/p>\n\n\n\n<p>In your ASP.NET application, add a connection string to your web.config file that specifies the server name, database name, and any other necessary connection parameters. For example:<\/p>\n\n\n\n<p>&lt;connectionStrings&gt;<\/p>\n\n\n\n<p>&nbsp; &lt;add name=&#8221;NorthwindConnectionString&#8221; connectionString=&#8221;Data Source=SERVERNAME;Initial Catalog=Northwind;Integrated Security=True;&#8221; providerName=&#8221;System.Data.SqlClient&#8221; \/&gt;<\/p>\n\n\n\n<p>&lt;\/connectionStrings&gt;<\/p>\n\n\n\n<p>Replace SERVERNAME with the appropriate value for your SQL Server instance.<\/p>\n\n\n\n<p>In your application code, create an instance of the SqlConnection class and pass in the connection string:<\/p>\n\n\n\n<p>SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[&#8220;NorthwindConnectionString&#8221;].ConnectionString);<\/p>\n\n\n\n<p>Open the connection:<\/p>\n\n\n\n<p>connection.Open();<\/p>\n\n\n\n<p>Use the connection object to execute SQL commands against the Northwind database, such as queries or updates:<\/p>\n\n\n\n<p>SqlCommand command = new SqlCommand(&#8220;SELECT * FROM Customers&#8221;, connection);<\/p>\n\n\n\n<p>SqlDataReader reader = command.ExecuteReader();<\/p>\n\n\n\n<p>while (reader.Read())<\/p>\n\n\n\n<p>{<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; \/\/ do something with the data<\/p>\n\n\n\n<p>}<\/p>\n\n\n\n<p>Close the connection when you&#8217;re finished:<\/p>\n\n\n\n<p>connection.Close(); Note that in this example, I&#8217;ve used Integrated Security=True in the connection string, which means that the connection will use Windows Authentication to log in to the database. If you need to use SQL Server authentication instead, you&#8217;ll need to include a User ID and Password in the connection string. Also, be sure to replace &#8220;Customers&#8221; in the example query with the appropriate table or view name from the Northwind database that you want to work with.<\/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>Adding the Northwind Database to Your Application To add the Northwind database to your ASP.NET application, you can follow these general steps: Download a copy of the Northwind database, as described in the previous answer. Restore the Northwind database to your SQL Server instance using SQL Server Management Studio or another tool. This will create&#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-128251","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>Adding the Northwind Database to Your Application - Tutorial<\/title>\n<meta name=\"description\" content=\"Adding the Northwind Database to Your Application\" \/>\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\/adding-the-northwind-database-to-your-application\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adding the Northwind Database to Your Application - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Adding the Northwind Database to Your Application\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/\",\"name\":\"Adding the Northwind Database to Your Application - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2023-05-04T10:44:42+00:00\",\"dateModified\":\"2024-04-12T08:45:25+00:00\",\"description\":\"Adding the Northwind Database to Your Application\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding the Northwind Database to Your Application\"}]},{\"@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":"Adding the Northwind Database to Your Application - Tutorial","description":"Adding the Northwind Database to Your Application","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\/adding-the-northwind-database-to-your-application\/","og_locale":"en_US","og_type":"article","og_title":"Adding the Northwind Database to Your Application - Tutorial","og_description":"Adding the Northwind Database to Your Application","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/","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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/","name":"Adding the Northwind Database to Your Application - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2023-05-04T10:44:42+00:00","dateModified":"2024-04-12T08:45:25+00:00","description":"Adding the Northwind Database to Your Application","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-the-northwind-database-to-your-application\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Adding the Northwind Database to Your Application"}]},{"@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\/128251","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=128251"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128251\/revisions"}],"predecessor-version":[{"id":128261,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128251\/revisions\/128261"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=128251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=128251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=128251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}