gridview 绑定数据.实现update、delete、insert into、分页功能

最新推荐文章于 2022-10-14 10:16:30 发布

lx_nq

最新推荐文章于 2022-10-14 10:16:30 发布

阅读量419

点赞数

文章标签： insert delete textbox asp server object

本文链接：https://blog.csdn.net/lx_nq/article/details/6630273

版权

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="default.aspx.cs" Inherits="_default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div align="center">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            Width="800px" AllowPaging="True" DataKeyNames="Id" 
            onpageindexchanging="GridView1_PageIndexChanging" 
            onrowcancelingedit="GridView1_RowCancelingEdit" 
            onrowcommand="GridView1_RowCommand" onrowdeleting="GridView1_RowDeleting" 
            onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" 
            PageSize="5" ShowFooter="True">
            <Columns>
                <asp:TemplateField HeaderText="新闻ID"  HeaderStyle-HorizontalAlign="Left"> 
                <EditItemTemplate> 
                    <asp:Label ID="lblId" runat="server" Text='<%# Bind("Id") %>'></asp:Label>
                </EditItemTemplate> 
                <ItemTemplate> 
                    <asp:Label ID="lblId" runat="server" Text='<%# Bind("Id") %>'></asp:Label> 
                </ItemTemplate> 

<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
            </asp:TemplateField> 
            <asp:TemplateField HeaderText="新闻标题" HeaderStyle-HorizontalAlign="Left"> 
                <EditItemTemplate> 
                    <asp:TextBox ID="txtName" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox> 
                </EditItemTemplate> 
                <FooterTemplate> 
                    <asp:TextBox ID="txtNewName" runat="server" ></asp:TextBox> 
                </FooterTemplate> 
                <ItemTemplate> 
                    <asp:Label ID="lblName" runat="server" Text='<%# Bind("Title") %>'></asp:Label> 
                </ItemTemplate> 

<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
            </asp:TemplateField> 
            <asp:TemplateField HeaderText="编辑" ShowHeader="False" HeaderStyle-HorizontalAlign="Left"> 
                <EditItemTemplate> 
                    <asp:LinkButton ID="lnkUpdate" runat="server" CausesValidation="True" CommandName="Update" Text="更新"></asp:LinkButton> 
                    <asp:LinkButton ID="lnkCancel" runat="server" CausesValidation="False" CommandName="Cancel" Text="取消"></asp:LinkButton> 
                </EditItemTemplate> 
                <FooterTemplate> 
                    <asp:LinkButton ID="lnkAdd" runat="server" CausesValidation="False" CommandName="Insert" Text="插入"></asp:LinkButton> 
                </FooterTemplate> 
                <ItemTemplate> 
                    <asp:LinkButton ID="lnkEdit" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"></asp:LinkButton> 
                </ItemTemplate> 

<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
            </asp:TemplateField> 

            <asp:CommandField HeaderText="删除" ShowDeleteButton="True" ShowHeader="True" /> 
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class _default : System.Web.UI.Page
{
    private DataTable dt = null;
    private DAL.DBHelper db = new DAL.DBHelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            FillGrid();
        }
    }
    protected void FillGrid()
    {
        string sql = "SELECT * FROM news ORDER BY ReleaseDate DESC";
        dt = db.ExecuteQuery(sql, CommandType.Text);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        FillGrid();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        FillGrid();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        
        Label lblnewid = (Label)GridView1.Rows[e.RowIndex].FindControl("lblId");
        TextBox txtnewstitle = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName");
        string updsql = "UPDATE news SET Title='" + txtnewstitle.Text + "' WHERE Id='" + lblnewid.Text + "'";
        db.ExecuteNonQuery(updsql, CommandType.Text);
        GridView1.EditIndex = -1;
        FillGrid();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
        string delsql = "DELETE FROM news WHERE Id='" + id + "'";
        db.ExecuteNonQuery(delsql, CommandType.Text);
        FillGrid();
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.Equals("Insert"))
        {
            TextBox txtNewName = (TextBox)GridView1.FooterRow.FindControl("txtNewName");
            string inssql = "INSERT INTO news(Title) VALUES('" + txtNewName.Text + "')";
            db.ExecuteNonQuery(inssql, CommandType.Text);
            FillGrid();
        }
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        FillGrid();
    }
}

lx_nq

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
gridview 绑定数据.实现update、delete、insert into、分页功能

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="800px" AllowPaging="True" DataKeyNames="Id"
复制链接

扫一扫