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

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

accessÈÕÆÚºÍʱ¼äº¯Êý

accessÈÕÆÚºÍʱ¼äº¯Êý
 
accessÈÕÆÚºÍʱ¼äº¯Êý
------------------------------------------------
ÉèÖõ±Ç°ÈÕÆÚ»òʱ¼ä¡£ Date ,Now, Time
¼ÆËãÈÕÆÚ: DateAdd, DateDiff, DatePart
·µ»ØÈÕÆÚ: DateSerial, DateValue
·µ»ØÊ±¼ä: TimeSerial, TimeValue
ÉèÖÃÈÕÆÚ»òʱ¼ä: Date, Time
¼ÆÊ±: Timer
ÔÚ°ïÖú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ