Question related to dataset

  • Thread starter Thread starter RJN
  • Start date Start date
R

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
 
Back
Top