且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何编辑和删除gridview asp.net中的行

更新时间:2023-02-06 23:18:13

ConnectionStrings:TopsisDbConnectionString%>

SelectCommand = SELECT * FROM Alternatif >
< / asp:SqlDataSource >
< asp:GridView ID = gvKategori DataSourceID = SqlDa taSource1 runat = server AllowPaging = True AutoGenerateDeleteButton = True AutoGenerateEditButton = True AutoGenerateColumns = False BorderStyle = Solid BorderWidth = 1px PageSize = 5 >
< AlternatingRowStyle / >
< EditRowStyle / >
< >
< asp:CommandField 的HeaderText = Kelola数据 ShowSelectButton = true ShowDeleteButton = true ShowEditButton = true ShowHeader = true / >
< asp:BoundField n> 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=\"n>utilitas\" />
<asp:BoundField DataField=\"lingk_bio\" HeaderText=\"Lingkungan Biologis\" SortExpression=\"lingk_bio\" />
<asp:BoundFieldan> DataField=\"pertanian\" HeaderText=\"Pertanian\" SortExpression=\"pertanian\" />
<asp:BoundField DataField=\"tnh_pntp\" HeaderText=\"an>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=\"an>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\" />
<n>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> <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>
ConnectionStrings:TopsisDbConnectionString %>" SelectCommand="SELECT * FROM [Alternatif]"></asp:SqlDataSource> </div> <br/> </form>


You need to add an event in your gridview

You need to add an event in your gridview
<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



and implement your event like this

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       
        //TODO:put your code for delete rows
    }