|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DataRelations and gridsable to solve! Assume I have two simple tables Car, and Store, looking like this: Car ------- car_id make Store ------- car_id numberofcars and I want to show, and update the data in the Store table. I can easily use a grid and a datasource that binds to the Store table alone, but then I have to stick with the not-meaningful car_id showing a bunch of numbers instead of meaningful names that are stored in the Car table. In the database, I have added foreing key constaints, and when I add the two tables to a datasource using VS 2005's wizard it nicely observes the FK constraint and creates the corresponding DataRelation. However, I have still not found a way to show a grid with the columns: make | numberofcars. I am aware that I can show this easy if I create a database View and bind that to the grid. However, that makes it impossible for me to do (automatically at least) Updates to the table. Any ideas? It should be very easy to accomplish this. I appreciate ANY kind of help a lot, thanks!! Claus  |
|||||||||||||||||||||||
Other interesting topics