2023年9月18日 星期一

sql connect insert binary datatype SqlConnection insert binary DATA

 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/

沒有留言: