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
how we can fire event in databound coulm in datagfrid withot using button?
Explain the different row versions available in table?
What is ado oledb and odbc?
Why is ADO.NET serialization slower than ADO ?
Which object is used to add relationship between two Datatables?
What is a column variable?
Some important instruction regarding ADO.NET connection string ?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
What is the namespaces being used to access oracle database?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Explain the difference in record set and dataset?
What are all the different authentication techniques used to connect to MS SQL Server?
What is an ado connection?
If we are not returning any records from the database, which method is to be used?
What is commandbuilder in ado.net?