7-table join query with SqlDataAdapter??

[1067guy]

Can I use a SqlDataAdapter to populate a datagridview with data joined from 7 different tables? The data must be editable, so I can't create it as a view. Perhaps using the ObjectDataSource is a better plan? Can you do that -- use WebControls in a Windows application? Maybe it all has to be done manually? What good, then, is ADO.NET?!

 

[craigv]

I think you can. See this article and look for "Step 5: Completing the Data Access Layer"

http://msdn2.microsoft.com/en-us/library/aa581776.aspx

HTH

 

[1067guy]

Multiple table join query

Thanks, craigv. It looks like a step in the right direction.

 

[cjard]

Can I use a SqlDataAdapter to populate a datagridview with data joined from 7 different tables? The data must be editable, so I can't create it as a view. Perhaps using the ObjectDataSource is a better plan? Can you do that -- use WebControls in a Windows application? Maybe it all has to be done manually? What good, then, is ADO.NET?!

I'd use a stored procedure for the I/U/D at least.. by all means do a normal query for the selection, but that many tables are going to be a nightmare to create an editable view of

I fail to see how ObjectDataSource is advantageous, or that it can do something that is not available in WIndows forms apps.

It doesnt have to be done manually, but you can choose how hard-for-yourself to make it

If you think ADO.NET is something that can magically help you solve multiple joined table edits, then youve made a wrong assumption about it.. Such a task will always be a problem, it matters not what technology is transferring data out of the database