Thanks for the reply I Hope my boss will understand this.

Thanks Colin, I have written an application just as proof of concept and it works fine. But, my boss think its not safe to do like this and he refering to Online Book Which say :- ---------------------- Specifying Transaction Boundaries You can identify when SQL Server transactions start and end with Transact-SQL statements or API functions and methods. Transact-SQL statements Use the BEGIN TRANSACTION, COMMIT TRANSACTION, COMMIT WORK, ROLLBACK TRANSACTION, ROLLBACK WORK, and SET IMPLICIT_TRANSACTIONS statements to delineate transactions. These are primarily used in DB-Library applications and in Transact-SQL scripts, such as the scripts that are run using the osql command prompt utility. API functions and methods Database APIs such as ODBC, OLE DB, and ADO contain functions or methods used to delineate transactions. These are the primary mechanisms used to control transactions in a SQL Server application. Each transaction must be managed by only one of these methods. Using both methods on the same transaction can lead to undefined results. For example, you should not start a transaction using the ODBC API functions, and then use the Transact-SQL COMMIT statement to complete the transaction. This would not notify the SQL Server ODBC driver that the transaction was committed. In this case, use the ODBC SQLEndTran function to end the transaction.-------------- As per this document I am not suppose to mix transaction between ADO.NET and T-SQL. And I am not mixing transactions instead, I am nesting it. Is there is any published article or document online which can help me explaning to my BOSS? Thanks Sanjeev

No, I can't combine all the SP, some times same SP is called multiple times depending on Data. Its all dynamic based on data which comes from client application

I am writing an application that calls numbers of stored procedure wrapped in an ADO.NET transaction. Some of the stored procedure implements T-SQL transactions. Is it safe to call Stored Procedure like this or there is potential of data corruption. Have anyone seen any document or article that explain how this works. Sample code using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlTransaction theTran = conn.BeginTransaction(); try { // create command object // set Command Parameters // Set Command Parameters values // EXECUTE Stored Procedure 1 // create command object // set Command Parameters // Set Command Parameters values // EXECUTE Stored Procedure 2 .... theTran.Commit(); } catch { theTran.Rollback(); } conn.Close(); } Stored Procedure Create Procedure InsABC @NAME varchar(50), @Address varchar(100) as BEGIN BEGIN TRANSACTION .... -- Do INSERT ... .... -- In case of error rollback ... COMMIT TRANSACTION END

Can some tell me where should I look to find differences between .NET 1.0 and .NET 1.1 ? Thanks Sanjeev

Hi, I am trying create deployment package for my windows service application written in C#. I am able to install my windows service using InstallUtil.exe but when i try to install using deployment project, it installs successfully but does not show up in Service manager list. Can anyone knows what I am missing. Sanjeev

Then, why it works with windows application? How to check ServicePoint.ConnectionLimit in ASP Application ? Thanks sanjeev

I have problem with calling websevice method Asyncronously using WebService behavior. I can not make more than two request simultaneously to webservice. If I call webservice method 3rd time, it won't event go to web service until response of 1st or 2nd is received. But if I use the same web service in a windows application using Proxy. I can invoke web service method any number of times Asyncronously without waiting for response for the pervious calls. Does anyone know why its behaving like this? Is there any way to solve this problem? Thanks in advance. Sanjeev

I have problem with calling websevice method Asyncronously using WebService behavior. I can not make more than two request simultaneously to webservice. If I call webservice method 3rd time, it won't event go to web service until response of 1st or 2nd is received. But if I use the same web service in a windows application using Proxy. I can invoke web service method any number of times Asyncronously without waiting for response for the pervious calls. Does anyone know why its behaving like this?:mad: Is there any way to solve this problem? Thanks in advance. Sanjeev

I read that article but I don't want to use ActiveX control...:confused:

Can any one help in finding tutorial/sample for Serial Port Communication (COM)in C#. thanks, Sanjeev

Like it or not, u'r right. ;) Thanks for the answer ! I guess it should solve my problem..

>Depending on the server configuration, error messages can be changed so it >is possible from that end to change the 404 error page. what if server is not responding??? NavigateComplete2 method is called after the document is loaded (and displayed). I don't want the "error page" to be displayed at all.

I am using WebBrowser control in VC++ project. WebBrowser loads page form Intranet Server. I don't want to show message like "The page cannot be displayed" in case server is down. I want to show some local html page which will be stored on client computer. Does anyone know how to catch event when page is not successfully loaded from server? Thanks Sanjeev.

I am using WebBrowser control in VC++ project. WebBrowser loads page form Intranet Server. I don't want to show message like "The page cannot be displayed" in case server is down. I want to show some local html page which will be stored on client computer. Does anyone know how to catch event when page is not successfully loaded from server? Thanks Sanjeev.

Its intranet application using IE 5.5 Thanks for the help. -Sanjeev

I am using Remote Scripting but I encounter a problem in passing large amount of data. Remote Scripting will not pass more than 2083 character from Client page to ASP page. This article (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274852)describe the problem in detail. Does anybody know how to solve the problem ? What are the alternative technologies to Remote Scripting to pass large data? thanks, Sanjeev.