Transaction+TableAdapters

Hi,

I have problem vith implementing Transaction with TableAdapters. My code is:

try

{

using (bookTableAdapter adapter = new bookTableAdapter())

{

transaction = TableAdapterHelper.BeginTransaction(adapter);

ID=(Guid) adapter.bookInsertNew(bookOrgId, bookISBN, bookName, Convert.ToInt32(bookYear), publisherId, languageId, orgLanguageId, bookTranslation, Convert.ToInt32(bookColors), Convert.ToInt32(bookPages), bookFormat, Convert.ToDouble(bookWidth), Convert.ToDouble(bookHeight), Convert.ToDouble(bookWeight), Convert.ToDouble(bookThickness), Convert.ToInt32(bookPrize), bookResumeText, bookResumeHtml, bookPicture_s, bookPicture_m, bookPicture_l, Convert.ToInt32(bookStatusId));

 

}

using (bookAuthorTableAdapter adapter1 = new bookAuthorTableAdapter())

{

TableAdapterHelper.SetTransaction(Adapter1, transaction);

 

for (int i = 0; i <= leng1; i++)

{

adapter1.Insert(author[i],ID,1);

 

}

}

transaction.Commit();

}

catch

{

transaction.Rollback();

throw;

}finally

{

transaction.Dispose();

}

First Insert is ok, but trow exception on second try to insert in database.

Exceprion is :
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.

Source Error:





Line 1839: }
Line 1840: try {
Line 1841: int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
Line 1842: return returnValue;
Line 1843: }

 I also set Connect Timeout=200 in Web.config but nothing change :(

Please help :( :( :(