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
nice blog it is very useful blog for .net learners.very informative and recommanded one thank you author best regards from sbr thak you for giving such valuabble info
ReplyDelete.net online training in hyderabad