{"id":639,"date":"2011-03-31T10:30:11","date_gmt":"2011-03-31T14:30:11","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=639"},"modified":"2011-03-31T10:30:11","modified_gmt":"2011-03-31T14:30:11","slug":"one-click-gridview-record-update","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2011\/03\/one-click-gridview-record-update\/","title":{"rendered":"One click gridview record update"},"content":{"rendered":"

Here is how you can update record in a gridview with just a one click.<\/p>\n

\"\"<\/a><\/p>\n

Code:<\/strong><\/p>\n

<asp:TemplateField HeaderText=”Active”>
\n<ItemTemplate>
\n<asp:CheckBox ID=”ActiveCheckBox” runat=”server” Checked='<%# Bind(“Active”) %>’ \/>
\n<asp:LinkButton ID=”UpdateButton” runat=”server” CausesValidation=”True” CommandName=”Update” Text=”Update” \/>
\n<\/ItemTemplate>
\n<HeaderStyle CssClass=”datagrid-th” \/>
\n<\/asp:TemplateField><\/p>\n

Access Data Source<\/strong><\/p>\n

<asp:AccessDataSource ID=”RepoMgt” runat=”server” DataFile=”\/my_folder\/mydb.mdb”
\nDeleteCommand=”DELETE FROM [MyCars] WHERE [ID] = ?”
\nInsertCommand=”INSERT INTO [MyCars] ([Active]) VALUES (?)”
\nSelectCommand=”SELECT * FROM [MyCars] ORDER BY [Make], [Model]”
\nUpdateCommand=”UPDATE [MyCars] SET [Active] = ? WHERE [ID] = ?”<\/span> ><\/p>\n

Update Parameters<\/strong><\/p>\n

<UpdateParameters>
\n<asp:Parameter Name=”Active” Type=”Boolean” \/>
\n<asp:Parameter Name=”ID” Type=”Int32″ \/>
\n<\/UpdateParameters><\/p>\n","protected":false},"excerpt":{"rendered":"

Here is how you can update record in a gridview with just a one click. Code: <asp:TemplateField HeaderText=”Active”> <ItemTemplate> <asp:CheckBox ID=”ActiveCheckBox” runat=”server” Checked='<%# Bind(“Active”) %>’ \/> <asp:LinkButton ID=”UpdateButton” runat=”server” CausesValidation=”True” CommandName=”Update” Text=”Update” \/> <\/ItemTemplate> <HeaderStyle CssClass=”datagrid-th” \/> <\/asp:TemplateField> Access Data Source <asp:AccessDataSource ID=”RepoMgt” runat=”server” DataFile=”\/my_folder\/mydb.mdb” DeleteCommand=”DELETE FROM [MyCars] WHERE [ID] = ?” InsertCommand=”INSERT INTO [MyCars] […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,17,16],"tags":[19,42,45],"class_list":["post-639","post","type-post","status-publish","format-standard","hentry","category-access","category-applications","category-net","tag-asp-net","tag-gridview","tag-record-update"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/639"}],"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=639"}],"version-history":[{"count":11,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/639\/revisions"}],"predecessor-version":[{"id":651,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/639\/revisions\/651"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}