SQL Server Performance

How to handle Database Connection to SQL Server?

Discussion in 'Getting Started' started by pcsql, Jun 22, 2007.

  1. pcsql New Member

    I'm new to .net and need to know how to handle database connection to SQL Server 2000/2005 so an application can be deployed to clients.

    Thanks.
  2. MohammedU New Member

  3. satya Moderator

    http://www.dotnetspider.com/tutorials/
    http://www.sql-server-vb-asp.net/

    ..also take you through the tutorials.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  4. Madhivanan Moderator

    Also referhttp://connectionstrings.com/

    Madhivanan

    Failing to plan is Planning to fail
  5. pcsql New Member

    Hi,

    I think my question is not specific enough. I'm looking for different .NET 2.0 techniques (also .NET 3.0 if differnt) in both storing connection string and building connection string in runtime. I think the most common way in storing connection string is in app.exec.config. But I want to know other alternatives and their pros and cons.
  6. Madhivanan Moderator

    I think you need to post in .NET forums

    Madhivanan

    Failing to plan is Planning to fail
  7. satya Moderator

    True, may refer to the MSDN related forums.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page