如何删除dataset中的某行数据

Question

string dbPath = @"D:\历年高考分数.db";
            string sq = @"Data Source=" + dbPath;
            m = new SQLiteConnection(sq);
            m.Open();
            SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select Volume1,Volume2 from 曲线", m);
            DataSet ds = new DataSet();
            mAdapter.Fill(ds);
            DataTable dt = ds.Tables[0];
            if (Flag == 4)
            {
                SQLiteCommandBuilder cmdb = new SQLiteCommandBuilder(mAdapter);
                ds.Tables[0].Rows[0].Delete();
                //DataSet.AcceptChanges();
                mAdapter.DeleteCommand = cmdb.GetDeleteCommand();
                mAdapter.Update(ds);
            }
                          private void button3_Click(object sender, EventArgs e)
        {
            Flag = 4;
        }

删除某行数据，会提示对于不返回任何键列信息的 SelectCommand，不支持 DeleteCommand 的动态 SQL 生成。如何处理

Answer 1

直接调用sql语句，不过你的数据库表中要有主键，才能删除
delete * from table where 主键 = xxx