//
得到提交的文件
Stream fileDataStream
=
MyFile.PostedFile.InputStream;
//
得到文件大小
int
fileLength
=
MyFile.PostedFile.ContentLength;
//
创建数组
byte
[] fileData
=
new
byte
[fileLength];
//
把文件流填充到数组
fileDataStream.Read(fileData,
0
,fileLength);
//
得到文件名字
string
fileTitle
=
MyFileName.Value;
//
得到文件类型
string
fileType
=
MyFile.PostedFile.ContentType;
//
构建数据库连接,SQL语句,创建参数
SqlConnection connection
=
new
SqlConnection(
"
Server=.;uid=sa;pwd=mdcija;Database=TestUploadFile
"
);
SqlCommand command
=
new
SqlCommand (
"
INSERT INTO TestFiles (MyFileName,MyFile,FileType)
"
+
"
VALUES (@MyFileName,@MyFile,@FileType)
"
, connection);
SqlParameter paramTitle
=
new
SqlParameter (
"
@MyFileName
"
, SqlDbType.VarChar,
35
);
paramTitle.Value
=
fileTitle;
command.Parameters.Add(paramTitle);
SqlParameter paramData
=
new
SqlParameter (
"
@MyFile
"
, SqlDbType.Image);
paramData.Value
=
fileData;
command.Parameters.Add(paramData);
SqlParameter paramType
=
new
SqlParameter (
"
@FileType
"
, SqlDbType.VarChar,
25
);
paramType.Value
=
fileType;
command.Parameters.Add(paramType);
//
打开连接,执行查询
connection.Open();
command.ExecuteNonQuery();
connection.Close();
Message.Text
=
"
你的文件已经成功上载
"
;
MyFileName.Value
=
""
;
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
下载:
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/613df4714e77d2025dfe171d698fc0bf.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/2308f39de1c9bbb1e6a522cebe2817aa.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/b5091e2c61375c949d5f2f7e1a8bd8a8.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/1ef386ab16c109bda7f736133e67073b.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/1ef386ab16c109bda7f736133e67073b.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/1ef386ab16c109bda7f736133e67073b.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/c776f8a820553b894fbf257b897ea929.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/64e3265768d69bb68915eb8ebe9a54b2.gif)