about datasets

Question

hi i had some good question how do we join two datasets from 2 different tables in two different servers into one application can any one give that small piece of code

Vijaya Kadiyala · Answer

Hi I agree with above post Its always good to maintain these kind of relationships at the database level. If you want this i Datasets then check out the below link http://www.functionx.com/vbnet/adonet/relationships.htm Thanks -- Vj http://dotnetjvj.blogspot.com

Niradhip Chakraborty · Answer

You can't do that on single shot. You have two options: 1. Create a linked server in DB invironment then create a SP to take care of it. 2. Get two DataSets for them then merge two datatables into one based on usersID. Hope it gives you some idea. If it is in same server then try this: SELECT a.userID b.usersFirstName b.usersLastName FROM databaseA.dbo.TableA a inner join database B.dbo.TableB b ON a.userID=b.userID