How to use Data Sets?

u write a stored procedure n call it use ur name:

Select * from table1 as tb1 inner join table2 as tb2 on tb1.id=tb2.tb1id

it will then return you all the data from both tables based on the conditon is this what you were after?

Dear Friend,

Thanks for you reply and I created the query below and it is working properly. So how do you define a stored procedure with this and call that procedure in C# 2005?

Select * from CM_CUSTHED as T1 inner join CM_CUSTDET as T2
on T1.cust_code = T2.cust_code

--Thanks ! --

Dinusha Gamage18y ago

yes, Thank you.

Grant Spiteri18y ago

Call a stored procedure that does the following for example:

Select * from table1 as tb1 inner join table2 as tb2 on tb1.id=tb2.tb1id

it will then return you all the data from both tables based on the conditon is this what you were after?