Thanks Very Much Sreeram, 1>I have another questions related to your answer, datasets are disconnected technology. Cant i take that facility here. Why do i need to close the connection explicitly, .net does that for me. Can u clarify this for me please 2>U said SQL server maintains the connection pool. I think my IIS server mantains the connection pool for me. Is i am wrong? See i am developing an application which follows client server architecture, which can be called over browser , this i am doing using .net 2003 's NO TOCU DEPLOYMENT technology. TO this i need browser, IIS server and SQL server 2000. Can u tell me where the connection pool actually works. 3>How does i maintain data concurrency in my application. Is IIS maintains that for me or i need to do that using my connection object's begin transaction method. Thank u very much for your reply and awaiting answer on this from you.. Thanks in advance | 
