{"id":421,"date":"2012-02-26T19:19:32","date_gmt":"2012-02-26T19:19:32","guid":{"rendered":"http:\/\/devnot.wordpress.com\/?p=421"},"modified":"2012-02-26T19:19:32","modified_gmt":"2012-02-26T19:19:32","slug":"reading-from-a-sql-database","status":"publish","type":"post","link":"https:\/\/thomas-jansen.eu\/?p=421","title":{"rendered":"Reading from a SQL database"},"content":{"rendered":"<p>Self explanatory snippet<\/p>\n<pre>\n\nSqlConnection db = new SqlConnection(Properties.Settings.Default.ConnectionString);\n\n            \ntry\n{\n   db.Open();\n   SqlDataAdapter dataAdapter = new SqlDataAdapter(\"SELECT FirstName, LastName  FROM Contacts\", db);\n\n   DataTable dataTable = new DataTable();\n   dataAdapter.Fill(dataTable);\n\n   foreach(DataRow row in dataTable.Rows)\n   {\n      string firstName = row[\"FirstName\"];\n      string lastName  = row[\"LastName\"];\n   }\n \n   db.Close(); \n   db.Dispose(); \n   db = null;0\n}\ncatch (Exception e)\n{\n   System.Windows.Forms.MessageBox.Show(e.Message, \"DB error\", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);      \n}\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Self explanatory snippet SqlConnection db = new SqlConnection(Properties.Settings.Default.ConnectionString); try { db.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter(&#8220;SELECT FirstName, LastName FROM Contacts&#8221;, db); DataTable dataTable = new DataTable(); dataAdapter.Fill(dataTable); foreach(DataRow row in dataTable.Rows) { string firstName = row[&#8220;FirstName&#8221;]; string lastName = row[&#8220;LastName&#8221;]; } db.Close(); db.Dispose(); db = null;0 } catch (Exception e) { System.Windows.Forms.MessageBox.Show(e.Message, &#8220;DB error&#8221;, System.Windows.Forms.MessageBoxButtons.OK, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-421","post","type-post","status-publish","format-standard","hentry","category-c"],"_links":{"self":[{"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=\/wp\/v2\/posts\/421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=421"}],"version-history":[{"count":0,"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions"}],"wp:attachment":[{"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thomas-jansen.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}