string sql = "SELECT * FROM yourTable";
DataSet myds = new DataSet();
SqlAdapter myadp = new SqlAdapter(sql ,.....);
myadp.fill(myds);
DataRow myr ;
int i=1
foreach myr in myds.tabls[0].rows
{
if( i>= 5 && i<=8)
{
//处理5-8号记录
}
if (i>= 8)
break; //此时不需要再往下处理;退出
i++;
}
DataSet myds = new DataSet();
SqlAdapter myadp = new SqlAdapter(sql ,.....);
myadp.fill(myds);
DataRow myr ;
int i=1
foreach myr in myds.tabls[0].rows
{
if( i>= 5 && i<=8)
{
//处理5-8号记录
}
if (i>= 8)
break; //此时不需要再往下处理;退出
i++;
}
select top 4 * from
(select top 8 * from authors order by au_id) as tt
order by au_id desc
select top 8 * from authors order by au_id
SELECT LastName, FirstName FROM Northwind.dbo.Employees
OPEN Employee_Cursor
DECLARE @COUNT INT
SET @COUNT=5
FETCH ABSOLUTE @COUNT FROM Employee_Cursor
SET @COUNT=@COUNT + 1
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Employee_Cursor
IF @COUNT=8
BREAK
SET @COUNT=@COUNT + 1
END
CLOSE Employee_Cursor
DEALLOCATE Employee_Cursor
SqlCommand cmd=new SqlCommand(sSQL,myConn);
myConn.open();
SqlDataReader rdr=cmd.excutereader();
int i=1;
while (rdr.read())
{
if (i<=8 & i>=5)
{
....
}
i++;
}