How to work with multiple dataset tables
-
Hi, I wonder if its possible to query the tables in a dataset same as we do with the database tables! I have loaded my dataset with almost 10 tables and now want to extract data from four of those tables to display everything in a datagrid! But i couldn't find a way as how easily it can be done? In other words i was just trying to avoid the SQL JOINS ...:) so i opted for dataset manipulations.. any help in this regard will be appreciated!!! Thanks
-
Hi, I wonder if its possible to query the tables in a dataset same as we do with the database tables! I have loaded my dataset with almost 10 tables and now want to extract data from four of those tables to display everything in a datagrid! But i couldn't find a way as how easily it can be done? In other words i was just trying to avoid the SQL JOINS ...:) so i opted for dataset manipulations.. any help in this regard will be appreciated!!! Thanks
Well, if you wanted to do it the same way as you would from SQL, you'd STILL be using the JOIN's. But since you can't do it using the same SQL syntax, no. What's so hard about learning the JOIN clause anyway? Just learn it and get it overwith. You'll need it in the future and it's much easier than the way you want to do it now, so why wait?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
Well, if you wanted to do it the same way as you would from SQL, you'd STILL be using the JOIN's. But since you can't do it using the same SQL syntax, no. What's so hard about learning the JOIN clause anyway? Just learn it and get it overwith. You'll need it in the future and it's much easier than the way you want to do it now, so why wait?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007Yeah thanks for the good advice and i have already started working with JOINs somehow .. But still are there any ways to filter data from two or more tables of a dataset using some criteria? Also, when i have populated my datagrid with three or more tables how can i update data in all three if some changes occur in datagrid? thanks