Hi to all
Please copy and paste this query in your database. Paste this in new query editor window of Mingalspot Db it's is the entity and sp for Videos.
Create Table TblVideos
(
VideoId BigInt Primary Key Identity(01,01),
VideoName Varchar(500),
Video VarBinary(max),
Fpath Varchar(500)
)
Create Procedure Sp_UploadVideo
(
@vname Varchar(500),
@video VarBinary(max),
@fpath Varchar(500)
)
as
Begin
Insert Into TblVideos(VideoName,Video,Fpath)Values(@vname,@video,@fpath)
End
Create Procedure Sp_Videos
As
Begin
Select VideoName,Fpath From TblVideos
End
Please copy and paste this query in your database. Paste this in new query editor window of Mingalspot Db it's is the entity and sp for Videos.
Create Table TblVideos
(
VideoId BigInt Primary Key Identity(01,01),
VideoName Varchar(500),
Video VarBinary(max),
Fpath Varchar(500)
)
Create Procedure Sp_UploadVideo
(
@vname Varchar(500),
@video VarBinary(max),
@fpath Varchar(500)
)
as
Begin
Insert Into TblVideos(VideoName,Video,Fpath)Values(@vname,@video,@fpath)
End
Create Procedure Sp_Videos
As
Begin
Select VideoName,Fpath From TblVideos
End