stored procedure is pre-compiled sql query. when you execute sp it will again not compile. so it fast and reduce load on database server.create sp in database and use this sp insteaad of sql query in .net. sqlcommand com=new sqlcommand("your sp name"); com.commandtype=commandtype.storedprocedure;my blog: aspmaterials.blogpsot.com