GridView删除某行

private void BindGridView()
{
    SqlConnection cn = new SqlConnection(@"server=.//SQLExpress;uid=sa;pwd=;database=Demo");
    SqlDataAdapter da = new SqlDataAdapter("select id, name from yourtable", cn);
    DataSet ds = new DataSet();
    cn.Open();
    da.Fill(ds);
    cn.Close();
    GridView1.DataSource = ds.Tables[0].DefaultView;
    GridView1.DataKeyNames = new string[] { "id" };
    GridView1.DataBind();
}

protected void Page_Load(object sender, EventArgs e)
{
        string js = "var confirm_this='你确定要删除吗？';";
        ClientScriptManager csm = Page.ClientScript;
        if (!csm.IsStartupScriptRegistered("_confirm"))
        {
            csm.RegisterStartupScript(this.GetType(), "_confirm", js, true);
        }
    if (!IsPostBack)
    {
        BindGridView();
    }
}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            LinkButton lbtn = e.Row.Cells[0].Controls[0] as LinkButton;
            if (lbtn != null)
            {
                lbtn.Attributes.Add("onclick", "return confirm('你确定要删除"+e.Row.Cells[3].Text+"吗?')");
            }
    }




protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
    string strSql = "delete from yourtable where id = @id";
    SqlConnection cn = new SqlConnection(@"server=.//SQLExpress;uid=sa;pwd=;database=Demo");
    SqlCommand cmd = new SqlCommand(strSql, cn);
    cmd.Parameters.Add("@id", SqlDbType.VarChar, 11).Value = GridView1.DataKeys[e.RowIndex].Value.ToString();
    cn.Open();
    cmd.ExecuteNonQuery();
    cn.Close();
    BindGridView();

/*

  string  pro1 = this.GridView1.DataKeys[e.RowIndex].Value .ToString ();//得到删除行的索引
        int pro = Convert.ToInt32(pro1);
        SqlConnection con = DB.createCon();
      
        SqlCommand cmd = new SqlCommand("delete from city where cityID='" + pro + "'", con);con.Open();
        cmd.ExecuteNonQuery();
        this.DataBind1();
       

*/
}