What would cause a difference between datagrid and SQL data? RRS feed

  • Question




    Working in 2005.  I have a SP that works fine in SQL, and in solution explorer in VS 2005.  But when I preview my data in my table adapter, my results are diffrent, and always less.  Any ideas?





    Monday, October 29, 2007 9:28 PM

All replies

  • One more thing I noticed. When I preview data from server explorer in VS 2005, and delete the <default> or <null>, I only get 4 results. If I put either one of those values in, I get my entire table back.



    Monday, October 29, 2007 9:43 PM
  • More to the puzzle.  I figured out what the problem was.  I had a NULL value in one of my columns. The thing is that my data polulated the data grid just fine with the NULL values in that column.  But now I have to put a value in there for it to show up in my datagrid.  I'm not sure what I would have changed to make this happen. Any Thoughts?




    Tuesday, October 30, 2007 1:53 PM