We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

One to many relationship, how to display/select

Given the following example what would be the best way to handle the given data in a single databound grid. There are two main entities: users and hobbies. I would like a grid listing all users with some column in the grid displaying any hobby the user is interested in, where the user can select multiple entries. There are three data tables involved, a user, hobby and user_hobby_map table. I was thinking some type of drop down grid or grid list with multi-select. But I can't seem to find the right combination. Any suggestions or hints as the best way to handle this using your grid control? Is there already a sample out there showing something like this that I could look at?

1 Reply

AD Administrator Syncfusion Team January 2, 2003 03:37 PM

Hi Chuck, take a look at message http://www.syncfusion.com/forums/message.asp?MessageID=1313. Kai Iske has a multi-select combobox that you could use. If, on the other side, you prefer to show each hobby in its own row and you want the table be grouped by user you should check out the DataBound\Hierarchical\ExpandGrid sample project. Stefan

Live Chat Icon For mobile
Up arrow icon