/// <summary> /// Example method for retrieving specific data /// </summary> /// <param name="Parameter1"></param> /// <returns></returns> public DataSet GetCustomerData(int Parameter1) { SqlCommand cmd = new SqlCommand("Stored_Procedure_Name"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Parameter1", Parameter1); using (Common.SQL sql = new Common.SQL()) { DataSet ds = sql.GetSqlDataSet("Database_Name", cmd); return(ds); } }
/// <summary> /// Example method for getting 1 or more events to test /// </summary> /// <returns></returns> public DataSet GetTestEvents() { SqlCommand cmd = new SqlCommand("Stored_Procedure_Name"); cmd.CommandType = CommandType.StoredProcedure; using (Common.SQL sql = new Common.SQL()) { DataSet ds = sql.GetSqlDataSet("Database_Name", cmd); return(ds); } }