VS2008下C#存储图片到sql2005数据库中

表名：table_3

表结构

字段名              字段类型                          其它

id                     int                                 自增长

i_image           image

 

写数据库

 

//写入数据库 //创建数据库连接字符串 string strConn = @"Data Source=.;Initial Catalog=test;User ID=sa;Password=sa"; //创建SQL语句 string sql = "insert into table_3 (i_image) values (@i_image)"; try { //创建SqlConnection对象 SqlConnection connection = new SqlConnection(strConn); //创建SqlCommand对象 SqlCommand command = new SqlCommand(sql, connection); Byte[] bytBLOBData = getphoto(textEdit1.Text); ////创建参数对象 SqlParameter prm = new SqlParameter("@i_image", SqlDbType.Image, bytBLOBData.Length, ParameterDirection.Input, true, 0, 0, null, DataRowVersion.Default, bytBLOBData); command.Parameters.Add(prm); //打开数据库连接 connection.Open(); command.ExecuteNonQuery(); connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { MessageBox.Show("上传完成！"); }

 

 

/// <summary> /// 定义将图片转化为二进制代码的函数getphoto() /// </summary> /// <param name="photopath">图片路径</param> /// <returns>二进制代码</returns> public Byte[] getphoto(string photopath) { string str = photopath; FileStream file = new FileStream(str, FileMode.Open, FileAccess.Read); Byte[] bytBLOBData = new Byte[file.Length]; file.Read(bytBLOBData, 0, bytBLOBData.Length); file.Close(); return bytBLOBData; }

 

读数据库

//读数据库 //创建数据库连接字符串 string strConn = @"Data Source=.;Initial Catalog=test;User ID=sa;Password=sa"; //创建SQL语句 string sql = "select id,i_image from table_3"; try { //创建SqlConnection对象 SqlConnection connection = new SqlConnection(strConn); //打开数据库连接 connection.Open(); //创建SqlCommand对象 SqlCommand command = new SqlCommand(sql, connection); //创建DataAdapter对象 SqlDataAdapter dataAdapter = new SqlDataAdapter(command); //创建DataSet对象 DataSet dataSet = new DataSet(); //填充dataset dataAdapter.Fill(dataSet, "table_3"); int c = dataSet.Tables["table_3"].Rows.Count; connection.Close(); gridControl1.DataSource = dataSet.Tables["table_3"]; } catch (Exception ex) { MessageBox.Show(ex.Message); }