Delete with confirmation using DetailsView Delete Command Button in ASP.Net

Try This

HTML:

<form id="form1" runat="server">
    <div>
        <asp:TextBox ID="WMFENewID" runat="server" />
        <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="400px" AllowPaging="True"
            AutoGenerateRows="False" DataSourceID="SqlDataSource1" DataKeyNames="EmployeeID"
            BackColor="#DEBA84" BorderColor="#DEBA84" OnDataBound="DViewComputer_DataBound1"
            BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2">
            <EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
            <Fields>
                <asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" InsertVisible="False"
                    ReadOnly="True" SortExpression="EmployeeID" />
                <asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" />
                <asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" />
                <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
                <asp:BoundField DataField="Attendance" HeaderText="Attendance" SortExpression="Attendance" />
                <asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" />
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
            </Fields>
            <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
            <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
            <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
        </asp:DetailsView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConString %>"
            SelectCommand="SELECT * FROM [Emp]" InsertCommand="INSERT INTO [Emp](LastName,City,Country,FirstName,State,Attendance,DOB) Values(@LastName,@City,@Country,@FirstName,@State,@Attendance,@DOB)"
            DeleteCommand="DELETE FROM [Emp] WHERE EmployeeID = @EmployeeID" UpdateCommand="UPDATE EMP SET LastName=@LastName,City=@City,Country=@Country,FirstName=@FirstName,State=@State,Attendance =@Attendance,DOB=@DOB WHERE EmployeeID = @EmployeeID">
        </asp:SqlDataSource>
    </div>
    </form>

C#:

protected void DViewComputer_DataBound1(object sender, EventArgs e)
        {
            int noRow = DetailsView1.Rows.Count - 1;//get the no of record

            if (noRow > 0)
            {
                LinkButton button = (LinkButton)(DetailsView1.Rows[noRow].Cells[0].Controls[2]);

                // Add delete confirmation
                ((System.Web.UI.WebControls.LinkButton)(button)).OnClientClick = "if(!confirm('Do you want to delete?')){ return false; };";

            }
        }

Sql Table:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Emp](
	[EmployeeID] [int] IDENTITY(1,1) NOT NULL,
	[LastName] [varchar](50) NULL,
	[City] [varchar](50) NULL,
	[Country] [varchar](50) NULL,
	[FirstName] [varchar](50) NULL,
	[State] [varchar](50) NULL,
	[Attendance] [char](1) NULL,
	[DOB] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Thank You.