Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ServerתACCESS×Ô¶¯±àºÅÎÊÌâ

1.´ò¿ªSQL server enterprise mananger "ÆóÒµ¹ÜÀíÆ÷"
ÔÚÄãÒªµ¼³öµÄ SQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý

2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£

3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍΪ&ld ......

ACCESSÊý¾Ýµ¼Èëµ½SQL Server2005


ÔÚ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 Óï¾äÆôÓÃ×é¼ ......

[ת]ADO²Ù×÷accessÈ«¹ý³ÌºÍCListCtrlµÄÓ÷¨

Technorati ±êÇ©: VC,ListCtrl Ô­ÎĵØÖ·£ºhttp://www.vckbase.com/document/viewdoc/?id=1274 ADO²Ù×÷accessÈ«¹ý³ÌºÍCListCtrlµÄÓ÷¨
×÷ÕߣºÕÅÕ¹Ã÷ ÏÂÔØÔ´´úÂë
Ò»¸öADOºÍCListµÄʾÀý³ÌÐò£¨³ÌÐòÖеÄtele.log¼´ÎªaccessÎļþ£¬¿ÉÒÔÖ±½Ó¸ü¸ÄÀ©Õ¹Ãûºó´ò¿ª£©:
ʹÓÃADO²Ù×÷accessÊý¾Ý¿â.Ôö¼Ó,ɾ³ý,ÐÞ¸Ä,²éѯ ......

accessÖÐcaseÌæ´ú·½·¨

accessÖÐcaseÌæ´ú·½·¨
2009-12-26 14:01
SELECT
UserPassportID as PassportID,
UserID,
GrantorID,
Case ObjectTypeID
When 1 then ObjectID
End
as TerminalID,
Type, Flag, GrantDate, Validate, Invalidate
from UserPassport
ÔÚSQLÀïÄÜÖ´ÐÐ,µ«ÔÚAccessÀï×ÜÌáʾÓï·¨´íÎó(²Ù×÷·û¶ªÊ§).ÔÚ²éѯ±í´ïʽ'Case O ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ