TableAdapters and Transactions again!

#11

You should use transaction..
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"rekha anand" wrote in message news:20075220227rekhaba (AT) hotmail (DOT) com...

Quote:

Hi Andrew,
I tried your solution as you suggested. My second adapter is failing and
my first adapter is still getting updated in the database and not getting
rolled back. For example, I have one header row and 3 details row. When
the 3rd row of the detail is failing it is not rolling back the entire
transaction. Instead a row is added in the header table and 2 rows are
added in the detail table.

Please advise as how to overcome this issue.

I am using XSD generated strong type dataset and multi table adapter.I
modified the code with partial classes as you suggested.

Please let me know if you need any additional information.

Thanks,
Rekha

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

#12

Hi,

I have tried your solution on my project. There are four tables in sql server 2005 express, that form a tree (table1 has foreign key to table2, table2 to table3, and table3 to table4)

Firstly, I insert into table4, then table3, table2 and last table1. But when inserting into table1, trouble arise as it stated time out

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

When I change the sql table relation (enforce foreign key constraint to "no") for the last table(table1). it works alright, but it's not what I want to ( it didn't check the integrity)

Please advise
Thanks, appriciate all reply

Sincerely,

Moniq

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

#13

Hi,

I have tried your solution on my project. There are four tables in sql server 2005 express, that form a tree (table1 has foreign key to table2, table2 to table3, and table3 to table4)

Firstly, I insert into table4, then table3, table2 and last table1. But when inserting into table1, trouble arise as it stated time out

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

When I change the sql table relation (enforce foreign key constraint to "no") for the last table(table1). it works alright, but it's not what I want to ( it didn't check the integrity)

Please advise
Thanks, appriciate all reply

Sincerely,

Moniq

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

#14

Hi,

I have tried your solution on my project. There are four tables in sql server 2005 express, that form a tree (table1 has foreign key to table2, table2 to table3, and table3 to table4)

Firstly, I insert into table4, then table3, table2 and last table1. But when inserting into table1, trouble arise as it stated time out

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

When I change the sql table relation (enforce foreign key constraint to "no") for the last table(table1). it works alright, but it's not what I want to ( it didn't check the integrity)

Please advise
Thanks, appreciate all reply

Sincerely,

Moniq

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

TableAdapters and Transactions again!

Dotnet Framework (ADO.net) microsoft.public.dotnet.framework.adonet

Re: multi table adapter - 05-22-2007 , 04:02 AM

sql transaction with table adapter - 11-27-2007 , 01:59 AM

sql transaction with table adapter - 11-27-2007 , 02:02 AM

sql transaction with table adapter - 11-27-2007 , 02:34 AM