Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

access²Ù×÷

uses
ADODB;
procedure TForm1.SetupTable(sender:tobject);
Var
adocon1:TADOConnection;
strSQL:string;
Const
SConnectionString= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;'
+'Jet OLEDB:Database Password=%s;';
begin
adocon1:=TADOConnection.creat(self);
adocon1.ConnectionString:=format(S ......

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

²É·Ã·Ö²¼Ê½Êý¾Ý·ÃÎʲã(Data Access Layer)

·Ö²¼Ê½(Distributed)Êý¾Ý·ÃÎʲã(Data Access Layer)(ÒÔϼò³ÆDAL)ÊÇ×ÛºÏMySQL Proxy¡¢Memcached¡¢¼¯ÈºµÈµÈ¼¼ÊõÓÅµã¶ø¹¹½¨µÄÒ»¸öÈí¼þϵͳ¡£Ä¿µÄÊÇΪÁ˽â¾öÔÚ¹¹½¨´óÖÐÐÍÍøÕ¾Ê±Óöµ½µÄºÍÊý¾Ý·ÃÎÊÓйصÄÖî¶àÎÊÌ⣬ÈçÔõôʹµÃÇпâ·Ö±í͸Ã÷»¯£¬ÈçºÎʹµÃ»º´æ´æÈ¡Çå³ý×Ô¶¯»¯£¬ÔõÑù²ÅÄܸüºÃµØ·ÀÖ¹·þÎñµ¥µã¹ÊÕÏµÈµÈ ......

AccessºÍFirebirdµÄÐÔÄܱȽÏ

ËäÈ»Firebird×ÜÌåÉÏÊDZÈAccessºÃ£¬µ«ÊÇûÓд«ËµµÄÄÇôºÃ£¬ÖÁÉÙÔÚNet»·¾³Ï¡£
1¡¢²âÊÔ»·¾³
¡¡¡¡A¡¢ÏµÍ³»·¾³
¡¡¡¡²Ù×÷ϵͳ£ºWindows XP Professional Server Pack 2
¡¡¡¡CPU£ºIntel(R) Pentium(R) 4 CPU 3.00GHZ 2.99GHZ
¡¡¡¡Äڴ棺1G
¡¡¡¡B¡¢´úÂë»·¾³
¡¡¡¡NET2.0¡¢Access2003¡¢Firebird2.1¡¢
¡¡¡¡FirebirdµÄNET2.0· ......

using OPENROWSET Select Access Data Base Data

ÔÚSQL Server ÄÚ²éѯAccess Êý¾Ý, ²¢½«Êý¾Ý±£´æµ½SQL Server
-- OPENROWSET ACCESS ²»ÄÜÓÐÃÜÂë, ÓÐÃÜÂëÓÃOPENDATASOURCE
SELECT *
from OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Test.mdb'; /*Access Êý¾Ý¿â·¾¶*/
'admin'; /*Access¹¤×÷×éÃÜÂë*/
'',/*Access¹¤×÷×éÃÜÂë*/
[AccessTableName])
1. ²éѯAcce ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ