//
得到提交的文件
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 = "" ;
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 = "" ;
下载:
string
sql
=
"
SELECT * FROM TestFiles WHERE ID = '
"
+
Request.QueryString[
"
ID
"
]
+
"
'
"
;
SqlConnection connection = new SqlConnection( " Server=.;uid=sa;pwd=mdcija;Database=TestUploadFile " );
SqlCommand command = new SqlCommand(sql, connection);
connection.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
Response.Clear();
Response.AddHeader("Content-Type",dr["FileType"].ToString());
Response.BinaryWrite((byte[])dr["MyFile"]);
}
dr.Close();
connection.Close();
SqlConnection connection = new SqlConnection( " Server=.;uid=sa;pwd=mdcija;Database=TestUploadFile " );
SqlCommand command = new SqlCommand(sql, connection);
connection.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
Response.Clear();
Response.AddHeader("Content-Type",dr["FileType"].ToString());
Response.BinaryWrite((byte[])dr["MyFile"]);
}
dr.Close();
connection.Close();