110,534
社区成员
发帖
与我相关
我的任务
分享
pictureEdit1.Image = Properties.Resources.Attachment;
private static Byte[] ConvertByte(string fileName)
{
FileStream fileStream = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Read);
byte[] byteFile = new byte[fileStream.Length];
fileStream.Read(fileDatas, 0, Convert.ToInt32(fileStream.Length));
fileStream.Close();
return byteFile ;
}
private void btnSave_Click(object sender, EventArgs e)
{
DateTime startTime = DateTime.Now;
byte[] fileDatas;
//fileDatas = ConvertByte(txtFileLocation.Text.Trim());
fileDatas = FileToBytes(Properties.Resources.Attachment.ToString());
string sql = "insert into T_Attachment(Attachment) values(@Attachment)";
ExecuteScalar(sql, new SqlParameter("@Attachment", fileDatas));
TimeSpan span = DateTime.Now - startTime;
XtraMessageBox.Show("插入成功!\n"+"共耗时:"+span.TotalSeconds.ToString());
}
ExecuteScalar(sql, new SqlParameter("@Attachment", fileDatas));
public byte[] PhotoImageInsert(System.Drawing.Image imgPhoto)
{
//将Image转换成流数据,并保存为byte[]
MemoryStream mstream = new MemoryStream();
imgPhoto.Save(mstream, System.Drawing.Imaging.ImageFormat.Bmp);
byte[] byData = new Byte[mstream.Length];
mstream.Position = 0;
mstream.Read(byData, 0, byData.Length);
mstream.Close();
return byData;
}