开发者

Read DataTable by RowState

开发者 https://www.devze.com 2022-12-28 14:36 出处:网络
I am reading my DataTable as follow: foreach ( DataRow o_DataRow in vco_DataTable.Rows ) { //Insert More Here

I am reading my DataTable as follow:

foreach ( DataRow o_DataRow in vco_DataTable.Rows )
{
//Insert More Here
}

It crash; because I insert开发者_如何学Go more records.

How can I read my DataTable without reading the new records? Can I read by RowState?

Thanks


Since I don't know what language you are using I can only give general advice.

In most (all?) languages it's not possible to do a foreach over a collection if you are modifying the collection. There are two common ways to deal with this.

Wild ass guessing pseudo code follows:

// first way uses array notation (if possible)
var no_of_rows = vco_DataTable.Rows.count();
for(var i = 0; i < no_of_rows; i++) {
  DataRow o_DataRow = vco_DataTable.Rows[i];
  //Insert More Here
}

// The second way copies the data
var my_copy = vco_DataTable.Copy()
foreach ( DataRow o_DataRow in my_copy.Rows )
{
   //Insert More into vco_DataTable Here
}
copy.Dispose() // delete/destroy the copy
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号