|
From: Le r. A. <ar...@me...> - 2006-06-28 15:56:20
|
> Would that be something like this ??
>
> command.CommandText =3D "SELECT FIRST (@first) SKIP (@skip) PKID, =
>
> Username, Email, PasswordQuestion," +
> " Comment, IsApproved, IsLockedOut, CreationDate, LastLoginDate," +
> " LastActivityDate, LastPasswordChangedDate, LastLockedOutDate " +
> " FROM " + this.tableName +
> " WHERE ApplicationName =3D @ApplicationName " +
> " ORDER BY Username Asc";
>
> command.Parameters.Add("@first", FbDbType.Integer).Value =3D pageSize;
> command.Parameters.Add("@skip", FbDbType.Integer).Value =3D startIndex;
>
yes, it's seems to be good
|