如何使用c#.net从sqlserevr下载文档 [英] how to download a documents from sqlserevr using c#.net

问题描述

你好，
我想下载一个使用sqlserver存储在数据库中的文件，您可以指导我还是发送任何代码片段

hello,
I want to download a which is stored in the database using sqlserver can u guide me or send any snippets

推荐答案

U将获得一些帮助:

在SQL中存储和检索doc/pdf/xls文件服务器 [ ^ ]


如何从以下位置存储和检索文件SQL Server数据库 [ ^ ]

U will Get Some Help :

Storing and Retrieving doc/pdf/xls files in SQL Server[^]


How to Store and Retrieve files from SQL Server Database[^]

受保护的无效cmdUpload_Click(对象发送者，EventArgs e)
{
字符串fileName = Path.GetFileName(this.fileUploadImage.FileName);
byte [] fileContent = this.fileUploadImage.FileBytes;
使用(SqlConnection连接=新的SqlConnection("Server =.\\ SQLEXPRESS; User Id = sa; Password = sapassword; Database = sampledb"))
{
connection.Open();
使用(SqlCommand命令=新的SqlCommand("INSERT INTO tblFiles(Filename，FileContent)VALUES(@Filename，@FileContent)"，连接))
{
SqlParameter fileNameParameter =新的SqlParameter("@ Filename"，System.Data.SqlDbType.NVarChar，255);
fileNameParameter.Value = fileName;
SqlParameter fileContentParameter =新的SqlParameter("@ FileContent"，System.Data.SqlDbType.VarBinary);
fileContentParameter.Value = fileContent;
command.Parameters.AddRange(new SqlParameter [] {fileNameParameter，fileContentParameter});
command.ExecuteNonQuery();
}
}
}

protected void cmdUpload_Click(object sender, EventArgs e)
{
string fileName = Path.GetFileName(this.fileUploadImage.FileName);
byte[] fileContent = this.fileUploadImage.FileBytes;
using (SqlConnection connection = new SqlConnection("Server=.\\SQLEXPRESS;User Id=sa;Password=sapassword;Database=sampledb"))
{
connection.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO tblFiles(Filename, FileContent) VALUES(@Filename, @FileContent)", connection))
{
SqlParameter fileNameParameter = new SqlParameter("@Filename", System.Data.SqlDbType.NVarChar, 255);
fileNameParameter.Value = fileName;
SqlParameter fileContentParameter = new SqlParameter("@FileContent", System.Data.SqlDbType.VarBinary);
fileContentParameter.Value = fileContent;
command.Parameters.AddRange(new SqlParameter[] { fileNameParameter, fileContentParameter });
command.ExecuteNonQuery();
}
}
}

这篇关于如何使用c#.net从sqlserevr下载文档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！