Client Server in C#

Question

If there are CursorLocation, CursorType, LockType in VB6, how about in C# ? anyone can explain the difference and features that replace it ? thanks before

Senthilkumar · Answer

Hi Antoni, 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 rich · Answer

Yummy... Thanks very very much Mr. Senthilkumar Success for You..

Senthilkumar · Answer

Hi Antoni, If you want to run your query in safety manner then sql transaction gives you guarntee to run all or none. It has the ACID. You can use the transactions in the sql server and ADO.Net as well.

antoni rich · Answer

Thanks again Sir..., 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 rich · Answer

Thanks very much Mr. Senthilkumar, Success for You.. But, How we manage the code if some user access (read or transaction) to one table or record in the same time ?

Senthilkumar · Answer

Hi Antoni, 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

Client Server in C#

Answers (6)