Interested to Buy Any Domain ? << Click Here >> for more details...
How do u implement locking concept for dataset?
- 2 Answers
- 10919 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 are the benefits of using ado.net?
What is ole db query?
What are the steps to connect to a database?
What is ado.net in mvc?
What does executequery return?
What is ado control?
Define Execute Reader?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
Explain the different row versions available in table?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
Describe the command object and its method.
What is the purpose of using adodb?
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What is the meaning of executenonquery?
How can we load multiple tables in a dataset?
