471,315 Members | 2,193 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,315 software developers and data experts.

question related to sqldataadapter.

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.

Nov 30 '05 #1
1 1145
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.

Nov 30 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Martin Schmid | last post: by
7 posts views Thread by Jason Huang | last post: by
reply views Thread by Ed Allan | last post: by
4 posts views Thread by Patrick.O.Ige | last post: by
6 posts views Thread by mrmagoo | last post: by
1 post views Thread by kempshall | last post: by
reply views Thread by stephen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.