GiedView的编辑,更新,删除,排序等

有个小伙伴在用gridview,我是多年没用了,找以前的文章,发出来给他看看。

/*页面 aspx 代码*/

<asp:GridView ID="GridView1" runat="server" PageSize="2" AllowPaging="True" AllowSorting="True" OnSorting="GridView1_Sorting" AutoGenerateColumns="False" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowEditing="GridView1_RowEditing" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowUpdating="GridView1_RowUpdating" OnRowDeleting="GridView1_RowDeleting" >
            <Columns>
                <asp:BoundField HeaderText="编号" DataField="id" SortExpression="id" ReadOnly="True" />
                <asp:TemplateField HeaderText="简称"  SortExpression="shortname">
                    <ItemTemplate>
                        <%# Eval("shortname") %>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="txtEdShortName" Width="100px"  runat="server" Text='<%# Eval("shortname") %>'></asp:TextBox> 
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:TextBox ID="txtInShortName" runat="server"></asp:TextBox> 
                    </InsertItemTemplate>
                    <ItemStyle Width="100px" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="省份" SortExpression="name">
                    <ItemTemplate>
                        <%# Eval("name") %>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="txtEdName" Width="100px" runat="server" Text='<%# Eval("name") %>'></asp:TextBox> 
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:TextBox ID="txtInName" runat="server"></asp:TextBox> 
                    </InsertItemTemplate>
                    <ItemStyle Width="100px" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="操作">
                    <ItemTemplate>
                       <asp:Button Text="编辑" CommandName="Edit" CausesValidation="false" runat="server" ID="btEdit" />&nbsp;
                       <asp:Button Text="删除" OnClientClick="return confirm('确认要删除吗?');" CommandName="Delete" CausesValidation="false" runat="server" ID="btDelete" />
                    </ItemTemplate>
                    <EditItemTemplate>
                       <asp:Button Text="更新" CommandName="Update" CausesValidation="true" runat="server" ID="btUpdate" />&nbsp;
                       <asp:Button Text="取消" CommandName="Cancel" CausesValidation="false" runat="server" ID="btCancel" />
                    </EditItemTemplate>
                </asp:TemplateField>
                <%--<asp:CommandField HeaderText="操作" DeleteText="&lt;div id=&quot;de&quot; onclick=&quot;JavaScript:return confirm('确定删除吗?')&quot;&gt;删除&lt;/div&gt; " ShowEditButton="True"  ShowDeleteButton="True" ShowHeader="True" />--%>
            </Columns>
        </asp:GridView>

 

/*后台 CS 代码*/

 private string strSQL = "server=localhost;database=test;uid=sa;password=123456";

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            GetAllPrivence();//绑定数据
            ViewState["sortColumn"] = "id";//初始排序字段
            ViewState["sortDirection"] = "ASC";//初始排序方向

        }
    }

    /// <summary>
    /// GridView绑定数据源
    /// </summary>
    public void GetAllPrivence()
    {
        SqlConnection con = new SqlConnection(strSQL);
        con.Open();
        try
        {
            string sql = string.Format("select * from Province order by id");
            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "tempProvince");

            this.GridView1.DataSource = ds;
            this.GridView1.DataBind();
        }
        catch (Exception)
        {
            throw;
        }
        finally
        {
            con.Close();
        }
    }

    /// <summary>
    /// 排序的方法
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        if (ViewState["sortColumn"].ToString() == e.SortExpression.ToString())
        {
            if ("ASC" == ViewState["sortDirection"].ToString())
            {
                ViewState["sortDirection"] = "DESC";
            }
            else
            {
                ViewState["sortDirection"] = "ASC";
            }

            //重新绑定数据
            Sort(ViewState["sortColumn"].ToString(), ViewState["sortDirection"].ToString());
        }
        else
        {
            ViewState["sortColumn"] = e.SortExpression.ToString();
            ViewState["sortDirection"] = "ASC";

            //重新绑定数据
            Sort(ViewState["sortColumn"].ToString(), ViewState["sortDirection"].ToString());
        }
    }

    /// <summary>
    /// 排序后重新绑定数据的方法
    /// </summary>
    /// <param name="sortColumn"></param>
    /// <param name="sortDirection"></param>
    protected void Sort(string sortColumn,string sortDirection)
    {
        SqlConnection con = new SqlConnection(strSQL);
        con.Open();
        try
        {
            string sql = string.Format("select * from Province order by {0} {1}", sortColumn,sortDirection);
            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "tempProvince");

            this.GridView1.DataSource = ds;
            this.GridView1.DataBind();
        }

        catch (Exception)
        {
            throw;
        }
        finally
        {
            con.Close();
        }
    }

    /// <summary>
    /// 分页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        Sort(ViewState["sortColumn"].ToString(), ViewState["sortDirection"].ToString());
    }

    /// <summary>
    /// 编辑
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex = e.NewEditIndex;
        GetAllPrivence();
    }

    /// <summary>
    /// 取消编辑
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        GetAllPrivence();
    }

    /// <summary>
    /// 更新事件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        TextBox txtPName = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtEdName");
        TextBox txtSName = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtEdShortName");
        int id = Convert.ToInt32(this.GridView1.Rows[e.RowIndex].Cells[0].Text);
        string pname = txtPName.Text.ToString();
        string sname = txtSName.Text.ToString();
        string sql = string.Format("update Province set shortname='{0}',name='{1}' where id='{2}'",sname,pname,id);
        SQLHelper.ExecuteCommand(sql);

        this.GridView1.EditIndex = -1;
        GetAllPrivence();
    }

    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int id = Convert.ToInt32(this.GridView1.Rows[e.RowIndex].Cells[0].Text);
        //Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>confirm('确认要删除吗?');</script>")
        //<div id="de" onclick="JavaScript:return confirm('确定删除吗?')">删除</div> 
        string sql = string.Format("delete Province where id='{0}'", id);
        SQLHelper.ExecuteCommand(sql);

        GetAllPrivence();
    }

 

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
爬虫(Web Crawler)是一种自动化程序,用于从互联网上收集信息。其主要功能是访问网页、提取数据并存储,以便后续分析或展示。爬虫通常由搜索引擎、数据挖掘工具、监测系统等应用于网络数据抓取的场景。 爬虫的工作流程包括以下几个关键步骤: URL收集: 爬虫从一个或多个初始URL开始,递归或迭代地发现新的URL,构建一个URL队列。这些URL可以通过链接分析、站点地图、搜索引擎等方式获取。 请求网页: 爬虫使用HTTP或其他协议向目标URL发起请求,获取网页的HTML内容。这通常通过HTTP请求库实现,如Python中的Requests库。 解析内容: 爬虫对获取的HTML进行解析,提取有用的信息。常用的解析工具有正则表达式、XPath、Beautiful Soup等。这些工具帮助爬虫定位和提取目标数据,如文本、图片、链接等。 数据存储: 爬虫将提取的数据存储到数据库、文件或其他存储介质中,以备后续分析或展示。常用的存储形式包括关系型数据库、NoSQL数据库、JSON文件等。 遵守规则: 为避免对网站造成过大负担或触发反爬虫机制,爬虫需要遵守网站的robots.txt协议,限制访问频率和深度,并模拟人类访问行为,如设置User-Agent。 反爬虫应对: 由于爬虫的存在,一些网站采取了反爬虫措施,如验证码、IP封锁等。爬虫工程师需要设计相应的策略来应对这些挑战。 爬虫在各个领域都有广泛的应用,包括搜索引擎索引、数据挖掘、价格监测、新闻聚合等。然而,使用爬虫需要遵守法律和伦理规范,尊重网站的使用政策,并确保对被访问网站的服务器负责。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值