string con = WebConfigurationManager.ConnectionStrings["insystemConnectionString"].ConnectionString;
    SqlConnection conn;
    SqlCommand com;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }

//DataSet和GridView绑定
    public void bind()
    {
        conn = new SqlConnection(con);
        conn.Open();
        SqlDataAdapter thisAdapter = new SqlDataAdapter("select * from jz", conn);
        SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
        DataSet thisDataSet = new DataSet();
        thisAdapter.Fill(thisDataSet, "jz");

        GridView1.DataSource = thisDataSet.Tables["jz"];
        GridView1.DataBind();
        GridView1.DataKeyNames = new string[] { "szd" };

        conn.Close();
    }

  //编辑按钮
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        bind();
    }           //以下为删除按钮事件
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string strsql = "delete from jz where szd=" + GridView1.DataKeys[e.RowIndex].Value.ToString();
        conn = new SqlConnection(con);
        com = new SqlCommand(strsql, conn);
        conn.Open();
        com.ExecuteNonQuery();
        conn.Close();
        bind();

    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }