Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding the PK of the main table in a multitable view
Message
 
To
22/12/2007 14:21:51
John Thomason
King Richard Veterinary Centre
Leicester, United Kingdom
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01276165
Message ID:
01278765
Views:
37
John,

>The only DataGridView on the form has its datasource set to the view. The bindingsource can't be set because I can only choose a single table and this would override the display of the view.

I think this is the crux of the matter. Even though you are using a view to retrieve data, ultimately, it is returned into a single DataTable within the associated DataSet, and you *can* bind to this DataTable.

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform