angularJS tutorial

https://docs.angularjs.org/tutorial

Datareader vs dataset

https://www.codeproject.com/Articles/420217/DataSet-vs-DataReader

DataReader

DataReader is a stream which is readonly and forward only. It fetches the record from databse and stores in the network buffer and gives whenever requests. DataReader releasese the records as query executes and do not wait for the entire query to execute. Therefore it is very fast as compare to the dataset. It releases only when read method is called.

DataSet is a collection of in memory tables and datareader provides the ability to expose the data from database.

Both are very widely used in asp.net applications to get/fetch the data from the database. But for a scalable, fast, and reliable application one has to know the best practices in developing application.

DataSet

We should use when the application is:

• Windows application
• Not too large data
• Returning multiple tables
• If, to be serialized
• Disconnected architecture
• To return from a WCF  service
• To send across layers
• Caching the data
• Do not need to open or close connection

Pdanet connection to Internet from laptop

You have to kill adb.exe

Run as administrator  d:\util\procexp.exe

http://www.junefabrics.com