如何使用C＃以小步骤从Sql Server长查询中检索数据

I want to get data from a long query like Sql Server Management Studio does. I mean, it displays small amounts of data as soon as is received from the server (in this case, SQL Server 2008).I want to get data from a long query like Sql S