Admin/gangweiList.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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 Admin_gangweiList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            GridDataBind();
        }
    }
    private void GridDataBind()
    {
        string strsql = "select a.*,b.mingcheng from gangwei a left join qiye b on a.qiyebianhao=b.bianhao";
        if (this.TextBox1.Text != "")
        {
            strsql += " and mingcheng='" + this.TextBox1.Text + "'";
        }
        DataSet ds = sqlconn.dataquery(strsql);
        GridViewUser.DataSource = ds.Tables[0];
        GridViewUser.DataBind();
    }
    /// <summary>
    /// 传递编辑数据
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridViewClient_Editing(object sender, GridViewEditEventArgs e)
    {
        string ID = GridViewUser.Rows[e.NewEditIndex].Cells[0].Text;
        Response.Redirect("gangweituijian.aspx?id=" + ID + "");
    }
    
    /// <summary>
    /// 分页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridViewUser_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridViewUser.PageIndex = e.NewPageIndex;
        GridDataBind();
    }


    protected void btnAdd_Click(object sender, ImageClickEventArgs e)
    {
        Response.Redirect("gangweiAdd.aspx");
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        GridDataBind();
    }
}