java cmd net use_Display or Download Documents Saved in SQL Server with ASP.NET

I have documents saved in a SQL Server database as varbinary(MAX).

I am trying to retrieve the document from the database with below code. The problem I am facing is that no matter the browser I use, I don't get any response back. No dialog the browser just displays the turning circle. Any suggestions would be highly appreciated..

if (e.ButtonID != "Download")

return;

int id = 2;

byte[] bytes;

string fileName, contentType;

string constr = ConfigurationManager.ConnectionStrings["bexsConnectionString"].ConnectionString;

using (SqlConnection con = new SqlConnection(constr))

{

using (SqlCommand cmd = new SqlCommand())

{

cmd.CommandText = "select Title, WillData, MIMEType from Will_documents where Doc_id = @Id";

cmd.Parameters.AddWithValue("@Id", id);

cmd.Connection = con;

con.Open();

using (SqlDataReader sdr = cmd.ExecuteReader())

{

sdr.Read();

bytes = (byte[])sdr["WillData"];

contentType = sdr["MIMEType"].ToString();

fileName = sdr["Title"].ToString();

Response.Buffer = true;

Response.Charset = "";

Response.Clear();

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = contentType;

Response.BinaryWrite(bytes);

Response.Flush();

Response.End();

}

con.Close();

}

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值