Best Method to get data from SQL

Question

Hi all,

Does anyone have some solid info on what is the best/fastest method to take when querying a database and writing back to it? What I mean with this is, for performance wise. 

If anyone has any info, please tell me why you would say that. Currently I am using the SQLClient, butt still I would like to know if there is no catch22 that I should know about that might increase the turnaround time for the reading and writing to the DB.

Thanks,
SG

Answer 1

Also look at the articles in this web site that explains how to diagnose and debug errors occuring in web sites.

Answer 2

show us the code please...