I am a new member in this section. When i try to connect to a sql server 2008 database from a Visula Studio ASP.net project, it will take much more time to execute the program. But the connection from Management Studio is very fast. Please help me.
Welcome to the forms. As usual the first connection from another connection (asp.net page) will be slow to build up a connecton pool for your connection. So for the next it should be fast enough to get the details easily, refer to http://www.datadirect.com/developer/net/dot-net-connection-pooling/index.ssp & http://articles.techrepublic.com.com/5100-3513-6107854.html for more information.
