Store an Image(OLE Object) into Access Data Base
Store an Image(OLE Object) into Access Data Base
C# Winform application Store an Image into Access Data Base
ÓÃÒÔÏ·½·¨
/// 2010-02-26 Forever
private void SaveImageInDataBase()
{
OleDbConnection conn = null;
try
{
string strDBFile = Environment.CurrentDirectory + @"\Test.mdb";
string connstr = "Jet OLEDB:Database Password=;Data Source='" + strDBFile + "';Password=;Provider='Microsoft.Jet.OLEDB.4.0'";
conn = new OleDbConnection(connstr);
OleDbCommand cmd;
String strimg = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\test2.bmp";
//Read Image Bytes into a byte array
//Initialize byte array with a null value initially.
byte[] imageData = null;
//Use FileInfo object to get file size.
FileInfo fInfo = new FileInfo(strimg);
&nb
Ïà¹ØÎĵµ£º
ÔÚSQL Server2005ÖÐÑ¡ÖÐÒªµ¼ÈëÊý¾ÝµÄ¿â > ÓÒ¼ü > н¨²éѯ£º
Ö´ÐÐSQLÓï¾äÈçÏ£º
insert into
Ä¿±êÊý¾Ý¿â±íÃû (×Ö¶Î1,×Ö¶Î2,....) select
×Ö¶Î1,×Ö¶Î2... from
openrowset
('microsoft.jet.oledb.4.0',';database=Ô´Êý¾Ý¿â·¾¶£¨È磺d:\test.mdb£©','select * from Ô´±í where ²éѯÌõ¼þ')
SQL Óï¾äÆôÓÃ×é¼ ......
Technorati ±êÇ©: VC,ListCtrl ÔÎĵØÖ·£ºhttp://www.vckbase.com/document/viewdoc/?id=1274 ADO²Ù×÷accessÈ«¹ý³ÌºÍCListCtrlµÄÓ÷¨
×÷ÕߣºÕÅÕ¹Ã÷ ÏÂÔØÔ´´úÂë
Ò»¸öADOºÍCListµÄʾÀý³ÌÐò£¨³ÌÐòÖеÄtele.log¼´ÎªaccessÎļþ£¬¿ÉÒÔÖ±½Ó¸ü¸ÄÀ©Õ¹Ãûºó´ò¿ª£©:
ʹÓÃADO²Ù×÷accessÊý¾Ý¿â.Ôö¼Ó,ɾ³ý,ÐÞ¸Ä,²éѯ ......
/************************************************************************
* Description: ·ÃÎÊzipÖеÄhtm Ö® Widgetsѧϰ
* Author: ³ÂÏàÀñ
* Compiled: VC8 + wxWidgets2.8.10
* Date: 04/02/10
************************************************************************/
/******************************** ......
Access±£Áô×Ö&±äÁ¿ÃûÁÐ±í£¬½¨±íʱӦ±ÜÃâʹÓÃÕâЩ´Ê»ãºÍ·ûºÅ¡£
-A
ADD
ALL
Alphanumeric
ALTER
AND
ANY
Application
AS
ASC
Assistant
AUTOINCREMENT
Avg
-B
BETWEEN
BINARY
BIT
BOOLEAN
BY
BYTE
-C
CHAR, CHARACTER
COLUMN
CompactDatabase
CONSTRAINT
Container
Count
COUNTER
CREATE
C ......