无法在数据库中上传视频数据（访问数据库） [英] Unable to upload video data in database(access database)
问题描述
我正在以asp.net网络形式创建视频流应用程序
在con.open（）获取错误;
以下是错误
System.Data.dll中出现'System.Data.OleDb.OleDbException'类型的异常，但未在用户代码中处理
附加信息：不是有效的文件名。
我尝试过：
protected void Button1_Click（object sender，EventArgs e）
{
String constring =Provider = Microsoft .ACE.OLEDB.12.0;数据源= F：\ videodata.accdb;
OleDbConnection con = new OleDbConnection（constring）;
FileUpload1.SaveAs（Server。 MapPath（〜/ video /）+ Path.GetFileName（FileUpload1.FileName））;
String link =video /+ Path.GetFileName（FileUpload1.FileName）;
link =< Source src =+ link +type = video / mp4>;
String query =插入EETube（名称，录像带，视频链接）值（'+ TextBox1.Text +'，'+ TextBox2.Text +'，'+ link + '）;
OleDbCommand cmd = new OleDbCommand（query，con）;
con.Open（）;
cmd.CommandText = query ;
int i = cmd.ExecuteNonQuery（）;
con.Close（）;
Label1。 Text =视频已成功上传;
TextBox1.Text =;
TextBox2.Text =;
}
背景代码是
<％@ Page Language =C＃AutoEventWireup =trueCodeBehind =TrainingSessionsPage.aspx.csInherits =EETrainingWindow.TrainingSessionsPage％>
<！DOCTYPE html>
< title> S& amp; P全球培训计划
.auto-style1 {
宽度：44％;
身高：240px;
}
.auto-style2 {
宽度：172px;
border-style：solid;
border-width：1px;
padding：1px 4px;
background-color：＃FF99FF;
}
.auto-style3 {
border-style：solid;
border-width：1px;
填充：1px 4px;
背景颜色：＃FF99FF;
}
.auto-style4 {
border-style：solid;
border-width：1px;
padding：1px 4px;
}
上传培训视频&显示DataList中的所有视频
| 视频名称 | < asp：TextBox ID =TextBox1runat =serverHeight =29pxWidth =263px> |
| 视频标题 | < asp：TextBox ID =TextBox2 runat =serverHeight =29pxWidth =263px> |
| 上传视频 | < asp：FileUpload ID =FileUpload1runat =serverHeight =30pxWidth =272px/> |
| < asp：Button ID =Button1runat =server BackColor =＃33CC33字体大小=Mediu mForeColor =WhiteOnClick =Button1_ClickText =Save VideoWidth =115px/> < asp：Label ID =Label1runat =server> |
< asp：HyperLink ID =HyperLink1runat =serverNavigateUrl =〜/ WebForm1.aspx>查看所有上传的视频
Quote：String constring =Provider = Microsoft.ACE.OLEDB。 12.0;数据源= F：\ videodata.accdb;
我认为所有典型访问db文件名以.mdb结尾
i am creating an app for video streaming in asp.net web form
getting error at con.open();
below is the error
An exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll but was not handled in user code
Additional information: Not a valid file name.
What I have tried:
protected void Button1_Click(object sender, EventArgs e)
{
String constring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\videodata.accdb";
OleDbConnection con = new OleDbConnection(constring);
FileUpload1.SaveAs(Server.MapPath("~/video/") + Path.GetFileName(FileUpload1.FileName));
String link = "video/" + Path.GetFileName(FileUpload1.FileName);
link = "<Source src =" + link + " type = video/mp4>";
String query = "Insert into EETube(Name,Videotitle,Videolink) Values('"+ TextBox1.Text +"','" + TextBox2.Text + "','" + link + "')";
OleDbCommand cmd = new OleDbCommand(query, con);
con.Open();
cmd.CommandText = query;
int i = cmd.ExecuteNonQuery();
con.Close();
Label1.Text = "Video has been Uploaded successfully";
TextBox1.Text = "";
TextBox2.Text = "";
}
background code is
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TrainingSessionsPage.aspx.cs" Inherits="EETrainingWindow.TrainingSessionsPage" %>
<!DOCTYPE html>
<title>S&P Global Training Program
.auto-style1 {
width: 44%;
height: 240px;
}
.auto-style2 {
width: 172px;
border-style: solid;
border-width: 1px;
padding: 1px 4px;
background-color: #FF99FF;
}
.auto-style3 {
border-style: solid;
border-width: 1px;
padding: 1px 4px;
background-color: #FF99FF;
}
.auto-style4 {
border-style: solid;
border-width: 1px;
padding: 1px 4px;
}
Upload Training Videos & Display All The Videos in DataList
| Video Name | <asp:TextBox ID="TextBox1" runat="server" Height="29px" Width="263px"> |
| Video Title | <asp:TextBox ID="TextBox2" runat="server" Height="29px" Width="263px"> |
| Upload Video | <asp:FileUpload ID="FileUpload1" runat="server" Height="30px" Width="272px" /> |
| <asp:Button ID="Button1" runat="server" BackColor="#33CC33" Font-Size="Medium" ForeColor="White" OnClick="Button1_Click" Text="Save Video" Width="115px" /> <asp:Label ID="Label1" runat="server"> |
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/WebForm1.aspx">View All Uploaded Videos
Quote:String constring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\videodata.accdb";
I thought all "typical" access db file names ended in ".mdb".
这篇关于无法在数据库中上传视频数据（访问数据库）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
