SQLDataRow
While
SQLData
objects represent the whole
result of a query,
SQLDataRow
objects represent only a
single row. This is useful in
foreach
statements where you can
iterate over
SQLData
objects and store the current
row 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")); }