入库:
-
C# code
-
Stream ms; byte [] _byte; OpenFileDialog ofd = new OpenFileDialog(); ofd.ShowDialog(); string f = ofd.FileName; ms = ofd.OpenFile(); _byte = new byte [ms.Length]; ms.Position = 0 ; ms.Read(_byte, 0 , Convert.ToInt32(ms.Length)); SqlConnection conn = new SqlConnection( " server=.;uid=sa;pwd=;database=s " ); conn.Open(); string sqlstring = " insert into ttt(file) values(@pdf) " ; SqlCommand cmd = new SqlCommand(sqlstring, conn); cmd.Parameters.Add( " @pdf " , SqlDbType.Image, _byte.Length).Value = _byte;
-
cmd.ExecuteNonQuery();
-
从库中读取
-
C# code
-
SqlConnection conn = new SqlConnection( " server=.;uid=sa;pwd=;database=s " ); conn.Open(); string strSql = " select file from ttt " ; SqlCommand cmd = new SqlCommand(strSql, conn); SqlDataReader sdr = cmd.ExecuteReader(); sdr.Read(); MemoryStream ms = new MemoryStream(( byte [])sdr[ 0 ]);
然后把ms写入一个新文件或在程序中处理即可。 -
-
///
-
//保存
System.Data.SqlClient.SqlConnection _Conn = new System.Data.SqlClient.SqlConnection();
_Conn.Open();
System.Data.SqlClient.SqlCommand _Command = new System.Data.SqlClient.SqlCommand("Insert into 表名(字段)Values(@字段)", _Conn);
_Command.Parameters.Add(new System.Data.SqlClient.SqlParameter("@字段", SqlDbType.Image));
_Command.Parameters[0].Value = File.ReadAllBytes("PDF文件");
_Command.ExecuteNonQuery();
_Conn.Close();
//读取
System.Data.SqlClient.SqlConnection _Conn = new System.Data.SqlClient.SqlConnection();
_Conn.Open();
System.Data.SqlClient.SqlCommand _Command = new System.Data.SqlClient.SqlCommand("Select * from 表名", _Conn);
System.Data.SqlClient.SqlDataReader _Read = _Command.ExecuteReader();
byte[] _Value =(byte[]) _Read["字段"];
如果是DataTable.. 可以 (byte[])DataTable.Rows[0][0] 这个把图片保存到数据库是一样的 -
-