How to create a connection to SqlServer

Edward Aymami

2y1.4kADO.NET

I am Trying to teach myself C#. I'm struggling with getting a connection to SQL server. I have a static class, GetSQLConnectionString that returns a connection string.

When I try to call in in my forms class I get the following:

private void button1_Click(object sender, EventArgs e)
{
string conn = GetSQLConnectionString; (Error displayed here
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs2y ago
What is the error? It helps to also show the error message.

I do not see () after GetSQLConnectionString. You can see in the other reply that you need to use GetSQLConnectionString(), not GetSQLConnectionString.

Muhammad Imran Ansari2y ago

To achieve this define a static method in the static class like.

static string GetSQLConnectionString()
{
    // This might involve reading from a configuration file, etc.
    // Replace the return statement with your actual logic.
    return "your_connection_string";
}

Now call the connection string method in where you need.

static void Main()
{
    // Get the connection string
    string connectionString = GetSQLConnectionString();

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
         // You code here
    }
}