SQLDataRow

Unlike SQLData objects represent the whole result of a query, SQLDataRow objects represent only a single row. This is useful in foreach statements to iterate over SQLData objects. The current row is stored in an iterator variable of the type SQLDataRow.

SQLConnection connection = SQLCreateConnection("connection string");
SQLData resultData = SQLExecuteQuery( connection, "Select * from employees" );
foreach (SQLDataRow row in resultData)
{
	WriteLine(SQLDataRowGetString(row, "name"));
}