Calling an SQL Connection method in C#

Question

I am calling this method to my Login Form. I don't know what is wrong with this. I've created a class named MyConnection and this class contains my SQL ConnectionString. What i want is I can call this function ex. Class1 method named Myfunction would be called to my Login Form so calling a connection string would be faster.

public static class MyConnection
{
    public static SqlConnection getConnection()
    {                
        string conn = "Data Source=EDGAR-PC\\SQLEXPRESS;Initial Catalog=Project1;Integrated Security=True";
        SqlConnection myConn = new SqlConnection(conn);
        return myConn;    
    }    
}

I am really struggling to understand what your actual question is. Can you clarify? — Daniel Kelley
– Daniel Kelley, Commented Apr 3, 2013 at 16:46
What I want to do is call this instantiate this class to my Login form and call this method(getConnection) on that Form. so creating a connection to SQL Server would be faster. — eaponz
– eaponz, Commented Apr 3, 2013 at 16:50
Did you examine the object to see what is being returned? Also, are you opening the connection in your calling method? — Mark Kram
– Mark Kram, Commented Apr 3, 2013 at 16:56
@Daniel Kelley, it's really hard to understand, but he tries to call that function, not knowing how to instantiate a static class =). Pay attention to the "What i want is I can call this function..." Not everybody of us are guru. — Sasha
– Sasha, Commented Apr 3, 2013 at 17:07

Sasha · Accepted Answer · 2013-04-03 17:09:09Z

5

You can't instantiate the static class. You can call it like this:

using (var connection = MyConnection.getConnection())
{
    connection.Open();
    //do whatever you need
}

edited Apr 3, 2013 at 17:09

answered Apr 3, 2013 at 16:59

Sasha

8,8804 gold badges55 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Apoorva Sharma · Accepted Answer · 2017-05-10 05:11:38Z

0

Since the static class cannot be instantiated, you will have to call like this:

private static void OpenSqlConnection(string connectionString)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
        }
    }

answered May 10, 2017 at 5:11

Apoorva Sharma

53 bronze badges

Collectives™ on Stack Overflow

Calling an SQL Connection method in C#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related