SQL Queries and Stored Procedures
Posted on 2006-05-04
I would like to use the datareader and the sqlconnection to access records in my db. I am brand new to .net and have an application to convert.
What is the most efficient data access method??
Could someone give me an example of a complete SUB where a connection is made and then a dataset/ datareader is populated from a stored proc with parameters.
Sorry I don't have my code in front of me.
What is the deal with tableadapters? Are they efficient? I am using a direct connection to the DB by the way.