using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand com = new SqlCommand("INSERT INTO myTable (myImage) VALUES (@IM)", con))
{
byte[] imageData = File.ReadAllBytes(@"F:\Temp\Picture.jpg");
com.Parameters.AddWithValue("@IM", imageData);
com.ExecuteNonQuery();
}
}
https://www.codeproject.com/Articles/21208/Store-or-Save-images-in-SQL-Server
https://learn.microsoft.com/zh-tw/windows/win32/msi/adding-binary-data-to-a-table-using-sql
https://www.codeproject.com/Articles/437937/Save-and-Retrieve-Image-from-a-SQL-Server-Database
https://www.codeproject.com/Articles/9323/Load-Unload-images-into-from-DB-table
Import OLE Object from Access to MySQL
https://stackoverflow.com/questions/41594/import-ole-object-from-access-to-mysql
MS Access OLE Object BLOB
extract OLE object from MS Access database Adding OLE Objects Tables and Form in Access
https://dbaportal.eu/2008/07/17/how-to-extract-ole-object-from-ms-access-database/
沒有留言:
張貼留言