I've built a web application in ASP .NET 3.5 [C#]. I've written a query pull all of the records from a table. Its not doing it and for the life of me I don't know why. The query is straight forward and pulls back all the records when I'm in SQL studio. I may have just noticed the problem but it doesn't seem as if it were doing this all along. The data that its not pulling back is in the table so I don't understand why its not pulling back all of the data. Any thoughts?