ListObject does not show all row from SQL-query RRS feed

  • Question

  • Here is the situation....
    VSTO-project contain SQL-query.
    And visual control List Object gets data from this query.
    In the query preview i see all results of it,
    but in the visual control there is just 24 rows.
    I tried to use just SQL-query in the program, than i tried to use Store Procedure from SQL-server - but the same result.
    I can not understand why is that, where is the problem...
    Also I tried to recreate the project - but te same.
    Thursday, October 30, 2014 9:08 AM

All replies

  • Hi Angela,

    Thanks for posting in MSDN forum.

    I suggest that you to check the whether the datasource in SQL server is as you expected. Also you can create a windows form application to see whether the data query from SQL server is correct.

    If everythings is ok, please post the sample code you are using to help us to reproduce this issue.

    Regards & Fei

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, October 31, 2014 6:37 AM