Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C# DB Connection Code Question
Message
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
C# DB Connection Code Question
Miscellaneous
Thread ID:
01311457
Message ID:
01311457
Views:
66
How do I make this routine generic so that I can connect to any type of database?
public SqlConnection GetConnection()
{

    // Define variables
    bool bTrustedConnection = true;
    string sDatabase = "test";
    string sPassword = "";
    string sServer = "PC108\\SQLEXPRESS";
    string sUserName = "";

    // Define variables
    string sConnString = "";

    // If the user is trusted...
    if (bTrustedConnection)
    {
        // Create the connection string for a trusted connection
        sConnString = "Server=" + sServer + ";Database= " + sDatabase + ";Trusted_Connection=yes";
    }
    else
    {
        // Create the connection string for a logged in user
        sConnString = "Server=" + sServer + ";Database= " + sDatabase + ";Uid=" + sUserName + ";Pwd=" + sPassword;
    }

    // Create a connection object, passing the connection string
    SqlConnection oConnection = new SqlConnection(sConnString);

    try
    {
        // Attempt to open the connection
        oConnection.Open();
    }
    catch (Exception oException)
    {
        // Handle exception here
    }

    return oConnection;
}
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform