视频上传和查看asp.net c＃ [英] video Upload and view in asp.net c#

问题描述

请给我正确的视频上传编码和查看以保存在数据库中

Please give me correct coding for video upload and view to save in database also

推荐答案

参考此文章..

将MP3音频文件保存到数据库并在ASPNet GridView中显示 [ ^ ]

代替音频播放器使用Window media player嵌入代码并传递保存在数据库中的视频URL以播放视频文件。

Refer this Article..
Save MP3 Audio Files to database and display in ASPNet GridView[^]
in place of audio player Use Window media player embed code and pass video url saved in database to play video files.

上传并保存数据库中的视频网址



Sql查询 -

To Upload and save Video url in database

Sql queries-

create table videos(video_name varchar(200),videosong_loc varchar(500))
create procedure video_upload
@video_name varchar(200),
@video_loc varchar(500)
as
insert into videos values(@video_name,@video_loc)
select * from videos
create procedure Show_video
as
select * from videos
select * from mp3songs

对于aspx（在页面上拖放文件上传控件） -

For aspx(drag and drop fileupload control on page)-

<table class="style1">
            <tr>
                <td colspan="2">
                    <asp:FileUpload ID="FileUpload1" runat="server" />
                </td>
            </tr>
            <tr>
                <td class="style2">
                    <asp:Label ID="Label1" runat="server" Text="Video song name"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtvideoname" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style2">
                    &nbsp;</td>
                <td>

                </td>
            </tr>
            <tr>
                <td class="style2">
                    &nbsp;</td>
                <td>
                 <asp:Button ID="btnInvoke" runat="server" onclick="btnInvoke_Click" Text="Upload" />
                </td>
            </tr>
            <tr>
                <td class="style2">
                    &nbsp;</td>
                <td>
                    <asp:Label ID="Label2" runat="server"></asp:Label>
                </td>
            </tr>
        </table>

对于CS（在目录中创建一个文件夹名称Video） -

For CS(Create one folder name "Video" in the directory)-

    prote
cted void btnInvoke_Click(object sender, EventArgs e)

    {
        
        string name = FileUpload1.PostedFile.FileName;
        string ext = System.IO.Path.GetExtension(this.FileUpload1.PostedFile.FileName);
        if (FileUpload1.PostedFile.ContentLength == 0)
        {

            Label1.Text = "Cannot upload zero length file";
        }






        if (ext == ".wmv"||ext==".flv")
        {
            DateTime dt = DateTime.Now;
            string tme = dt.ToLongTimeString();
            string[] t = tme.Split(':');

            string y = "";
            foreach (string x in t)
            {
                y += x;
            }

            string aa = y + "_" + name;
            string location = Server.MapPath(" ") + "\\videos\\" + aa;
            FileUpload1.PostedFile.SaveAs(location);
            string loc = aa;
            //Session["location1"] = loc;
            SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=db;integrated security=true;");
            SqlCommand sqlcomm = new SqlCommand("video_upload", sqlconn);
            sqlcomm.CommandType = CommandType.StoredProcedure;
            sqlcomm.Parameters.Add("@video_name", SqlDbType.VarChar, 200).Value = txtvideoname.Text;
            sqlcomm.Parameters.Add("@video_loc", SqlDbType.VarChar, 500).Value = loc;
            sqlconn.Open();
            sqlcomm.ExecuteNonQuery();
            sqlconn.Close();

            Label2.Text = "Video Song uploaded Successfully";
        }
        else
        {
            Label2.Text = "please choose .wmv file";
        }
    }

并显示上传的视频 -



现在在Gridview上拖放 -

And To Show uploaded Video-

Now Drag and Drop on Gridview on page-

<asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" xmlns:asp="#unknown">
        CellPadding="20" ForeColor="#333333" GridLines="None">
        <rowstyle backcolor="#F7F6F3" forecolor="#333333" />
    <columns>
    <asp:boundfield datafield="video_name" headertext="Video Name" />
    <asp:templatefield headertext="Play Video">
    <itemtemplate>
    <a href="playvideo.aspx?id=<%# Eval(" videosong_loc=") %>">Play Video</a>
    
    </itemtemplate>
    
    </asp:templatefield>
    
    </columns>
        <footerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White" />
        <pagerstyle backcolor="#284775" forecolor="White" horizontalalign="Center">
            Width="500px" />
        <selectedrowstyle backcolor="#E2DED6" font-bold="True" forecolor="#333333" />
        <headerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White" />
        <editrowstyle backcolor="#999999" />
        <alternatingrowstyle backcolor="White" forecolor="#284775" />
    </pagerstyle></asp:gridview>

和Page_load（CS Code）

and on Page_load(CS Code)

SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=db;Integrated Security=True");
            SqlCommand sqlcomm = new SqlCommand("Show_video", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
            sqlconn.Open();
            SqlDataReader dr = sqlcomm.ExecuteReader();
            if (dr.HasRows)
            {
                GridView1.DataSource = dr;
                GridView1.DataBind();
                sqlconn.Close();
                dr.Close();
            }

和gridview你会看到一个播放按钮，当你点击Play然后它会重定向你在play.aspx上（创建一个页面play.aspx并在其上放置一个标签控件）。

and in gridview u'll See a Play Button when u'll Click on Play then it will Redirect u on play.aspx(Create one page play.aspx and place one label control on it).

<asp:label id="Label1" runat="server" text="Label"></asp:label>

和on CS（在Page_load上） -

and on CS(on Page_load)-

string play = Request.QueryString["id"];
            string strSQL = "select * from videos where videosong_loc='" + play + "'";
            SqlConnection sconn = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=db;Integrated Security=True");

            SqlCommand scomm = new SqlCommand(strSQL, sconn);
            sconn.Open();
            SqlDataReader sreader = scomm.ExecuteReader();
            if (sreader.Read())
            {

                string Str = "videos\\" + sreader[1].ToString();
                string text = "<embed src="" + Str + "" height="300" width="500"><noembed>Sorry, your browser doesn't support the embedding of multimedia.</noembed></embed>";
                //Response.Write(text);
                Label1.Text = text;
                sreader.Close();
                sconn.Close();

请遵循以下代码并使用您的Mind Shalini Ji：D

Happy Coding：）

Follow these codes and use your Mind Shalini Ji :D
Happy Coding :)

这篇关于视频上传和查看asp.net c＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！