Dinuraj wrote: waiting for prompt reply Please don't put things like this into a question. The people on this site give their help freely, and in their own time. If somebody can answer you, they will. Anyway, you would use a T-SQL transaction when you can accomplish everything inside the same top level stored procedure. ADO.NET transactions allow you to wrap multiple stored procedures into the same logical transaction. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before.

Check your sqlDataSource object... first make sure the connection string you are using supports update operation. Second, when you get to the screen where it asks you to type in the SQL statements, click on the Advanced button, then check "Generate Insert, Update, and Delete statements" box. You may also check the "Optimistic concurrency" box as well. If the above doesn't help you, Zip your project, and email it to me so I can take a look at it :-) NightHawk13@hotmail.com Nila I do ANYTHING for a jumbo cup of coffee!