I want to show Title from my database on date and time with audio.

See more:

MVC4

I am having a problem to make Notes reminder, unable to play audio on time and time is save on my table structure like this…

CREATE TABLE [dbo].[Notes](
    [SN] [int] IDENTITY(1,1) NOT NULL,
    [Title] [nvarchar](max) NULL,
    [Date] [date] NULL,
    [NoteTime] [nvarchar](20) NULL,
    [Status] [nvarchar](20) NULL,
 CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED
(
    [SN] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

I have to play a sound on on date and NoteTime which is stored in my database..

Index (View Page):-

 <p><source src="@Url.Action("myaudio")" type="audio/mp3" /></p>

Controller:-
<pre lang="c#">public ActionResult Index()
{
   var file = Server.MapPath("~/app_data/ipl.mp3");
   return File(file, "audio/mp3"); // I am unable to call two return in one view.
   return View(db.Notes.ToList()); // list of record from my database..

 }

• Individually works both but audio is not playing on date and time accroding to database because I don’t know how to do. it play on page load when we not return
return View(db.Notes.ToList());
• I want to show Title from my database on date and time with audio.