Question related to dataset

[RJN]

Hi

Need a help on data set.
I have a .csv file as an input which I read using the oledb provider and
upload into a dataset using a dataadapter. So the dataset has one
datatable now. Using this datatable as the basis, I need to get the
other related information from SQL server database.

The exact scenario is like this. Suppose instead of creating a datatable
if I create a temp table in SQL server, then I can join this temp table
with other tables and get a consolidated result set..
like select * from temp inner join table B on temp.col1=B.col1 inner
join table C on temp.col2 = C.col2 and so on.

I do not want to create a temp table. But I would like to simulate the
same scenario as above using data table.
Can somebody help me out please.

Regards

RJN

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Cor]

Hi RJN,

I think you need this?

http://msdn.microsoft.com/library/de...chematopic.asp

Without the exact schema it is a hard way to reach what you want I think.
Cor