ASP.NET Tips: Working with large SQL tables 
(Tom) There are a number of ways to query for data that is stored in a SQL Database from ASP.NET. Generally the best way is to use stored procedures. They can be compiled to be faster, and they are also much safer as they protect you from SQL injection problems, as discussed here. For an example of using stored procedures, check out: HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual C# .NET.
Read More >>
