loop in sql table

[costavo]

hi all, i have to loop in a table in sql database to find a certain record and compare it or what ever,.... the question is what steps i have to do to loop in a table using c# lang in a win app. regards

[Colin Angus Mackay]

costavo wrote:

or what ever

:rolleyes:

costavo wrote:

i have to loop in a table in sql database to find a certain record and compare it or what ever,.... the question is what steps i have to do to loop in a table using c# lang in a win app.

I presume you are talking about a DataTable rather than one in SQL Server.

foreach(DataRow row in myDataTable.Rows)
{
// Do what you need to here.
}

---

-- Always write code as if the maintenance programmer were an axe murderer who knows where you live. Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ... * Reading: SQL Bits My website