如何上传和播放视频到数据库.. [英] how to upload and play video into database..
本文介绍了如何上传和播放视频到数据库..的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
如何从数据库播放视频...？
解决方案
嗨...
第1个视频或图像保存在文件夹中并且它的url存储在数据库中更好。
现在我们只从数据库中检索URL以进行视频或图像处理。
Ex：视频保存在文件夹中，例如
// 从fileupload获取文件名control
string filename = Path.GetFileName（fileupload.PostedFile.FileName）;
// 将图像保存到Images文件夹
fileupload.SaveAs（Server.MapPath （ 〜/ Images / + filename））;
数据库中的URL：
con = new MySqlConnection（cs）;
con.Open（）;
cmd = new MySqlCommand（ 插入Items（ProductName，ImageUrl）值（@ ImageName，@ ImagePath），con）;
// 将参数传递给查询
cmd.Parameters.AddWithValue（ @ ImageName，filename）;
cmd.Parameters.AddWithValue（ @ ImagePath， 〜/ Images / + filename）;
con.Open（）;
cmd.ExecuteNonQuery（）;
// 关闭dbconnection
con.Close（）;
所以，然后用网址选择你需要的视频，并使用你需要的视频媒体播放器。
感谢你。
嗨......
用于播放视频。
在.aspx中：
< span class =code-keyword>< asp：DropDownList ID = ddlvideo runat = server 高度 = < span class =code-keyword> 25px
< span class =code-attribute> AppendDataBoundItems = true ForeColor = DarkOliveGreen
onselectedindexchanged = DropDownList1_SelectedIndexChanged 宽度 = 170px
< span class =code-attribute> < span class =code-attribute> style = font-weight：700 AutoPostBack = True >
< / asp：DropDownList >
< span class =code-keyword>< asp：Label ID = ddllbl runat = server > < / asp：标签 >
< asp：literal id = Literal1 runat = server > < / asp：literal >
对于选择的视频（aspx.cs）：
在FormLoad中：
con = new MySqlConnection（cs）;
con.Open（）;
//查询将图像路径和名称插入数据库
cmd1 = new MySqlCommand（select * from Videos，con）;
cmd1.ExecuteNonQuery（）;
da = new MySqlDataAdapter（cmd1）;
DataSet ds = new DataSet（）;
da.Fill（ds）;
con.Close（）;
ddlvideo.DataSource = ds;
ddlvideo.Items.Add（---选择视频文件---）;
ddlvideo.DataValueField =VideoNo;
ddlvideo.DataTextField =VideoName;
ddlvideo.DataBind（）;
在DropDownList1_SelectedIndexChanged中：
protected void DropDownList1_SelectedIndexChanged（object sender，EventArgs e）
{
string surl =Videos /+ ddlvideo.SelectedItem.Text ;
if（surl ==Videos /+---选择视频文件---）
{
ddllbl.ForeColor = Color.Red;
ddllbl.Font.Bold = true;
ddllbl.Text =请选择视频文件;
Literal1.Visible = false;
}
其他
{
bool isfullsize = false;
this.Literal1.Text = this.getvideo（surl，isfullsize）;
}
}
私人字符串getvideo（字符串surl，bool isfullsize）
{
string sobj =;
surl = surl +;
surl = surl.Trim（）;
if（surl.Length> 0）
{
}
else
{
抛出新的System.ArgumentNullException（surl）;
}
sobj = sobj +< object classid ='clsid：6BF52A52-394A-11D3-B153-00C04F79FAA6'id ='Player1'height ='379'width ='500'tift ='请等待加载文件...'>;
sobj = sobj +< param name ='url'value ='+ surl +'/>;
sobj = sobj +< param name ='src'value ='+ surl +'/>;
sobj = sobj +< param name ='uimode'value ='full'/>;
sobj = sobj +< param name ='AutoStart'value ='true'/>;
sobj = sobj +< param name ='ShowControls'value ='1'/>;
sobj = sobj +< param name ='ShowStatusBar'value ='1'/>;
sobj = sobj +< param name ='ShowDisplay'value ='1'/>;
sobj = sobj +< param name ='stretchToFit'value ='1'/>;
sobj = sobj +< param name ='enablecontextmenu'value ='true'/>;
sobj = sobj +< param name ='fullscreen'value ='+ isfullsize.ToString（）+'/>;
sobj = sobj +< / object>;
返回sobj;
}
谢谢你。
wergfdsfdsdfdsffsdsaasds< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
< br />
reeeeeeeeeeeeeeeeeee< br />
eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeffg
how to play video from database...?
解决方案
Hi...
1st videos or images are save in folder and it's url is stored in database is better.
Now we are retriveing url only from database for palying video or images.
Ex:Videos save in folder like
//Get Filename from fileupload control string filename = Path.GetFileName(fileupload.PostedFile.FileName); //Save images into Images folder fileupload.SaveAs(Server.MapPath("~/Images/" + filename));
Url in database:
con = new MySqlConnection(cs); con.Open(); cmd = new MySqlCommand("Insert into Items(ProductName,ImageUrl) values(@ImageName,@ImagePath)", con); //Passing parameters to query cmd.Parameters.AddWithValue("@ImageName", filename); cmd.Parameters.AddWithValue("@ImagePath", "~/Images/" + filename); con.Open(); cmd.ExecuteNonQuery(); //Close dbconnection con.Close();
so,then select ur required video with url and use ur required media player for video's.
Thank U.
Hi...
For playing Video like.
In .aspx: <asp:DropDownList ID="ddlvideo" runat="server" Height="25px" AppendDataBoundItems="true" ForeColor="DarkOliveGreen" onselectedindexchanged="DropDownList1_SelectedIndexChanged" Width="170px" style="font-weight: 700" AutoPostBack="True"> </asp:DropDownList> <asp:Label ID="ddllbl" runat="server" ></asp:Label> <asp:literal id="Literal1" runat="server"></asp:literal>
For select Video(aspx.cs):
In FormLoad:
con = new MySqlConnection(cs); con.Open(); //Query to insert images path and name into database cmd1 = new MySqlCommand("select * from Videos", con); cmd1.ExecuteNonQuery(); da = new MySqlDataAdapter(cmd1); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); ddlvideo.DataSource = ds; ddlvideo.Items.Add("--- Select Video File ---"); ddlvideo.DataValueField = "VideoNo"; ddlvideo.DataTextField = "VideoName"; ddlvideo.DataBind(); In DropDownList1_SelectedIndexChanged: protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { string surl = "Videos/" + ddlvideo.SelectedItem.Text; if (surl == "Videos/" + "--- Select Video File ---") { ddllbl.ForeColor = Color.Red; ddllbl.Font.Bold = true; ddllbl.Text = "Pls Select Video File "; Literal1.Visible = false; } else { bool isfullsize = false; this.Literal1.Text = this.getvideo(surl, isfullsize); } }
private string getvideo(string surl, bool isfullsize) { string sobj = ""; surl = surl + ""; surl = surl.Trim(); if (surl.Length > 0) { } else { throw new System.ArgumentNullException("surl"); } sobj = sobj + "<object classid='clsid:6BF52A52-394A-11D3-B153-00C04F79FAA6' id='Player1' height='379' width='500' standby='Please wait loading file...'>"; sobj = sobj + "<param name='url' value='" + surl + "' />"; sobj = sobj + "<param name='src' value='" + surl + "' />"; sobj = sobj + "<param name='uimode' value='full' />"; sobj = sobj + "<param name='AutoStart' value='true' />"; sobj = sobj + "<param name='ShowControls' value='1' />"; sobj = sobj + "<param name='ShowStatusBar' value='1' />"; sobj = sobj + "<param name='ShowDisplay' value='1' />"; sobj = sobj + "<param name='stretchToFit' value='1' />"; sobj = sobj + "<param name='enablecontextmenu' value='true' />"; sobj = sobj + "<param name='fullscreen' value='" + isfullsize.ToString() + "' />"; sobj = sobj + "</object>"; return sobj; }
Thank u.
wergfdsfdsdfdsffsdsaasds<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> reeeeeeeeeeeeeeeee<br /> eeeeeeeeeeeeeeeeeeeeeeeeeeeefrg
这篇关于如何上传和播放视频到数据库..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
