asp.net如何读出保存在sqlserver里的文件呢？

[ltyx01]

文件上传保存到sqlserver的一字段里面了，怎么读出来啊！我是想这样做的，点击某一个链接就弹出对话框问是直接打开还是直接下载，如果点击下载，就有一个保存对话框了，但对话框默认的保存文件名是怎么指定的，如我用一字段纪录那个文件名是　abc.doc　，那么保存对话框默认指定的文件名就应该是 abc.doc啊；

不管文件类型是否是浏览器能直接显示浏览，都要弹出对话框询问是下载还是直接打开哦！哪位先生帮帮我啊!

[uno]

Response.AddHeader("Content-disposition", "attachment; filename=" + 文件名);
Response.Write(数据);

[panyee]

<%@Page language="C#"%>
<%@import namespace="System.Data"%>
<%@import namespace="System.Data.SqlClient"%>
<script language="C#" runat="server">
public void Page_Load(Object o, EventArgs e)
{
int ImgID = Convert.ToInt32(Request.Params["id"]);
string connStr = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection conn = new SqlConnection(connStr);
string sql = "select * from t_imgs where id = @ImgID";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@ImgID", SqlDbType.Int).Value = ImgID;
conn.Open();
SqlDataReader read = cmd.ExecuteReader();
read.Read();
Response.ContentType = (string)read["type"];
string strFileName = System.Web.HttpUtility.UrlEncode( System.Text.Encoding.UTF8.GetBytes((string)read["imgName"]);
Response.AppendHeader("Content-Disposition", "attachment; filename=" + strFileName);
Response.ContentType = "application/octet-stream";
Response.BinaryWrite((byte[])read["imgData"], 0, (int)read["imgSize"]);
Response.End();
conn.Close();
}
</script>

[ltyx01]

我是读数据库中的二进制流出来波， uno(钢盅郭子) 这样可行吗？

[acewang]

文件下载
用aspx读取文件输出它
string strFile = "e:\\test.doc";
FileStream fs = new FileStream(strFile, FileMode.Open);
byte[] bytes = new byte[(int)fs.Length];
fs.Read(bytes, 0, bytes.Length);
fs.Close();
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Disposition", "attachment;filename=" & strFile);
Response.BinaryWrite(bytes);
Response.End();

[acewang]

文件上传参考：

http://www.chinabs.net/aspnet/default.asp?infoid=100

[ltyx01]

谢谢大家先，有哪位继续啊

[付长松_华为云MVP]

SqlDa.SelectCommand.CommandText = "select * from itemcontent where icid=" + id
SqlDa.SelectCommand.Connection = Conn
SqlDa.Fill(DsContent1, "ic")

Dim dr As SqlClient.SqlDataReader = SqlDa.SelectCommand.ExecuteReader
dr.Read()

'数据为空退出
If dr.IsDBNull(9) Then
Response.Write("<script language='JavaScript'>alert('没有文件信息');</script>")
Response.Write("<script language='JavaScript'>window.close();</script>")
Exit Sub
End If
'读取数据
Dim TrueSize = dr.GetBytes(fileDataCol, 0, Nothing, 0, Integer.MaxValue)
Dim fileContent(TrueSize) As Byte
dr.GetBytes(fileDataCol, 0, fileContent, 0, TrueSize)

'将变量设置为实际读取的长度
Response.ContentType = DsContent1.Tables("ic").Rows(0).Item("filetype")
Response.AddHeader("Content-Disposition", "attachment; filename=" + DsContent1.Tables("ic").Rows(0).Item("filename"))
Me.Response.Clear()
Dim fs As System.IO.Stream = Me.Response.OutputStream
fs.Write(fileContent, 0, fileContent.Length)
fs.Close()
Response.End()

[ltyx01]

呵呵，我要的是Asp.net之C＃篇的，谢谢！我也试了，可是我不知道问题出在哪了就是不弹出窗口问问我是否下载还是直接打开啊！