{"id":2389,"date":"2012-12-10T12:10:20","date_gmt":"2012-12-10T16:10:20","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=2389"},"modified":"2012-12-07T12:19:59","modified_gmt":"2012-12-07T16:19:59","slug":"refresh-page-on-button-click","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2012\/12\/refresh-page-on-button-click\/","title":{"rendered":"Refresh page on button click"},"content":{"rendered":"<pre>\r\nMarkup page\r\n<code>\r\n&lt;script runat=\"server\">\r\nSub <u>UpdateMessage<\/u>(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    <b>Page.Response.Redirect(Page.Request.Url.ToString(), True)<\/b>\r\n   End If\r\n  End Sub 'UpdateMessage\r\n&lt;\/script>\r\n<\/code>\r\n<code>\r\n&lt;asp:SqlDataSource ID=\"ImgEditDS4\" runat=\"server\" \r\n    ConnectionString=\"< %$ ConnectionStrings:MyConnStr %>\"  \r\n    SelectCommand=\"SELECT [photo_id], [photo_1] WHERE ([photo_id] = @p_id)\" \r\n    UpdateCommand=\"UPDATE [MyTable] SET [photo_1] = @photo_1 WHERE [photo_id] = @f_id\"\r\n    <u>OnUpdated=\"UpdateMessage\"<\/u> >\r\n&lt;SelectParameters>\r\n  &lt;asp:QueryStringParameter Name=\"p_id\" QueryStringField=\"aid\" Type=\"Int32\" \/>\r\n  &lt;\/SelectParameters>\r\n  &lt;UpdateParameters>\r\n  &lt;asp:Parameter Name=\"photo_1\" Type=\"String\" \/>\r\n  &lt;asp:Parameter Name=\"p_id\" Type=\"Int32\" \/>\r\n  &lt;\/UpdateParameters>\r\n&lt;\/asp:SqlDataSource>\r\n<\/code>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Markup page &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; such as setting a status label after the operation. Page.Response.Redirect(Page.Request.Url.ToString(), True) End If End Sub &#8216;UpdateMessage &lt;\/script> &lt;asp:SqlDataSource ID=&#8221;ImgEditDS4&#8243; runat=&#8221;server&#8221; ConnectionString=&#8221;< %$ ConnectionStrings:MyConnStr %>&#8221; SelectCommand=&#8221;SELECT [photo_id], [photo_1] WHERE ([photo_id] = @p_id)&#8221; [&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,16,84],"tags":[19,110,124],"class_list":["post-2389","post","type-post","status-publish","format-standard","hentry","category-net-4-0","category-net","category-vs2010","tag-asp-net","tag-button","tag-onclick"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2389"}],"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=2389"}],"version-history":[{"count":5,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2389\/revisions"}],"predecessor-version":[{"id":2394,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2389\/revisions\/2394"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=2389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=2389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=2389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}