{"id":115,"date":"2012-07-18T07:52:40","date_gmt":"2012-07-18T12:52:40","guid":{"rendered":"https:\/\/www.asberry.org\/blog_tech\/?p=115"},"modified":"2012-09-17T14:04:52","modified_gmt":"2012-09-17T19:04:52","slug":"writing-form-data-to-sql-db-with-c","status":"publish","type":"post","link":"https:\/\/asberry.org\/blog_tech\/?p=115","title":{"rendered":"Writing form data to SQL DB with C#"},"content":{"rendered":"<p>In having to convert my current VB projects into C#, I ran into an issue trying to write to a DB from a form. \u00a0<a href=\"http:\/\/http:\/\/forum.codecall.net\/topic\/50128-writing-sql-commands-in-c-part-1-insert-into-table\/\" target=\"_blank\">This blog<\/a> opened my eyes to how this is accomplished and here is the code I used to get the unsubscribe feature to work.<\/p>\n<pre class=\"brush: csharp; light: false; title: ; toolbar: true; notranslate\" title=\"\">\r\n\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.Linq;\r\nusing System.Web;\r\nusing System.Web.UI;\r\nusing System.Web.UI.WebControls;\r\nusing System.Data.SqlClient;\r\n\r\nnamespace Taleo_UnsubscribeJPN\r\n{\r\npublic partial class Default : System.Web.UI.Page\r\n{\r\nprotected void Page_Load(object sender, EventArgs e)\r\n{\r\nDateTime tstamp = DateTime.Now;\r\nString email = Request.QueryString&#x5B;&quot;email&quot;];\r\nString atsid = Request.QueryString&#x5B;&quot;atsid&quot;];\r\nlblEmail.Text = email;\r\n\r\n}\r\n\r\nprotected void btnRemove_Click(object sender, EventArgs e)\r\n{\r\nString strBrowserInfo = (Server.HtmlEncode(Request.UserAgent));\r\nString strIPAddress = (Server.HtmlEncode(Request.UserHostAddress));\r\nString atsid = Request.QueryString&#x5B;&quot;atsid&quot;];\r\nstring connection_string = &quot;Data Source=DB_Server;Initial Catalog=TaleoData;Persist Security Info=True;User ID=tdowner;Password=password&quot;;\r\nstring query = &quot;insert into OptOutEmail (email, tstamp, processed, atsid, remote_addr, http_user_agent) values ('&quot; + lblEmail.Text + &quot;', '&quot; + DateTime.Now + &quot;', &quot; + 0 + &quot;, '&quot; + atsid + &quot;', '&quot; + strIPAddress + &quot;', '&quot; + strBrowserInfo + &quot;')&quot;;\r\nSqlConnection connection1 = new SqlConnection(connection_string);\r\n\r\nSqlCommand insertCommand = new SqlCommand(query, connection1);\r\n\r\nconnection1.Open();\r\n\r\ninsertCommand.ExecuteNonQuery();\r\n\r\nconnection1.Close();\r\n\r\nServer.Transfer(&quot;Confirmation.aspx?email=&quot; + lblEmail.Text);\r\n\r\n}\r\n}\r\n}\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>In having to convert my current VB projects into C#, I ran into an issue trying to write to a DB from a form. \u00a0This blog opened my eyes to how this is accomplished and here is the code I used to get the unsubscribe feature to work. using System; using System.Collections.Generic; using System.Linq; using [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3,10],"tags":[],"class_list":["post-115","post","type-post","status-publish","format-standard","hentry","category-c","category-mssql","author-aron"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4bBkH-1R","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=115"}],"version-history":[{"count":6,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/115\/revisions"}],"predecessor-version":[{"id":128,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/115\/revisions\/128"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}