Deepak  Sharma

Deepak Sharma

  • NA
  • 12
  • 3.6k

show Title from my database on date and time with audio?

Jun 2 2014 5:27 AM

asp.net mvc 4

 
 
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…


USE [MobileNotes]
GO

/****** Object: Table [dbo].[Notes] Script Date: 6/2/2014 2:50:38 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

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]

GO



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:-

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.


Answers (1)