Reputation: 7461
I want is to have a confirmation before deleting a records in my datagridview. Please check my codes.. Thanks.
here's my asp.net code:
<ItemTemplate><asp:HyperLink ID="hlnk_Delete" runat="server" style="width:100px; margin-left:50px; margin-right:100px"
NavigateUrl='<%# "Components/DeleteBook.aspx?SKU=" + Utility.SKUMask(Eval("lbhc_lb_sku").ToString()) %>'>Delete</asp:HyperLink></ItemTemplate>
Sqldatasource:
<asp:SqlDataSource ID="sds_PublishedBookListings" runat="server" ConnectionString="<%$ ConnectionStrings:learningisfunConnectionString %>"
SelectCommand="SELECT dbo.lif_bookshascategory.lbhc_lc_id,dbo.lif_books.lb_sku, dbo.lif_bookshascategory.lbhc_lb_sku, dbo.lif_category.lc_category, dbo.lif_books.lb_title, dbo.lif_bookshascategory.lbhc_level FROM dbo.lif_bookshascategory INNER JOIN dbo.lif_category ON dbo.lif_bookshascategory.lbhc_lc_id = dbo.lif_category.lc_id INNER JOIN dbo.lif_books ON dbo.lif_bookshascategory.lbhc_lb_sku = dbo.lif_books.lb_sku WHERE (dbo.lif_books.lb_status = 'publish') and lbhc_level = 1 "
DeleteCommand="DELETE FROM lif_books FROM lif_books INNER JOIN lif_bookshascategory ON lif_books.lb_sku = lif_bookshascategory.lbhc_lb_sku WHERE (lif_books.lb_sku = @lbhc_lb_sku) OR (lif_bookshascategory.lbhc_lb_sku = @lbhc_lb_sku)">
<DeleteParameters>
<asp:Parameter Name="lb_sku" Type="String" />
</DeleteParameters>
</asp:SqlDataSource>
Upvotes: 1
Views: 2046
Reputation: 11146
Add to you Hyperlink OnclientClick="confirm('are you sure?'); return false"
Upvotes: 0
Reputation: 52241
add this your hyperlink
onclick="javascript:return confirm('Are you sure you want to delete ?');"
<ItemTemplate><asp:HyperLink ID="hlnk_Delete" onclick="javascript:return confirm('Are you sure you want to delete ?');" runat="server" style="width:100px; margin-left:50px; margin-right:100px"
NavigateUrl='<%# "Components/DeleteBook.aspx?SKU=" + Utility.SKUMask(Eval("lbhc_lb_sku").ToString()) %>'>Delete</asp:HyperLink></ItemTemplate>
Upvotes: 3