Gridview in website- Accessdatasource => Cannot use query builder, get error message shown
Posted on 2008-11-10
On my webpage I can drag a gridview object onto the page, and I have to also pull down an AccessDataSource which will bind the gridview to my Access Database assigning the query string and the query and other perameters.
The problem is
(1) If I try to 'configure data source' I cannot browse for my database, all that is shown is the folders within the project (App_Code, App_Data and Bin), which is strange, because I think I remember being able to Browse previously. So, I have to type in the folder and drive by hand. (Although I just read someone else mentioning this somewhere and said that they don't think the browse feature is fully implemented...)
(2) So, that seems ok, but then when I choose 'next' I get to the place where I have to define the query. So, I try to click on the 'query builder' button to bring up the query builder, and I get the error message 'Object reference not set to an instance of the object'.
So, something strange is going on. While the page will run fine, and gas long as the queries are correct the tables will be updated properly, I can't use visual studio functions properly since it doesn't seem to be finding the database? Not sure what is going on here... any help?