.net access 删除数据库记录操作

最新推荐文章于 2019-05-13 22:35:09 发布

zxmsmile

最新推荐文章于 2019-05-13 22:35:09 发布

阅读量729

点赞数

分类专栏：学习日记文章标签： access 数据库 .net comments delete cmd

本文链接：https://blog.csdn.net/zxmsmile/article/details/4040834

版权

学习日记专栏收录该内容

14 篇文章 0 订阅

订阅专栏

for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
        {
            CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            if (cbox.Checked == true)
            {

// OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("/test/#db.mdb"));
// //OleDbCommand cmd = new OleDbCommand("delete from comments where id='" + GridView1.DataKeys[i].Value + "'", conn);
// OleDbCommand cmd = new OleDbCommand("delete from comments where id=" +Convert.ToInt32(GridView1.DataKeys[i].Value)+ "", conn);

               // conn.Open();
               //cmd.ExecuteNonQuery();
               // conn.Close();
                string strconn = "provider = Microsoft.Jet.OLEDB.4.0;Data Source = " + Server.MapPath("/test/#db.mdb");
                OleDbConnection conn = new OleDbConnection(strconn);
                conn.Open();
                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = conn;
                string strDel;
                strDel = "delete from comments where comm_id=@sid";
                cmd.Parameters.Add("@sid", OleDbType.Integer).Value = Convert.ToInt32(GridView1.DataKeys[i].Value);
                cmd.CommandText = strDel;
                cmd.ExecuteNonQuery();
                conn.Close();
            }

        }