ASP.NET实现增删改查等功能(Access版)系统之四-删除

根据主键来删除表中的数据。

//删除

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

    {

        OleDbConnection sqlConnection = new OleDbConnection(GetConnection());

 

        string sqlstr = "delete from MResume where id=" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "";

        OleDbCommand sqlcom = new OleDbCommand(sqlstr, sqlConnection);

        sqlConnection.Open();

        sqlcom.ExecuteNonQuery();

        sqlConnection.Close();

        //PopulatePublishersGridView();

        string sqlstr2 = getSQlStr();

        bind(sqlstr2);

    }