如何将image对象行保存到数据库?
Byte[] bo = null;
MemoryStream stream = new MemoryStream();
Image image = this.pictureBox1.Image;
image.Save(stream, ImageFormat.Jpeg); //这一句报错
bo = stream.GetBuffer();
请问如何解决,谢谢
Byte[] bo = null;
MemoryStream stream = new MemoryStream();
Image image = this.pictureBox1.Image;
image.Save(stream, ImageFormat.Jpeg); //这一句报错
bo = stream.GetBuffer();
请问如何解决,谢谢
解决方案 »
- xml反序列化
- Asp.net程序 RC6_实现中文加解密
- iis7下载文件提示404.0 - Not Found
- 安装sqlserver 2005出现性能监视器计数器要求 (错误)
- 郁闷死了,关闭事件的问题
- 时间循环排序问题 从左到右 0点-23点简单,9 - 23 - 0 - 8 这个就比较复杂了。
- Web按纽提交后,如何在提交前触发一个客户端脚本
- 我用VS2003 C#做一个程序,需要HTTP POST。但是第一次能成功,第二次就(GetResponse()处)报错提示基础连接已经关闭。请高手帮帮小弟
- 求助!用户控件的问题
- 大家评论一下C#使用设计模式。
- OleDb和OracleClient效率有多大差别?
- 求一算法
try
{
SqlConnection conn = new SqlConnection("Server=127.0.0.1;uid=sa;pwd=123456;database=train");
string sql="select * from test1";
SqlDataAdapter sda = new SqlDataAdapter(sql,conn);
SqlCommandBuilder MyCB = new SqlCommandBuilder(sda);
DataSet ds = new DataSet("DocFile");
string filePath=Path.GetDirectoryName(Application.ExecutablePath)+@"\File\ExamPaper.doc";
//string filePath=Path.GetDirectoryName(Application.ExecutablePath)+@"\File\1.jpg"; FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Read); byte[] MyData= new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
fs.Close();
sda.Fill(ds,"DocFile"); DataRow myRow;
myRow=ds.Tables["DocFile"].NewRow();
myRow["doc_file"] = MyData;
ds.Tables["DocFile"].Rows.Add(myRow);
sda.Update(ds, "DocFile");
conn.Close();
MessageBox.Show ("文件保存到数据库存成功");
}
catch(Exception E)
{
MessageBox.Show(E.ToString());
}
读取:
try
{
SqlConnection conn = new SqlConnection("Server=127.0.0.1;uid=sa;pwd=123456;database=train");
string sql="select * from test1";
SqlDataAdapter sda = new SqlDataAdapter(sql,conn);
SqlCommandBuilder MyCB = new SqlCommandBuilder(sda);
DataSet ds = new DataSet("DocFile");
sda.Fill(ds, "DocFile");
DataRow myRow=ds.Tables["DocFile"].Rows[1];
//DataRow myRow=ds.Tables["DocFile"].Rows[4];
byte[] MyData= (byte[])myRow["doc_file"];
//this.pictureBox1 .Image =Image.FromStream (new MemoryStream(MyData));
int ArraySize = new int();
ArraySize = MyData.GetUpperBound(0);
FileStream fs = new FileStream(@"C:\1.doc", FileMode.OpenOrCreate, FileAccess.Write);
fs.Write(MyData, 0,ArraySize);
fs.Close();
MessageBox.Show ("文件从数据库中读取成功");
}
catch(Exception Ex)
{
MessageBox.Show (Ex.ToString ());
}