what is the best way to make a DataTable thread safe? DataTable.Accep tChanges() will throw exception (not documented)

Hi,

In the .NET Framework SDK documentation, I can see DataRow.AcceptC hanges
method will throw RowNotInTableEx ception exeception.

And in DataTable.Accep tChanges(), the documentation does not mention it will
throw any exception, but in my code (multi-thread), I see it throw
exceptions at two situations:

dr = this.currentQuo taUserDt.NewRow ();

this.currentQuo taUserDt.Rows.A dd(dr);

this.currentQuo taUserDt.Accept Changes();

Last line throw exception : Cannot perform this operation on a row not in
the table.

(Code is more complex than what list here and it is multi-thread
enviorment.)

==============
this.currentDr. Delete();
this.currentDr. Table.AcceptCha nges();

The last line will throw:
System.Data.Row NotInTableExcep tion: Cannot perform this operation on a row
not in the table.
at System.Data.Dat aTable.SetOldRe cord(DataRow row, Int32 proposedRecord)
at System.Data.Dat aTable.CommitRo w(DataRow row)
at System.Data.Dat aTable.AcceptCh anges()

Thanks,
Ryan

Ryan,
It is not clearly evident from your post how you could have gotten the
exception you report, but if you want to ensure thread safety, you can use
the lock statement on a local object variable:

object locker = new object();
lock (locker)
{

// your code here
}

--Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Ryan Liu" wrote:

Hi,

In the .NET Framework SDK documentation, I can see DataRow.AcceptC hanges
method will throw RowNotInTableEx ception exeception.

And in DataTable.Accep tChanges(), the documentation does not mention it
will
throw any exception, but in my code (multi-thread), I see it throw
exceptions at two situations:

dr = this.currentQuo taUserDt.NewRow ();

this.currentQuo taUserDt.Rows.A dd(dr);

this.currentQuo taUserDt.Accept Changes();

Last line throw exception : Cannot perform this operation on a row not
in
the table.

(Code is more complex than what list here and it is multi-thread
enviorment.)

==============
this.currentDr. Delete();
this.currentDr. Table.AcceptCha nges();

The last line will throw:
System.Data.Row NotInTableExcep tion: Cannot perform this operation on a
row
not in the table.
at System.Data.Dat aTable.SetOldRe cord(DataRow row, Int32
proposedRecord)
at System.Data.Dat aTable.CommitRo w(DataRow row)
at System.Data.Dat aTable.AcceptCh anges()

Thanks,
Ryan

Peter,

That's assuming that the data table is only being accessed in that
method, and that method is the only one that is being called from other
threads.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Peter Bromberg [C# MVP]" <pb*******@yaho o.nospammin.com > wrote in message
news:8D******** *************** ***********@mic rosoft.com...

Ryan,
It is not clearly evident from your post how you could have gotten the
exception you report, but if you want to ensure thread safety, you can use
the lock statement on a local object variable:

object locker = new object();
lock (locker)
{

// your code here
}

--Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Ryan Liu" wrote:

Hi,

In the .NET Framework SDK documentation, I can see DataRow.AcceptC hanges
method will throw RowNotInTableEx ception exeception.

And in DataTable.Accep tChanges(), the documentation does not mention it
will
throw any exception, but in my code (multi-thread), I see it throw
exceptions at two situations:

dr = this.currentQuo taUserDt.NewRow ();

this.currentQuo taUserDt.Rows.A dd(dr);

this.currentQuo taUserDt.Accept Changes();

Last line throw exception : Cannot perform this operation on a row not
in
the table.

(Code is more complex than what list here and it is multi-thread
enviorment.)

==============
this.currentDr. Delete();
this.currentDr. Table.AcceptCha nges();

The last line will throw:
System.Data.Row NotInTableExcep tion: Cannot perform this operation on a
row
not in the table.
at System.Data.Dat aTable.SetOldRe cord(DataRow row, Int32
proposedRecord)
at System.Data.Dat aTable.CommitRo w(DataRow row)
at System.Data.Dat aTable.AcceptCh anges()

Thanks,
Ryan