Hi,
How to use SweetAlert2 confirm with GridView OnRowDeleting
I'm able to delete GridView row by using GridView OnRowDeleting event and show SweetAlert dialog after deletion like this.
Problem: Now I want to use SweetAlert2 confirm dialog to let the user click "confirm" button before delete. How can I do that?
Please advise.
What i want to use
Swal.fire({
title: 'Are you sure?',
text: "You won't be able to revert this!",
icon: 'warning',
showCancelButton: true,
confirmButtonColor: '#3085d6',
cancelButtonColor: '#d33',
confirmButtonText: 'Yes, delete it!'
}).then((result) => {
if (result.isConfirmed) {
Swal.fire(
'Deleted!',
'Your file has been deleted.',
'success'
)
}
})
HTML
<asp:GridView ID="GridView1" CssClass="table table-responsive table-striped margin-left-20 centerHeaderText" runat="server"
AutoGenerateColumns="False" Width="300px"
AllowSorting="True"
PagerSettings-Visible="true" AllowPaging="True" PageSize="5"
OnRowDeleting="GridView1_RowDeleting"
OnPageIndexChanging="GridView1_PageIndexChanging1" HorizontalAlign="Left">
<Columns>
<asp:TemplateField HeaderText="No.">
<ItemTemplate>
<%# Container.DataItemIndex + 1 %>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="year" HeaderText="code" />
<asp:TemplateField>
<ItemTemplate>
<asp:Button CssClass="btn btn-danger font-xlarge" ID="btnDelete" runat="server"
CommandName="Delete" Text="delete"
/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerSettings Mode="NumericFirstLast" />
<PagerStyle HorizontalAlign="Right" VerticalAlign="Middle" />
<RowStyle HorizontalAlign="Center" />
</asp:GridView>
C#
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
String delyear = GridView1.Rows[e.RowIndex].Cells[1].Text;
db.executeQuery("delete from Scholarship_Year where year = '"+ delyear + "' ");
db.executeQuery("select from Scholarship_Year where year = '" + delyear + "' ");
ClientScript.RegisterStartupScript(this.GetType(), "deleteSuccess", "showAlert('data " + delyear.ToString() + " deleted', 'more info', 'warning')", true);
dt = db.executeQuery("select year from Scholarship_Year ");
bindGridView(dt);
}