110,536
社区成员
发帖
与我相关
我的任务
分享
SqlDataReader dr = null;
SqlConnection objcn = new SqlConnection();
objcn.ConnectionString = "Data Source=192.168.0.252;User ID=sa;Password=1234;Initial Catalog=COMPANYDATA";
SqlCommand cm = new SqlCommand();
objcn.Open();
cm.Connection = objcn;
cm.CommandType = CommandType.Text;
cm.CommandText = "select FILEDATA from ERPCHECK";
dr = cm.ExecuteReader();
byte[] file = null;
if (dr.Read())
{
file = (byte[])dr[0];
}
string str = "F:\\测试";
FileStream fs1;
FileInfo fi1 = new System.IO.FileInfo(str);
fs1 = fi1.OpenWrite();
fs1.Write(file, 0, file.Length );
fs1.Close();