1
string
strCnn
=
System.Web.Configuration.WebConfigurationManager.ConnectionStrings[
"
ConnectionStringName
"
].ConnectionString;
2
SqlConnection myConnection
=
new
SqlConnection(strCnn);
3
SqlCommand command
=
new
SqlCommand(
"
select 附件, 附件名称, 附件类型 from 表名 Where NewsID =
"
+
Request.QueryString[
"
id
"
], myConnection);
4
myConnection.Open();
5
SqlDataReader dr
=
command.ExecuteReader();
6
if
(dr.Read())
7
{ 8 Response.Clear(); 9 10 Response.HeaderEncoding = System.Text.Encoding.GetEncoding("GB2312"); 11 12 Response.AddHeader("Content-Type", dr["附件类型"].ToString()); // File Upload时存到数据库的1314 Response.AppendHeader("TITLE", dr["附件名称"].ToString());15 16 Response.AppendHeader("Content-Disposition", "inline;filename=\"" + dr["附件名称"].ToString() + "\"");1718 Response.BinaryWrite((byte[])dr["附件"]);19}
20
dr.Close();
21
myConnection.Dispose();
22
转载于:https://www.cnblogs.com/lfzwenzhu/articles/1243105.html
相关资源:.net+devexpress附件管理,附件处理