Esempio n. 1
0
    public static FooterNotes GetFooterNotesText()
    {
        FooterNotes   returnObject = new FooterNotes();
        SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["TriadAdvertsConnectionString"].ToString());
        string        SPName       = "GetFooterNotes";
        SqlCommand    myCommand    = new SqlCommand(SPName, myConnection);

        myCommand.CommandType = CommandType.StoredProcedure;

        try
        {
            myConnection.Open();
            SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
            for (
                ; myReader.Read();
                )
            {
                returnObject = FooterNotesDB.toObject(myReader);
            }
            myReader.Close();
        }
        catch (Exception)
        {
            throw;
        }

        return(returnObject);
    }
 public static FooterNotes GetFooterNotesText()
 {
     return(FooterNotesDB.GetFooterNotesText());
 }