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
Ïà¹ØÎĵµ£º
Technorati ±êÇ©: VC,ListCtrl ÔÎĵØÖ·£ºhttp://www.vckbase.com/document/viewdoc/?id=1274 ADO²Ù×÷accessÈ«¹ý³ÌºÍCListCtrlµÄÓ÷¨
×÷ÕߣºÕÅÕ¹Ã÷ ÏÂÔØÔ´´úÂë
Ò»¸öADOºÍCListµÄʾÀý³ÌÐò£¨³ÌÐòÖеÄtele.log¼´ÎªaccessÎļþ£¬¿ÉÒÔÖ±½Ó¸ü¸ÄÀ©Õ¹Ãûºó´ò¿ª£©:
ʹÓÃADO²Ù×÷accessÊý¾Ý¿â.Ôö¼Ó,ɾ³ý,ÐÞ¸Ä,²éѯ ......
Web Server Access on a VirtualBox Guest
In: Computing ÊýÂë±à³Ì
7
Oct
2008
I been using VirtualBox to deploy virtual machines on my Windows
machine since a significant memory upgrade. VirtualBox is suprisingly
easy to used if compared to VMWare and it just fit to my basic needs.
Access the ......
ËäÈ»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· ......
ÔÚSQL Server ÄÚ²éѯAccess Êý¾Ý, ²¢½«Êý¾Ý±£´æµ½SQL Server
'Jet OLEDB:Database Password=; /*Access ÃÜÂë*/
Data Source=C:\temp\Test.mdb; /*Access Êý¾Ý¿â·¾¶*/
Password=;/*Access¹¤×÷×éÃÜÂë*/
1. ²éѯAccess ±íÄÚËùÓÐÊý¾Ý
SELECT *
from OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0',
'Jet OLEDB:Database ......
'excelµ¼Èëaccess ,ÒýÓÃADO
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
On Error Resume Next
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source ......