DataRow.Delete( ) throws System.Argument OutOfRangeExcep tion: Non-negative number required.

[Ryan Liu]

Hi,

When my code run to
DataRow.Delete( )

It throws:

System.Argument OutOfRangeExcep tion: Non-negative number required.
Parameter name: length
at System.Array.Co py(Array sourceArray, Int32 sourceIndex, Array
destinationArra y, Int32 destinationInde x, Int32 length)
at System.Data.Ind ex.DeleteRecord (Int32 recordIndex)
at System.Data.Ind ex.ApplyChangeA ction(Int32 record, Int32 action)
at System.Data.Dat aTable.RecordSt ateChanged(Int3 2 record1,
DataViewRowStat e oldState1, DataViewRowStat e newState1, Int32 record2,
DataViewRowStat e oldState2, DataViewRowStat e newState2)
at System.Data.Dat aTable.SetNewRe cord(DataRow row, Int32 proposedRecord,
DataRowAction action, Boolean isInMerge)
at System.Data.Dat aRow.Delete()


The datetable it belongs has a primary key:
DataColumn dcUserLoginName =new DataColumn(User LoginName,
typeof(string)) ;
dcUserLoginName .AllowDBNull = false;
this.currentQuo taUserDt.Column s.Add(dcUserLog inName);
this.currentQuo taUserDt.Primar yKey = new DataColumn[] {dcUserLoginNam e};

Can someone tell me how could this happen and how to prevent it?
Thanks a lot!
Ryan

[Shawn Wildermuth (C# MVP)]

Hello Ryan,

You're not allowed to delete data in a DataSet...no... no...no....I am kidding...

Any chance that DataTable has a DataView associated with it somewhere? I
have seen this happen when an errant DataView was created and hasn't been
collected.
Thanks,
Shawn Wildermuth
Speaker, Author and C# MVP
http://adoguy.com

Hi,

When my code run to
DataRow.Delete( )
It throws:

System.Argument OutOfRangeExcep tion: Non-negative number required.
Parameter name: length
at System.Array.Co py(Array sourceArray, Int32 sourceIndex, Array
destinationArra y, Int32 destinationInde x, Int32 length)
at System.Data.Ind ex.DeleteRecord (Int32 recordIndex)
at System.Data.Ind ex.ApplyChangeA ction(Int32 record, Int32 action)
at System.Data.Dat aTable.RecordSt ateChanged(Int3 2 record1,
DataViewRowStat e oldState1, DataViewRowStat e newState1, Int32 record2,
DataViewRowStat e oldState2, DataViewRowStat e newState2)
at System.Data.Dat aTable.SetNewRe cord(DataRow row, Int32
proposedRecord,
DataRowAction action, Boolean isInMerge)
at System.Data.Dat aRow.Delete()
The datetable it belongs has a primary key:

DataColumn dcUserLoginName =new DataColumn(User LoginName,
typeof(string)) ;
dcUserLoginName .AllowDBNull = false;
this.currentQuo taUserDt.Column s.Add(dcUserLog inName);
this.currentQuo taUserDt.Primar yKey = new DataColumn[]
{dcUserLoginNam e};
Can someone tell me how could this happen and how to prevent it?

Thanks a lot!
Ryan