Interested to Buy Any Domain ? << Click Here >> for more details...
How do u implement locking concept for dataset?
- 2 Answers
- 10675 Views
- ABC, I also Faced
- E-Mail Answers
Answer Posted / ananthi.r
When we update , the DataSet helps out with the process,
because it keeps track of multiple versions of rows that
have been updated. You can use parameters to set the
CommandText property of DataAdapter's UpdateCommand. The
SqlParameter class contains a property, called RowVersion,
that informs the DataSet which version of the value to make
use of. The DataAdapter judges whether the update worked by
considering whether the UPDATE statement have an effect on
zero or a non-zero number of rows. If someone else has
changed design (or deleted the row), the UPDATE returns "0
rows affected." If no one else touched the row (that is,
your optimism was justified), you receive "1 row affected."
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is ado control?
What are the data access namespaces in .NET?
Which is the feature of ado.net?
What is the use of sqldatareader class?
What is isolation?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What are the different execute methods of Ado.Net?
What is difference between ado and other data object?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
How to create dynamic gridview?
What do you mean by performing asynchronous operation using command object?
What are the 3 major types of connection objects in ado.net?
What is the role of data provider in ado.net?
Command objects uses, purposes and their methods.
What is an orm, and why would you use one instead of plain old ado.net?
