有关gridview的代码

最新推荐文章于 2019-01-08 02:29:01 发布

hustneverland

最新推荐文章于 2019-01-08 02:29:01 发布

阅读量260

点赞数

文章标签： object dataset textbox string table button

本文链接：https://blog.csdn.net/hustneverland/article/details/5991695

版权

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

public partial class test : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string strCon = "server=localhost;Database=testpicture;integrated security=true;";

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

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from table_pic2 where picid2=" + GridView1.DataKeys[e.RowIndex].Value.ToString() + ";";
        sqlcon = new SqlConnection(strCon);
        sqlcom = new SqlCommand(sqlstr, sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        bind();

    }
    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)
    {
        sqlcon = new SqlConnection(strCon);
        string sqlstr = "update table_pic2 set description='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',path2='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "'where picid2="
            + Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value)+ ";";
        sqlcom = new SqlCommand(sqlstr, sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();

}

      public void bind()
    {
        string sqlstr = "select * from table_pic2";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "table_pic2");
        GridView1.DataKeyNames = new string[] {"picid2"};//主键
        GridView1.DataSource = myds;
        GridView1.DataBind();
        sqlcon.Close();
    }

      //protected void pageIndexChange(object sender, GridViewPageEventArgs e)
      //{
      //    GridView1.PageIndex = e.NewPageIndex;
      //    bind(); //重新绑定GridView数据的函数
      //}

      protected void Button1_Click(object sender, EventArgs e)
      {
          if (GridView1.PageIndex == GridView1.PageCount - 1)
          {
              GridView1.PageIndex = 0;
          }
          else
          {
              GridView1.PageIndex++;
          }
          bind();
      }
      protected void Button2_Click(object sender, EventArgs e)
      {
          if (GridView1.PageIndex == 0)
          {
              GridView1.PageIndex = GridView1.PageCount - 1;
          }
          else
          {
              GridView1.PageIndex--;
          }
          bind();
      }
}