When will you go for DataReader and when for DataAdapter ?

You can go for DataReader when you want to only display the data.
You can go for DataAdapte when you want to display ,edit and update the data.

www.codecollege.NET