Interested to Buy Any Domain ? << Click Here >> for more details...
How do u implement locking concept for dataset?
- 2 Answers
- 10649 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
Is bulk insert faster than insert?
What are the different methods available under the sqlcommand class to access the data?
Explain the architecture of ado.net?
How do you implement locking concept for dataset?
What is the use of ADO.NET and XML web services?
Explian About DataAdapters
How can we load multiple tables in to dataset?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What is a column variable?
Define ado.net?
Which object of ado contains datarow datacolumn collection?
What is a dataview?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is namespace in ado.net?
What is a non query?
