Recordset rd = dv.GetRecordset(false, CursorType.Dynamic);
// 获得记录集对应的批量更新对象
Recordset.BatchEditor editor = rd.Batch;
editor.MaxRecordCount = 1;
editor.Begin();
int i = 0;
while (!rd.IsEOF)
{
string SmUserId = rd.GetString("SmUserId");
if (SmUserId.Equals("1"))
{
Dictionary<string, object> dataMap = new Dictionary<string, object>();
dataMap.Add("wataerQuality", "ph9999");
rd.SetValues(dataMap);
}
rd.MoveNext();
}
// 批量操作统一提交
editor.Update();
L3D.UpdateData();
// 释放记录
rd.Dispose();
// 获得记录集对应的批量更新对象
Recordset.BatchEditor editor = rd.Batch;
editor.MaxRecordCount = 1;
editor.Begin();
int i = 0;
while (!rd.IsEOF)
{
string SmUserId = rd.GetString("SmUserId");
if (SmUserId.Equals("1"))
{
Dictionary<string, object> dataMap = new Dictionary<string, object>();
dataMap.Add("wataerQuality", "ph9999");
rd.SetValues(dataMap);
}
rd.MoveNext();
}
// 批量操作统一提交
editor.Update();
L3D.UpdateData();
// 释放记录
rd.Dispose();