调用SQL连接方法在C＃ [英] Calling an SQL Connection method in C#

问题描述

我将此方法调用到我的登录表单。我不知道这是什么错了。我创建了一个名为MyConnection的类，这个类包含我的SQL ConnectionString。我想要的是我可以调用这个函数ex。 Class1方法名为Myfunction将被调用到我的登录表单，因此调用连接字符串将更快。

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;    
    }    
}

推荐答案

不能实例化静态类。您可以这样调用：

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

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

这篇关于调用SQL连接方法在C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！