soRecordset循环中删除研究

最新推荐文章于 2021-12-12 12:52:23 发布

原创最新推荐文章于 2021-12-12 12:52:23 发布 · 931 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#null

SuperMap编程专栏收录该内容

9 篇文章

订阅专栏

本文探讨了在使用记录集（Recordset）进行数据查询后，如何遍历记录并在特定条件下删除某条记录的方法。通过MoveLast()和MovePrev()方法结合循环实现逆序遍历，并演示了删除第三条记录的具体操作及对RecordCount的影响。

soRecordset rs_a = dv_a.Query("2>1", true, null, "");
                        if (rs_a != null)
                        {
                            int rsCnt = rs_a.RecordCount;
                            if (rsCnt > 0)
                            {
                                rs_a.MoveLast();
                                for (int i = rsCnt;i>0 ; i--)
                                {
                                    //Console.WriteLine(rs_a.GetFieldValueText ("smid")); 
                                    Console.WriteLine(rs_a.GetID());
                                    if (i == 3)
                                    {
                                        rs_a.Delete();
                                        Console.WriteLine(rs_a.GetID());
                                    }
                                    rs_a.MovePrev();
                                }
                            }
                            Marshal.ReleaseComObject(rs_a);
                            rs_a = null;