Merge dataset into query call in dataadapter????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everybody -

This may seem like an easy question to the .NET gurus out there but it has me very much stumped on how to accomplish. I have a dataset that I have merged together from separate queries. What I want is to include it in my final query so I can include other fields but I'm trying to do a join on certain fields in this dataset I've generated. How can I accomplish this?

So for example, I'd like to do something like this:

Select FirstName, dsQueryC.InitDate
From Employee INNER JOIN dsQueryC etc...... (Being able to reference the dataset within the query of a data adapter)

I'm completely lost on how to do this in ADO.Net

Any thoughts are appreciated,

Ben
 
Hi Ben,

Why don't you do JOIN in select statament = in database?
If you want to manipulate data inside DataSet you'll have to do it manually.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

Ben said:
Hi everybody -

This may seem like an easy question to the .NET gurus out there but it has
Click to expand...
me very much stumped on how to accomplish. I have a dataset that I have
merged together from separate queries. What I want is to include it in my
final query so I can include other fields but I'm trying to do a join on
certain fields in this dataset I've generated. How can I accomplish this?
So for example, I'd like to do something like this:

Select FirstName, dsQueryC.InitDate
From Employee INNER JOIN dsQueryC etc...... (Being able to reference the
Click to expand...
dataset within the query of a data adapter)
 
Miha -

I'm not too familiar with using "JOIN in select statement = in database". Is there an example somewhere that I can use as a guide or a template that you may use frequently

Thanks for responding

Be
----- Miha Markic wrote: ----

Hi Ben

Why don't you do JOIN in select statament = in database
If you want to manipulate data inside DataSet you'll have to do it manually

--
Miha Markic - RightHand .NET consulting & developmen
miha at rthand co

Ben said:
Hi everybody
Click to expand...
me very much stumped on how to accomplish. I have a dataset that I hav
merged together from separate queries. What I want is to include it in m
final query so I can include other fields but I'm trying to do a join o
certain fields in this dataset I've generated. How can I accomplish this
From Employee INNER JOIN dsQueryC etc...... (Being able to reference th
Click to expand...
dataset within the query of a data adapter
 
If you look at northwind db, you could do something like
SELECT Products.*, Category.Description FROM Products INNER JOIN Categories
ON Products.CategoryId = Categories.CategoryId

HTH,

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

Ben said:
Miha -

I'm not too familiar with using "JOIN in select statement = in database".
Click to expand...
Is there an example somewhere that I can use as a guide or a template that
you may use frequently.
 
Miha -

Since I'm wanting to try to include my dataset with tables from a database, can that still be accomplished within a Select statement like:

Select FirstName, dsQueryC.InitDate
From Employee INNER JOIN dsQueryC

Where "dsQueryC" would be interpreted properly when I set my connection to the db or do I need to set up a data relation to tie in the dataset, etc.?

Thanks again for your thoughts. Due to a bad setup that was created that I'm trying to mirror in a more organized way, I'm limited with my options.

Ben
----- Miha Markic wrote: -----

If you look at northwind db, you could do something like
SELECT Products.*, Category.Description FROM Products INNER JOIN Categories
ON Products.CategoryId = Categories.CategoryId

HTH,

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

Is there an example somewhere that I can use as a guide or a template that
you may use frequently.
 
Back
Top