保存到sql server时实例化一个类 [英] Instantiate a class when saving to sql server

问题描述

如何访问将数据保存到sql server的类？如何实例化它，因为它不是静态的？谢谢





[更新]

 SqlConnection conn =  null ; 
 
 conn =  new  SqlConnection（System.Configuration.ConfigurationManager.ConnectionStrings [  connect]。ConnectionString）; 
 
 conn.Open（）; 
 
 SqlCommand cmd =  new  SqlCommand（  uspSaveFiscal，conn）; 
 cmd.CommandType = CommandType.StoredProcedure; 
 cmd.Parameters.AddWithValue（  @ FiscalStart，year_start.Text）; 
 cmd.Parameters.AddWithValue（  @ FiscalEnd，year_end.Text）; 
 cmd.Parameters.AddWithValue（  @ SA_Start，Convert.ToDateTime（sa_start.Text ））; 
 cmd.Parameters.AddWithValue（  @ SA_End，Convert.ToDateTime（sa_end.Text ））; 
 cmd.Parameters.AddWithValue（  @ FA_Start，Convert.ToDateTime（fa_start.Text ））; 
 cmd.Parameters.AddWithValue（  @ FA_End，Convert.ToDateTime（fa_end.Text ））; 
 cmd.Parameters.AddWithValue（  @ FiscalDesc，fiscal_desc.Text）; 
 
 SqlDataReader ha = cmd.ExecuteReader（）; 

*此函数需要转移到一个类： scheduler.cs

解决方案

您好，



您可以创建类似的课程，

  public   class  scheduler 
 {
  public   void  TestFunction（参数）
 {} 
} 
 
您可以访问此函数，如下：
 
 scheduler s =  new  scheduler（）;  //  初始化您的类对象 
 s.TestFunction（参数列表）;  //  调用您的函数 

希望它可以帮到你。

我使用了SQLHelper，DataService和DataRepository类。我通过Instance打电话给他们。感谢

how can I access a class that saves data to sql server? how to instantiate it since it is not static? thanks


[UPDATE]

SqlConnection conn = null;
       
conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connect"].ConnectionString);

conn.Open();

SqlCommand cmd = new SqlCommand("uspSaveFiscal", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FiscalStart", year_start.Text);
cmd.Parameters.AddWithValue("@FiscalEnd", year_end.Text);
cmd.Parameters.AddWithValue("@SA_Start", Convert.ToDateTime(sa_start.Text));
cmd.Parameters.AddWithValue("@SA_End", Convert.ToDateTime(sa_end.Text));
cmd.Parameters.AddWithValue("@FA_Start", Convert.ToDateTime(fa_start.Text));
cmd.Parameters.AddWithValue("@FA_End", Convert.ToDateTime(fa_end.Text));
cmd.Parameters.AddWithValue("@FiscalDesc", fiscal_desc.Text);

SqlDataReader ha = cmd.ExecuteReader();

* this function needs to be transferred to a class: scheduler.cs

解决方案

Hi,

You can create your class like,

public class scheduler
{
   public void TestFunction(parameters)
   {}
}

You can access this function as follows:

 scheduler s = new scheduler();   // initialize your class object
 s.TestFunction(parameters list); // call your function

Hope it helps you.

I Used SQLHelper, DataService and DataRepository Classes. I call them via Instance. Thanks

这篇关于保存到sql server时实例化一个类的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！