向sqlce 里插入和取出一个Image
来源:互联网 发布:centos怎么设置中文 编辑:程序博客网 时间:2024/04/29 21:53
存图片
string assemblyFolder = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
string str = "Data Source='" + assemblyFolder + "//MobileService.sdf'";
SqlCeConnection conn = new SqlCeConnection(str);
conn.Open();
Image ImageI = new Bitmap(assemblyFolder + "//1.jpg");
string cmdstr = "insert into job(aa,bb,cc,dd) values(77,'fieldbb','fieldcc',@Parmfan)";
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = cmdstr;
SqlCeParameter param = new SqlCeParameter();
param.ParameterName = "@Parmfan";
param.SqlDbType = SqlDbType.Image;
cmd.Parameters.Add(param);
cmd.Prepare();
MemoryStream imageStream = new MemoryStream();
ImageI.Save(imageStream, System.Drawing.Imaging.ImageFormat.Bmp);
byte[] bytes = imageStream.GetBuffer();
cmd.Parameters["@Parmfan"].Size = bytes.Length;
cmd.Parameters["@Parmfan"].Value = bytes;
cmd.ExecuteNonQuery();
MessageBox.Show("ok");
取图片
string assemblyFolder = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
string str = "Data Source='" + assemblyFolder + "//MobileService.sdf'";
SqlCeConnection conn = new SqlCeConnection(str);
conn.Open();
string cmdstr = "select * from job";
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = cmdstr;
cmd.ExecuteReader();
SqlCeDataAdapter DataA = new SqlCeDataAdapter(cmd);
DataSet ds = new DataSet();
DataA.Fill(ds,"jobtable");
byte[] bytes = (byte[])ds.Tables["jobtable"].Rows[0].ItemArray.GetValue(3);
MemoryStream imageStream = new MemoryStream(bytes);
Image ImageI = new Bitmap(imageStream);
pictureBox1.Image = ImageI;
MessageBox.Show("ok");
string assemblyFolder = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
string str = "Data Source='" + assemblyFolder + "//MobileService.sdf'";
SqlCeConnection conn = new SqlCeConnection(str);
conn.Open();
Image ImageI = new Bitmap(assemblyFolder + "//1.jpg");
string cmdstr = "insert into job(aa,bb,cc,dd) values(77,'fieldbb','fieldcc',@Parmfan)";
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = cmdstr;
SqlCeParameter param = new SqlCeParameter();
param.ParameterName = "@Parmfan";
param.SqlDbType = SqlDbType.Image;
cmd.Parameters.Add(param);
cmd.Prepare();
MemoryStream imageStream = new MemoryStream();
ImageI.Save(imageStream, System.Drawing.Imaging.ImageFormat.Bmp);
byte[] bytes = imageStream.GetBuffer();
cmd.Parameters["@Parmfan"].Size = bytes.Length;
cmd.Parameters["@Parmfan"].Value = bytes;
cmd.ExecuteNonQuery();
MessageBox.Show("ok");
取图片
string assemblyFolder = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
string str = "Data Source='" + assemblyFolder + "//MobileService.sdf'";
SqlCeConnection conn = new SqlCeConnection(str);
conn.Open();
string cmdstr = "select * from job";
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = cmdstr;
cmd.ExecuteReader();
SqlCeDataAdapter DataA = new SqlCeDataAdapter(cmd);
DataSet ds = new DataSet();
DataA.Fill(ds,"jobtable");
byte[] bytes = (byte[])ds.Tables["jobtable"].Rows[0].ItemArray.GetValue(3);
MemoryStream imageStream = new MemoryStream(bytes);
Image ImageI = new Bitmap(imageStream);
pictureBox1.Image = ImageI;
MessageBox.Show("ok");
- 向sqlce 里插入和取出一个Image
- 图片的插入和取出
- sqlce 里存取图片
- 使用POI向Excel里插入图片
- VB SQLServer image数据存入和取出ADODB.Stream
- 从一个标准 url 里取出文件的扩展名
- 怎样从一个标准url里取出文件的扩展名?
- 从一个标准 url 里取出文件的扩展名
- 从一个标准 url 里取出文件的扩展名
- 从一个URL里取出文件的拓展名
- 从一个标准 url 里取出文件的扩展名
- 怎样向SQL Server插入带有Image字段的记录
- 怎样向SQL Server插入带有Image字段的记录
- 怎样向SQLServer插入带有Image字段的记录
- sqlite和sqlce性能对比
- Spring取出bean的方法和xml里的配置
- 从map或hashmap里取出key和value值
- 嵌入式数据库sqlce和sqlite的使用方法(sqlce)
- 《糖》
- 2007.4.9(毕业设计日志)
- java关键字介绍
- 卡巴斯基 , windows 2000 professional , 蓝屏问题
- 读网070409
- 向sqlce 里插入和取出一个Image
- 关于Linux下.bin格式文件的安装
- DataTable,DataView和DataGrid比较
- JS应用(资料很全)
- tar.bz2文件的解压
- LISTVIEW怎么绑定数据库
- SQL查询语句精华使用简要
- 学习JAVA的经验
- 复活节真的让我"复活"了吗?