调用公共类

Question

这里的时候，收到错误的错误：

An object reference is required for a non-static field, method, or property 'ArchiCapture.Models.dbConnection.runSproc(string[], string[], string)'

它出现在呼叫DT = dbConnection.runSproc（PARAMNAME，paramValue， “pr_select_employee_by_id”）;

我正在尝试开发一个名为SPROCs的类。这是我的班。

namespace ArchiCapture.Models 
{ 
    public class dbConnection 
    { 

    public DataTable runSproc(string[] paramName, string[] paramValue, string sproc) 
    { 
      SqlConnection conn = null; 
      DataTable dt = new DataTable(); 
      SqlDataReader reader = null; 

      try 
      { 
       string connStr = ConfigurationManager.ConnectionStrings["AC2012"].ConnectionString; 
       using (conn = new SqlConnection(connStr)) 
       { 

        SqlCommand cmd = new SqlCommand(sproc, conn); 
        cmd.CommandType = CommandType.StoredProcedure; 

        for (int x = 0; x < paramName.Count(); x++) 
        { 
         cmd.Parameters.Add(new SqlParameter(paramName[x], paramValue[x])); 
        } 
        conn.Open(); 

        reader = cmd.ExecuteReader(); 
        dt.Load(reader); 

        return dt; 
       } 
      } 
      catch (SqlException e) 
      { 
       throw (e); 
      } 
      catch (Exception ex) 
      { 
       throw (ex); 
      } 
     finally 
     { 
      if (conn != null) 
      { 
       conn.Close(); 
      } 
      if (reader != null) 
      { 
       reader.Close(); 
      } 
     } 
    } 
} 
} 

而这里的如何，我叫它..

    DataTable dt = new DataTable(); 
       string[] paramName = new string[1] { "@employee_id" }; 
       string[] paramValue = new string[1] { searchEngine.Value }; 


       dt = dbConnection.runSproc(paramName, paramValue, "pr_select_employee_by_id"); 

Answer 1

你想要一个static方法：

public static DataTable runSproc(string[] paramName, string[] paramValue, string sproc) 

或者，作为错误消息状态，必须实例化一个新的在调用实例方法之前，您的类的实例：

dbConnection conn = new dbConnection(); 
dt = conn.runSproc(paramName, paramValue, "pr_select_employee_by_id"); 

此外，通常类名是PascalCased。考虑DbConnection而不是dbConnection。