C#

int numRows = myDataTable.Rows.Count;
for(int i=0; i<numRows-1;i++)
{
    DataRow currentRow = myDataTable.Rows[i];
    DataRow nextRow = myDataTable.Rows[i+1];
    // Do stuff with the current and next rows here
}

avanwieren wrote:

just curious if there was a way to do it with the foreach loop.

Luc Pattyn wrote:

foreach (DataRow row in myDataTable.Rows) {...}

DataRow previousRow=null;

foreach (DataRow row in myDataTable.Rows) {
    // whatever needs to be done comes here, be careful though previousRow may be null
    // ...
    previousRow=row;  // last line in foreach block
}

DataRow previousRow=aDummyDataRow;

foreach (DataRow row in myDataTable.Rows) {
    // whatever needs to be done comes here, be careful though previousRow may be null
    // ...
    previousRow=row;  // last line in foreach block
}

DataRow previousRow=null;

foreach (DataRow row in myDataTable.Rows) {
    if (previousRow!=null) {
        // whatever needs to be done comes here
        // ...
    }
    previousRow=row;  // last line in foreach block
}

Colin Angus Mackay wrote:

I'd rather have something that had simpler logic and was easier to read and understand.

ams7 wrote:

how to doing setup project my application in c#

ams7 wrote:

in any computer dont have .net

Bulky Fellow wrote:

SQL server 2007.

CREATE TABLE dbo.SomeTableName
(
    SomeColumnName INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
    Name CHAR(100) NOT NULL,
    address CHAR(200) NOT NULL
);