C# 利用datatable将sqlserver中的Image取出来

先把sqlserver数据库一个表装载到datatable里面，然后进行如下操作

               Bitmap IMG!=null;

                Bitmap IMG2=null;

                MemoryStream ms=null;

                 byte[] b1 = (byte[])dt.Rows[0]["照片1"];                   byte[] b2 = (byte[])dt.Rows[0]["照片2"];                   ms = new MemoryStream(b1);                 IMG1 = new Bitmap(ms);//取出照片1                  ms = new MemoryStream(b2);                IMG2= new Bitmap(ms);//取出照片2                 ms.Flush();

                ms.Close();

网上还有好的办法。例如

存: public void Save() { using(System.IO.FileStream stream = new System.IO.FileStreamfile,System.IO.FileMode.Open,System.IO.FileAccess.Read) { byte[] buffer = new byte[stream.Length]; stream.Read(buffer, 0, (int)stream.Length); stream.Close(); string strName = System.IO.Path.GetFileNameWithoutExtension(file); SqlCommand cmd = new SqlCommand("Insert into Temp(name,photo) values(@name,@image)", sqlConn); cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = strName; cmd.Parameters.Add("@image", SqlDbType.Image).Value = buffer; cmd.ExecuteNonQuery(); } } 取: public void GetImage() { SqlCommand cmd = new SqlCommand(@"SELECT name, photo FROM Temp", sqlConn); sqlConn.Open(); SqlDataReader reader = cmd .ExecuteReader(); if (reader.Read()) { image_filename= (string) reader.GetValue(0); byte[] image_bytes = (byte[]) reader.GetValue(1); MemoryStream ms = new MemoryStream(image_bytes); Bitmap bmap = new Bitmap(ms); return bmap; } }