110,538
社区成员
发帖
与我相关
我的任务
分享
protected void write_file(string sqlstr, SqlConnection conn )
{
if (conn.State != ConnectionState.Open)
conn.Open();
string num = "0";
string filepath = file_dir + "name_"+num+".pdf";
while (File.Exists(filepath))
{
num = Convert.ToString(Convert.ToInt32(filepath.Split('_').Last().ToString().Split('.').First().ToString()) + 1);
filepath = file_dir + "name_" + num + ".pdf";
}
SqlCommand cmd = new SqlCommand(sqlstr, conn);
cmd.CommandTimeout = 0;
SqlDataReader reader = cmd.ExecuteReader();
byte[] buffer;
FileStream fs = new FileStream(filepath, FileMode.Create, FileAccess.Write);
while (reader.Read())
{
buffer = (byte[])reader["con_img"];
fs.Write(buffer, 0, buffer.Length);
}
reader.Close();
fs.Close();
}