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();
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)