如何把图片存储到ACCESS数据库里?
然后显示出来,我用的水晶报表显示的,着急ing!!!!!!
谢谢大家,在线等!!!!!!!!!! 已经在表里添加了一条字段,ole对象类型的.
------解决方案--------------------http://topic.csdn.net/t/20050925/14/4292611.html
------解决方案--------------------C# 复制代码
public static void AddEmployee(
string lastName,
string firstName,
string title,
DateTime hireDate,
int reportsTo,
string photoFilePath,
string connectionString)
{
byte[] photo = GetPhoto(photoFilePath);
using (SqlConnection connection = new SqlConnection(
connectionString))
SqlCommand command = new SqlCommand(
"INSERT INTO Employees (LastName, FirstName, " +
"Title, HireDate, ReportsTo, Photo) " +
"Values(@LastName, @FirstName, @Title, " +
"@HireDate, @ReportsTo, @Photo) ", connection);
command.Parameters.Add( "@LastName ",
SqlDbType.NVarChar, 20).Value = lastName;
command.Parameters.Add( "@FirstName ",
SqlDbType.NVarChar, 10).Value = firstName;
command.Parameters.Add( "@Title ",
SqlDbType.NVarChar, 30).Value = title;
command.Parameters.Add( "@HireDate ",
SqlDbType.DateTime).Value = hireDate;
command.Parameters.Add( "@ReportsTo ",
SqlDbType.Int).Value = reportsTo;
command.Parameters.Add( "@Photo ",
SqlDbType.Image, photo.Length).Value = photo;
connection.Open();
command.ExecuteNonQuery();
}
}
public static byte[] GetPhoto(string filePath)
{
FileStream stream = new FileStream(
filePath, FileMode.Open, FileAccess.Read);
BinaryReader reader = new BinaryReader(stream);
byte[] photo = reader.ReadBytes((int)stream.Length);
reader.Close();
stream.Close();
return photo;
}
------解决方案--------------------以二进制文件的方式存储
------解决方案--------------------图片读成流.保存进去就可以啦...
------解决方案--------------------http://www.cnblogs.com/webabcd/archive/2006/12/11/588600.html
------解决方案--------------------http://dotnet.aspx.cc/article/9154bc99-df64-4e2d-b096-26c99ce464be/read.aspx
------解决方案--------------------转换成二进制流三