难题 ！帮忙。谢谢

Question

忘了说，，我用的是ACCESS的数据库。有谁会帮忙帮忙呀，，，，谢谢了，

Answer 1

            aConn.Open();
            OdbcCommand aCmd = new OdbcCommand();
            OdbcDataAdapter adp = new OdbcDataAdapter("SELECT * FROM TABLE1 ORDER BY CNAME", aConn);
            OdbcCommandBuilder acb = new OdbcCommandBuilder(adp);
            adp.UpdateCommand = acb.GetUpdateCommand();
            DataSet aDS = new DataSet();
            adp.Fill(aDS);            string OldName = "";
            int CurrentNum = 1;
            foreach (DataRow aRow in aDS.Tables[0].Rows)
            {
                string NewName = (string)aRow["CNAME"];
                if (NewName.CompareTo(OldName) == 0)
                {
                    CurrentNum++;
                    aRow["CVALUE"] = CurrentNum.ToString("0000");
                    
                }
                else 
                {
                    OldName = NewName;
                    CurrentNum = 1;
                    aRow["CVALUE"] = "0001";
                }
            }
            adp.Update(aDS.Tables[0]);

Answer 2

TO：dirt
这位大哥，字段说明一下，
我上面有给出字段。
谢谢。！！

Answer 3

CNAME相当于MC
CVALUE相当于BH