{"id":2065,"date":"2012-07-31T17:11:08","date_gmt":"2012-07-31T21:11:08","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=2065"},"modified":"2012-07-31T17:11:08","modified_gmt":"2012-07-31T21:11:08","slug":"record-update-confirmation-message","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2012\/07\/record-update-confirmation-message\/","title":{"rendered":"Record Update Confirmation Message"},"content":{"rendered":"<pre>\r\nDataSource connection string\r\n<code>\r\n&lt;asp:sqldatasource ID=\"MySQLDS\" runat=\"server\" \r\nConnectionString=\"< %$ ConnectionStrings:MyConnString %>\" \r\nUpdateCommand=\"UPDATE [MyTablel] \r\nSET \r\n[DATE_SUBMITTED] = @DATE_SUBMITTED WHERE [RID] = @RID\" \r\nOnUpdated=\"UpdateMessage\" >\r\n&lt;\/asp:sqldatasource><\/code>\r\nVB code in a head section of the page\r\n<code>\r\n&lt;head>\r\n&lt;script runat=\"server\">\r\n    Sub UpdateMessage(ByVal source As Object, ByVal e As SqlDataSourceStatusEventArgs)\r\n        If e.AffectedRows > 0 Then\r\n            ' Perform any additional processing, \r\n            ' such as setting a status label after the operation.        \r\n            Label1.Text = \"- Information updated successfully!\"\r\n        Else\r\n            Label1.Text = \"No data updated!\"\r\n        End If\r\n    End Sub 'UpdateMessage\r\n&lt;\/script>\r\n&lt;\/head>\r\n<\/code>\r\nLabel - message display\r\n<code>\r\n&lt;asp:Label ID=\"Label1\" runat=\"server\" CssClass=\"error\" >\r\n<\/code>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>DataSource connection string &lt;asp:sqldatasource ID=&#8221;MySQLDS&#8221; runat=&#8221;server&#8221; ConnectionString=&#8221;< %$ ConnectionStrings:MyConnString %>&#8221; UpdateCommand=&#8221;UPDATE [MyTablel] SET [DATE_SUBMITTED] = @DATE_SUBMITTED WHERE [RID] = @RID&#8221; OnUpdated=&#8221;UpdateMessage&#8221; > &lt;\/asp:sqldatasource> VB code in a head section of the page &lt;head> &lt;script runat=&#8221;server&#8221;> Sub UpdateMessage(ByVal source As Object, ByVal e As SqlDataSourceStatusEventArgs) If e.AffectedRows > 0 Then &#8216; Perform any additional processing, &#8216; [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85,28,17,16,32,67,84],"tags":[19,22,45,21],"class_list":["post-2065","post","type-post","status-publish","format-standard","hentry","category-net-4-0","category-access","category-applications","category-net","category-ms-sql","category-sql","category-vs2010","tag-asp-net","tag-programming","tag-record-update","tag-visual-studio"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2065"}],"collection":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=2065"}],"version-history":[{"count":4,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2065\/revisions"}],"predecessor-version":[{"id":2070,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2065\/revisions\/2070"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=2065"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=2065"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=2065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}