If there are CursorLocation, CursorType, LockType in VB6, how about in C# ?
anyone can explain the difference and features that replace it ?
thanks before
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
SenthilkumarPosted Apr 14, 2012, 12:37 AM
There will be separate transaction.
Suppose if the read and write happens on the same table then
you can use NOLOCK statement.
SELECT * FROM table_name WITH NOLOCK
antoni richPosted Apr 15, 2012, 11:39 PM
Success for You..
SenthilkumarPosted Apr 14, 2012, 2:28 AM
antoni richPosted Apr 14, 2012, 1:35 AM
Sorry, Beside using NoLock, have another way to safely doing the transaction ?
And how about with insert, update & delete, does need using NoLock statement ?
antoni richPosted Apr 13, 2012, 2:23 AM
But, How we manage the code if some user access (read or transaction) to one table or record in the same time ?
SenthilkumarPosted Apr 13, 2012, 1:53 AM
There are some classes called DataSet and DataReader.
The DataReader is read only, forward only and can't update. It will read row by row from the database.
It does not have the cursor to move front and back.
http://msdn.microsoft.com/library/windows/apps/BR208119
http://msdn.microsoft.com/en-us/library/haa3afyz(v=vs.71).aspx
The DataSet is like memory representation and it can work in offline. It means reads the data in connection and can hold the value in the disconnected architecture.
The Dataset can have many data tables an it can be iterated. It has the option to save, read row by row, delete, compare the two data tables, sorting and relationship.
http://msdn.microsoft.com/en-us/library/system.data.dataset(v=vs.71).aspx
http://www.dotnetperls.com/dataset