I am working on a project that is supposed to communicate with an SQL Server 2012 database. Currently, I've got a dataset of all the tables in the database, and I am trying to come up with a way to perform a complex query with several joins in this application.
Thus far, I can create a dataset with the information from 1 of my tables, but I cannot join or do subqueries or otherwise change the data received. How do I utilize my dataset so I can create joins of data from several tables? This is my first time interacting with an online database with a C# program, so I'm a little lost as to how to make this work. Any help anyone can give will be appreciated.
Joginder BangerPosted Feb 25, 2015, 10:37 PM
Adam,
I understand your problem, suppose in your database have around Ten tables you wants pick all table and join perform on front end means in .cs file. This is a wrong way Adam because first lots of times take a dataset for hold the Database table. After then you need a loop to get a table one by one and your coding parts will be very complex. I advice you drop this idea and join, select and DML query all perform database end.
Thanks
*jsb