Help regarding sqldataadapter.

[trialproduct2004]

hi all

i am having problem at a time of using sqldataadapter.

My adapter is using two tables into which i want to add records.

I am using two dataset for updating these table.

My problem is even if i added records into two different tables it is
adding same record twice in one table only and not in second table.

Can someone tell me why this is happening.

Any help will be truely apprecated.

thanks in advance.

[Rainier [MCT]]

Hi,

It's a bit hard to answer without seeing the code.
But normally you use a dataadapter for a single table.
one select, one update one insert and one delete command all hooked to one
data adapter.

So my advice make another data adapter for the second table in your dataset.

Regards,
--
Rainier van Slingerlandt
(Freelance trainer/consultant/developer)
www.slingerlandt.com
"tr**************@yahoo.com" wrote:

hi all

i am having problem at a time of using sqldataadapter.

My adapter is using two tables into which i want to add records.

I am using two dataset for updating these table.

My problem is even if i added records into two different tables it is
adding same record twice in one table only and not in second table.

Can someone tell me why this is happening.

Any help will be truely apprecated.

thanks in advance.