请大哥大姐 帮忙解决 在线等 谢谢了
取图片保存
byte[] img = (byte[])dt.Rows[0][3];
MemoryStream ms = new MemoryStream(img);
pictureBox1.Image = Image.FromStream(ms);
System.IO.Stream)(ms)).ReadTimeout”引发了“System.InvalidOperationException”类型的异常存储图片 FileStream fs = new FileStream(tbxArea.Text, System.IO.FileMode.Open, System.IO.FileAccess.Read); //将图片读成数据流
byte[] buffByte = new byte[fs.Length];
fs.Seek(0, SeekOrigin.Begin);
fs.Read(buffByte, 0, (int)fs.Length);
fs.Close();
fs = null;
sql "UPDATE Weather SET WeatherNo='" + tbxNo.Text.Trim() + "',WeatherName='" + tbxName.Text.Trim() + "',WeatherImg='" + buffByte + "',Re='" + tbxRe.Text.Trim() + "',OrderNum='" + cSQL.ToInt(tbxOrderNum.Text.Trim()) + "' WHERE WeatherID=" + CheckNo)
C#
取图片保存
byte[] img = (byte[])dt.Rows[0][3];
MemoryStream ms = new MemoryStream(img);
pictureBox1.Image = Image.FromStream(ms);
System.IO.Stream)(ms)).ReadTimeout”引发了“System.InvalidOperationException”类型的异常存储图片 FileStream fs = new FileStream(tbxArea.Text, System.IO.FileMode.Open, System.IO.FileAccess.Read); //将图片读成数据流
byte[] buffByte = new byte[fs.Length];
fs.Seek(0, SeekOrigin.Begin);
fs.Read(buffByte, 0, (int)fs.Length);
fs.Close();
fs = null;
sql "UPDATE Weather SET WeatherNo='" + tbxNo.Text.Trim() + "',WeatherName='" + tbxName.Text.Trim() + "',WeatherImg='" + buffByte + "',Re='" + tbxRe.Text.Trim() + "',OrderNum='" + cSQL.ToInt(tbxOrderNum.Text.Trim()) + "' WHERE WeatherID=" + CheckNo)
C#
要用DataSet更新
先根据CheckNo取出记录集ds,然后用ds更新到数据库,这样用流的方式读出图片才没问题
ds.Tables[0]["WeatherNo"]=tbxNo.Text.Trim() ;
ds.Tables[0]["WeatherName"]=tbxName.Text.Trim() ;
ds.Tables[0]["WeatherImg"]=buffByte ;
ds.Tables[0]["Re"]=tbxRe.Text.Trim() ;
ds.Tables[0]["OrderNum"]= cSQL.ToInt(tbxOrderNum.Text.Trim()) ;
更新ds到数据库