See updates in a DataReader

Is there a way to see the updates done by other users in a table using a DataReader ?

For example : in my DataReader, I am on the 10th row. Another user updates the 11th row. When I do myReader.Read(), I am seeing the old values. Is there a way to see the new values ?

  • How to use multiple conditions with AddOrUpdate to determine if the db should add the model or update?
  • Screen/Database query keep on loading/executing unless sql service is restarted
  • Sql select count of sent and received
  • T-SQL How to select rows without duplicate values from one column?
  • How do I select a top level attribute of an xml column in SQL Server 2005?
  • Update a SQL table with values from another nested query
  • Same question with new rows.

  • How do I access SQL Server from Windows 8 apps?
  • SSMS SMO Objects: Get query results
  • Is this UPDATE table statement correct in an msdn topic
  • using ADO.NET to select from multiple VFP tables
  • inserting data from a page to sqlserver database
  • SQL Server Database Update using Multithreading
  • One Solution collect form web for “See updates in a DataReader”

    You might see them with TransIsolation=DirtyReads, but even then it is uncertain.

    The only way to get new data for sure is to re-query

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.