Gridview delete button event

Posted on 2008-10-10
Last Modified: 2012-06-27
I've a gridview with a delete button on each row. When I click the button on a row, I want to delete that row from the Gridviewand from the database. The Gridview is bound to a table of my access database. Below you can find the code of my Gridview.


<asp:GridView ID="grdAbsentismo" runat="server" AutoGenerateColumns="False" DataSourceID="GridDataSource" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" CellPadding="4" ForeColor="#333333">
                    <asp:BoundField DataField="Empregado" HeaderText="Empregado" SortExpression="Empregado">
                        <ItemStyle HorizontalAlign="Center" Width="150px" />
                    <asp:BoundField DataField="Motivo" HeaderText="Motivo" SortExpression="Motivo">
                        <ItemStyle HorizontalAlign="Center" Width="180px" />
                    <asp:BoundField DataField="MotivoLei" HeaderText="Detalhe Absentismo" SortExpression="MotivoLei">
                        <ItemStyle HorizontalAlign="Center" Width="200px" />
                    <asp:BoundField DataField="DataInicio" HeaderText="Data de Inicio" SortExpression="DataInicio" DataFormatString="{0:dd/MM/yyyy}">
                        <ItemStyle HorizontalAlign="Center" Width="90px" />
                    <asp:BoundField DataField="Dias" HeaderText="N&#186; Dias" SortExpression="Dias">
                        <ItemStyle HorizontalAlign="Center" Width="60px" />
                    <asp:ButtonField ButtonType="Button" Text="Remover">
                        <ItemStyle HorizontalAlign="Center" Width="100px" />
                <HeaderStyle BackColor="#5D7B9D" BorderStyle="Solid" BorderWidth="1px" Height="25px" Font-Bold="True" ForeColor="White" />
                <RowStyle BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" Height="25px" BackColor="#F7F6F3" ForeColor="#333333" HorizontalAlign="Left" />
                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                <EditRowStyle BackColor="#999999" />
                <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <asp:AccessDataSource ID="GridDataSource" runat="server" DataFile="~/db/manpower.mdb"
                SelectCommand="SELECT [Empregado], [Motivo], [DataInicio], [Dias], [MotivoLei] FROM [Absentismo]" CacheExpirationPolicy="Sliding"></asp:AccessDataSource>

Open in new window

Question by:jppinto
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 20

Expert Comment

ID: 22685955
You'll have to configure a delete command for the accessdatasource
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22685979
supported to informaniac comment .. need to add this in access datasource
 DeleteCommand="DELETE FROM xxxx
                 WHERE ID=@ID"

also need to add DataKeyNames in your grid control so as per sample it would be
<asp:GridView ID="grdAbsentismo" runat="server" DataKeyNames="ID"  AutoGenerateColumns="False" DataSourceID="GridDataSource" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" CellPadding="4" ForeColor="#333333">
LVL 33

Author Comment

ID: 22686113
Can you be more explicit please? I've started using ASP just a few days ago...


Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 20

Expert Comment

ID: 22686139
LVL 48

Accepted Solution

jpaulino earned 500 total points
ID: 22686303
The easy way (I think) is to remove that buttonfield and add a command field(delete). Then change the "delete" text to "remover" and the button type to "button" (instead of link)
Don't forget you need to have a primary key field!
LVL 33

Author Comment

ID: 22689088
I've tryed the solution presented by jpaulino and it seem to be the simplest solution for what I need to do.


LVL 33

Author Closing Comment

ID: 31504970
Simple solution. Good work!

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question