Click here to Skip to main content
15,887,596 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am using visual studio ultimate 2012. the problem is I can't delete a row in my project.

I am using following coding for load datas.

ASP.NET
<form id="form1"  runat="server">
        
            Data Alternatif
            <div style="width: 100%; overflow: auto; margin-removed 20px; margin-removed 20px;">
            <asp:SqlDataSource ID="sdsKategori" runat="server" ConnectionString="<%$ ConnectionStrings:TopsisDbConnectionString %>" 
            SelectCommand="SELECT * FROM Alternatif">
            </asp:SqlDataSource>
            <asp:GridView ID="gvKategori" DataSourceID="SqlDataSource1" runat="server" AllowPaging="True" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" AutoGenerateColumns="False" BorderStyle="Solid" BorderWidth="1px" PageSize="5">
                <AlternatingRowStyle/>
                <EditRowStyle/>
                <Columns>
                    <asp:CommandField HeaderText="Kelola Data" ShowSelectButton="true" ShowDeleteButton="true" ShowEditButton="true" ShowHeader="true" />
                    <asp:BoundField DataField="nm_alterntf" HeaderText="Nama Alternatif" SortExpression="nm_alterntf" />
                    <asp:BoundField DataField="kelulusan_air" HeaderText="Kelulusan Air Tanah" SortExpression="kelulusan_air" />
                    <asp:BoundField DataField="sist_aliran_air" HeaderText="Sistem Aliran Air" SortExpression="sist_aliran_air" />
                    <asp:BoundField DataField="manfaat_air" HeaderText="Pemanfaatan Air Tanah" SortExpression="manfaat_air" />
                    <asp:BoundField DataField="kemiringan" HeaderText="Kemiringan Tanah" SortExpression="kemiringan" />
                    <asp:BoundField DataField="jns_terbg" HeaderText="Jenis Penerbangan" SortExpression="jns_terbg" />
                    <asp:BoundField DataField="jrk_bandara" HeaderText="Jarak Lapangan terbang" SortExpression="jrk_bandara" />
                    <asp:BoundField DataField="bhy_banjir" HeaderText="Bahaya Banjir" SortExpression="bhy_banjir" />
                    <asp:BoundField DataField="inten_hjn" HeaderText="Intensitas Hujan" SortExpression="inten_hjn" />
                    <asp:BoundField DataField="utilitas" HeaderText="Utilitas" SortExpression="utilitas" />
                    <asp:BoundField DataField="lingk_bio" HeaderText="Lingkungan Biologis" SortExpression="lingk_bio" />
                    <asp:BoundField DataField="pertanian" HeaderText="Pertanian" SortExpression="pertanian" />
                    <asp:BoundField DataField="tnh_pntp" HeaderText="Tanah Penutup" SortExpression="tnh_pntp" />
                    <asp:BoundField DataField="kps_lhn" HeaderText="Kapasitas Lahan" SortExpression="kps_lhn" />
                    <asp:BoundField DataField="jln_msk" HeaderText="Jalan Masuk" SortExpression="jln_msk" />
                    <asp:BoundField DataField="bts_admin" HeaderText="Batas Administrasi" SortExpression="bts_admin" />
                    <asp:BoundField DataField="bis_bau" HeaderText="Kebisingan dan Bau" SortExpression="bis_bau" />
                    <asp:BoundField DataField="estetika" HeaderText="Estetika" SortExpression="estetika" />
                    <asp:BoundField DataField="biaya" HeaderText="Biaya" SortExpression="biaya" />
                </Columns>
                <EmptyDataRowStyle ForeColor="Red" />
                <HeaderStyle BackColor="#66FFFF"/>
                <PagerStyle />
                <RowStyle />
                <SelectedRowStyle />
                <SortedAscendingCellStyle/>
                <SortedAscendingHeaderStyle />
                <SortedDescendingCellStyle/>
                <SortedDescendingHeaderStyle/>
            </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TopsisDbConnectionString %>" SelectCommand="SELECT * FROM [Alternatif]"></asp:SqlDataSource>
            </div>
            <br/>
    </form>
Posted
Comments
Karthik_Mahalingam 17-Jan-14 21:54pm    
what issue you r facing ??

You need to add an event in your gridview
C#
<asp:gridview id="gvKategori" datasourceid="SqlDataSource1" runat="server" allowpaging="True" autogeneratedeletebutton="True" autogenerateeditbutton="True" autogeneratecolumns="False" borderstyle="Solid" borderwidth="1px" pagesize="5" OnRowDeleting="GridView1_RowDeleting"></asp:gridview>


and implement your event like this
C#
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       
        //TODO:put your code for delete rows
    }
 
Share this answer
 
v3
 
Share this answer
 
Comments
Karthik_Mahalingam 17-Jan-14 23:46pm    
yes proceed, pls
Karthik_Mahalingam 17-Jan-14 23:48pm    
you can N number of Datatables, depends on your requirement and usage..
Karthik_Mahalingam 17-Jan-14 23:54pm    
whenever you are assigning a new data to the same object, then the old data will be over written...
Karthik_Mahalingam 18-Jan-14 0:05am    
yes, is safe ..
Karthik_Mahalingam 18-Jan-14 0:14am    
if your issue is fixed, can u pls close this post..
Please check this link

Update and Delete in GridView [^]
 
Share this answer
 
I give a select command, update command, and delete command on gridview code.
Thanks..
:)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900