Gridview控件

来源：互联网发布：网络打印机关机后编辑：程序博客网时间：2024/05/01 00:18

前台代码：

后台代码：

   protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }
    private void bind()
    {

        GridView1.DataSource = gridview.sqlcomand("SELECT [hao],[sid], [name] ,[sex] FROM [sperson]");
        GridView1.DataKeyNames = new string[] { "hao" };
        GridView1.AllowPaging = true;
        GridView1.PageSize = 5;

        GridView1.DataBind();
        Label3.Text = Convert.ToString(GridView1.PageIndex + 1);
        Label4.Text = Convert.ToString(GridView1.PageCount);
        if (GridView1.PageIndex == 0)
        {
            Button2.Enabled = false;
            Button3.Enabled = true;
        }
        else
        {
            if (GridView1.PageIndex == GridView1.PageCount - 1)
            {
                Button2.Enabled = true;
                Button3.Enabled = false;
            }
            else
            {
                Button2.Enabled = true;
                Button3.Enabled = true;

}

}
}

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        GridViewRow row = GridView1.Rows[e.RowIndex];
        string hao = GridView1.DataKeys[e.RowIndex].Values[0].ToString();

        string str = "delete from sperson where hao='" + hao + "'";
        if (gridview.sqlsc(str) > 0)
        {
            Response.Write("<script> alert('数据删除成功');</script>");

        }
        bind();
        GridView1.EditIndex =1;

    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow row = GridView1.Rows[e.RowIndex];
        string hao = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
        string ssid=((TextBox)row.FindControl("ssid")).Text.ToString();
        string sname = ((TextBox)row.FindControl("sname")).Text.ToString();
        string ssex = ((TextBox)row.FindControl("ssex")).Text.ToString();

        string str = "update sperson set name='" +sname+ "',sex='"+ssex+"',sid='"+ssid+"' where hao='" + hao + "'";
        if ( gridview.sqlgx(str)>0)
        {
            //Response.Write("<script> alert('数据更新成功');</script>");
        }
        GridView1.EditIndex = -1;
        bind();
    }
    protected void allcheck_CheckedChanged(object sender, EventArgs e)
    {
        foreach (GridViewRow gr in GridView1.Rows)
        {
            CheckBox chk = (CheckBox)gr.Cells[4].FindControl("everycheck");
            if (!chk.Checked)
                chk.Checked = true;
            else
                chk.Checked = false;
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow gr in GridView1.Rows)
        {
            CheckBox chk = (CheckBox)gr.Cells[4].FindControl("everycheck");
            if (chk.Checked)
            {
                Label lb = (Label)gr.Cells[1].FindControl("label2");
                string hao = lb.Text.ToString();
                string str = "delete from sperson where hao='" + hao + "'";
                if (gridview.sqlsc(str) <= 0)
                {
                    Response.Write("<script> alert('数据删除失败');</script>");
                }
            }
            bind();
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        GridView1.PageIndex = GridView1.PageIndex - 1;
        bind();
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        GridView1.PageIndex = GridView1.PageIndex + 1;
        bind();
    }

gridview类代码：

#region 数据库连接操作
    public static SqlConnection CreateCon()
    {
        string con = ConfigurationManager.ConnectionStrings["SQLCONN"].ConnectionString;
        return (new SqlConnection(con));
    }
    #endregion

    #region 数据查询
    public static DataSet sqlcomand(string a)
    {
        SqlConnection conn = CreateCon();
        conn.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(a,conn);
        da.Fill(ds);
        conn.Close();
        return ds;
    }
    #endregion

    #region 数据条件删除
    public static int sqlsc(string a)
    {
        SqlConnection conn = CreateCon();
        int biao= 0;
        conn.Open();
        SqlCommand cmd = new SqlCommand(a,conn);
        biao = cmd.ExecuteNonQuery();
        if (biao>0)
        {
            biao = 1;
        }
        else
        {
            biao = 0;
        }
        conn.Close();
        return biao;
    }
    #endregion

    #region 数据更新
    public static int sqlgx(string b)
    {
        SqlConnection conn = CreateCon();
        conn.Open();
        SqlCommand cmd = new SqlCommand(b, conn);
        int dr = (int)cmd.ExecuteNonQuery();
        conn.Close();
        return dr;
    }
    #endregion