I assume you mean SqlDataAdapter vs "SQLQueryAnalyzer" in the last part of
your post.
I am not aware of any specific locking mechanism in using the Update method
of a SQLDataAdapter. If you are concerned about concurrency issues, one
solution is to use a timestamp (in SQL Server, "rowversion") column and
include this in the WHERE clause of your insert or update query / stored
proc. Then you can examine the RowErrors and other properties after the
update to see which rows were not inserted / updated.
Hope that helps.
Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
"archana" wrote:
hi all
I have some doubts related to database handling in .net.
I am using sqldataadapter to update and insert rows into database.
What i want to know is at a time of inserting rows using
sqlqueryanalyser, is their any locking system used internally.
if yes what it is.
any help will be truely appreciated.
thanks in advance.