CODEWITHSUNDEEP
sqlitedatatabledatarowdelphi-prismoxygene
ThN
ThN

Reputation: 3278

Type mismatch, cannot assign System.Data.DataRowCollection to array of System.Data.DataRow

I want to be able to traverse through a list of DataRow using For each loop as follows.

  ArrayOfRows: Array of DataRow;

  ArrayOfRows := dbtable.Rows;

  for each therow in ArrayofRows do
  begin
    ITagList.Add(therow['TAGNAME'].ToString);
  end;

But I keep running to the error,

"Type mismatch, cannot assign System.Data.DataRowCollection to array of System.Data.DataRow."

How do you traverse through a list of rows in a datatable?

Thanks in advance,

Upvotes: 0

Views: 433

Answers (1)

Ken White
Ken White

Reputation: 125620

Use System.Data.DataRowCollection.CopyTo(), which is designed to do exactly this.

public override void CopyTo(
Array ar,
int index
)

The parameters are the array you want to copy into, and the zero-based index where the copy should start.

Upvotes: 1

Related Questions