Hello,

  How can i confirm before delete a row from datagrid?
This is my code...
<asp:datagrid id="dgbrand" Runat="server" Font-Size="12px" Font-Name="arial" BorderColor="SteelBlue" OnEditCommand="editMode" OnUpdateCommand="doUpdate" OnCancelCommand="cancelEdit" DataKeyField="brand_code"
AutoGenerateColumns="False" Width="350px" Font-Names="arial" OnDeleteCommand="doDelete">
<AlternatingItemStyle BackColor="#CCCCCC"></AlternatingItemStyle>
<HeaderStyle Font-Bold="True" BackColor="Salmon"></HeaderStyle>
<Columns>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="CAN" EditText="Edit"></asp:EditCommandColumn>
<asp:BoundColumn DataField="brand_code" ReadOnly="True" HeaderText="Brand Code">
    <ItemStyle HorizontalAlign="Center"></ItemStyle>
    </asp:BoundColumn>
    <asp:BoundColumn DataField="brand_name" HeaderText="Description"></asp:BoundColumn>
    <asp:TemplateColumn>
    <ItemTemplate>
    <asp:LinkButton ID="cmddel" Runat="server" Font-Underline="True" ForeColor="#0000ff" CommandName="Delete">Del</asp:LinkButton>
    </ItemTemplate>
    </asp:TemplateColumn>
</Columns>
</asp:datagrid>



    Sub doDelete(ByVal s As Object, ByVal e As DataGridCommandEventArgs)
        Dim bcode As String, strqry As String
        Dim cmd As OleDbCommand, mydelbtn As LinkButton
        bcode = dgbrand.DataKeys.Item(e.Item.ItemIndex)
        mydelbtn = e.Item.FindControl("cmddel")

        bcode = dgbrand.DataKeys.Item(e.Item.ItemIndex)
        strqry = "delete from brands where brand_code='" & bcode & "'"

        cmd = New OleDbCommand(strqry, conn)
        cmd.CommandType = CommandType.Text
        Try
            If conn.State = ConnectionState.Closed Then
                conn.Open()
            End If
            cmd.ExecuteNonQuery()
            getNewBrandCode()
            dobinding()
            txtDesc.Value = ""
        Catch ex As Exception
            errmsg.Text = ex.ToString()
        End Try
        conn.Close()
    End Sub

In the ItemDataBound Event of the Grid, Find the LinkButton
     LinkButton cmdDel = e.Item.FindControl("cmdDel");

add client side code to this LinkButton
     cmdDel.Attributes.Add("onclick", "return confirm('Are You Sure You want to delete?')")

Regards
Ganesh

Example:

 Private Sub dgbrand_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dgbrand.ItemDataBound
        Dim link_cmddel As LinkButton
        If e.Item.ItemType = ListItemType.AlternatingItem Or e.Item.ItemType = ListItemType.Item Then
            link_cmddel = e.Item.FindControl("cmddel")
link_cmddel.Attributes.Add("onclick", "return confirm('Are You Sure You want to delete?')")
        End If
    End Sub

Hello,

  Tx 4 the replies. I got it.


----------
Rajani