postgresql存图片字段类型_c#保存图片到postgreSql 中

一直以为保存图片到postgreSql中表中保存图片的字段类型为bytea，经过反复测试一直没有解决，故采用了TEXT类型来保存图片，

具体方法如下：

保存：

BL层：

public bool SavePictureToDB()

{

try

{

Stream s = File.Open(file, FileMode.Open, FileAccess.Read);

int leng = 0;

if (s.Length < Int32.MaxValue)

{

leng = (int)s.Length;

}

byte[] by = new byte[leng];

s.Read(by, 0, leng);//把图片读到字节数组中

s.Close();

string str = Convert.ToBase64String(by);//把字节数组转换成字符串

StreamWriter sw = File.CreateText("G:\\11.txt");//存入11.txt文件

#region save image into data by sql

string tableName = "TestImage";

string strSql = "insert into TestImage values('1','"+str+"');";

DataAccess dao = new DataAccess();

//dao.ExceSql(strSql);

string strSql2 = "insert into TestImage values(@id,@image);";

dao.saveData("2", str, strSql2);

#endregion

sw.Write(str);

sw.Close();

sw.Dispose();

return true;

}

catch (Exception ex)

{

throw ex;

}

}

DL层：

public bool saveData(string id, string image, string strSql)

{

try

{

NConn.Open();

NpgsqlCommand objCommand = new NpgsqlCommand(strSql, NConn);

NpgsqlParameter[] para = new NpgsqlParameter[]

{

new NpgsqlParameter("@id",DbType.String,200),

new NpgsqlParameter("@image",NpgsqlDbType.Text)

};

para[0].Value=id;

para[1].Value=image;

objCommand.Parameters.Add(para[0]);

objCommand.Parameters.Add(para[1]);

if (objCommand.ExecuteNonQuery()>0)

{

return true;

}

return false;

}

catch (Exception ex)

{

throw ex;

}

}

读取：

BL层：

public void ShowPictureOfString()

{

try

{

StreamReader sr = new StreamReader("G:\\11.txt");

string s = sr.ReadToEnd();

sr.Close();

#region read data from DB

DataAccess dao = new DataAccess();

string strStr = "select image from TestImage where id ='2'";

object data = dao.ExceSqlForString(strStr);

#endregion

byte[] buf = Convert.FromBase64String(data.ToString());//把字符串读到字节数组中

//byte[] buf = (byte[])data;

MemoryStream ms = new MemoryStream(buf);

System.Drawing.Image img = System.Drawing.Image.FromStream(ms);

pictureBox1.Image = img;

//img.Save("12.jpg", System.Drawing.Imaging.ImageFormat.Jpeg);

ms.Close();

ms.Dispose();

}

catch (Exception ex)

{

throw ex;

}

}

DL层：

public object ExceSqlForString(string strSql)

{

try

{

NConn.Open();

NpgsqlCommand objCommand = new NpgsqlCommand(strSql, NConn);

object temp =objCommand.ExecuteScalar();

return temp;

}

catch (Exception ex)

{

throw ex;

}

finally

{

NConn.Close();

}

}

此上方法即可实现将图片保存到postgreSql中！