title: How can the data in the DataGrid be populated asynchronously in a streaming fashion?
body: <p>In a Windows C# application form I load more than 500,000 records from a SQL Server database for analysis.</p>
  
  <pre><code>SELECT TOP 500000 * FROM MobileTrans
  </code></pre>
  
  <p>When I run above query in SQL Server Management Studio data shows up immediately and takes 15 sec to load be completed. But when I run this query in my Windows application, it takes 15 sec without showing anything in the data grid, after that data show in data grid suddenly.</p>
  
  <p>How can I retrieve results of query async same as SQL Server Management Studio in my windows data grid form?</p>
  
  <p>Please send a small sample of code.</p>