How do u implement locking concept for dataset?
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
Explain the architecture of ado.net?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What do you know about ADO.NET's objects and methods?
Do you use stored procedure in ado.net?
Explain what are acid properties?
What is the use of adodc?
What is sql command in ado net?
Describe datareader object of ado.net with example.
Do we use stored procedure in ADO.Net?
What two types of data providers does ADO.NET supply? What determines which one you should use?
Why edit is not possible in repeater?
Explain the advantages and disadvantages of using datalist?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the use of connection object in ado.net?
What is data relation in ado.net?