Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain the architecture of ado.net?

1061


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

2137


What do you know about ADO.NET's objects and methods?

969


Do you use stored procedure in ado.net?

1022


Explain what are acid properties?

978


What is the use of adodc?

988


What is sql command in ado net?

954


Describe datareader object of ado.net with example.

927


Do we use stored procedure in ADO.Net?

987


What two types of data providers does ADO.NET supply? What determines which one you should use?

987


Why edit is not possible in repeater?

943


Explain the advantages and disadvantages of using datalist?

1070


How to copy the contents from one table to another table and how to delete the source table in ado.net?

1033


What is the use of connection object in ado.net?

1053


What is data relation in ado.net?

1066