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Êý¾Ý¿â.Ôö¼Ó,ɾ³ý,ÐÞ¸Ä,²éѯ ......
mysql Ã÷Ã÷ÒѾװºÃÁË£¬µ«ÊÇÎÞ·¨·ÃÎÊ¡£Á´½ÓµÄʱºò ×ÜÊÇ˵
Access Denied.
½â¾ö·½·¨£º
ÓÃmysqld --skip-grant-tableÆô¶¯mysql
È»ºóÔÚmysql¿âÖÐÖ´ÐÐÕâ¸ö
INSERT INTO user VALUES ('localhost', 'root', PASSWORD('some_pass'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y', ......
AccessÊý¾Ý¿â²Ù×÷ÀàAccessHelper
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb ......
¼ò½é
ÔÚÔçÆÚ°æ±¾µÄ Microsoft® Access£¨Microsoft Access 2000 ÒÔǰ£©ÖУ¬Óйذ²È«ÐÔµÄ֪ʶÓÐʱ±»ÈÏΪÊÇÎÞ·¨ÎªÈκÎÈËËùÕÆÎÕºÍÓ¦Óõġ£ÄúÐèÒª°´Ë³ÐòÖ´ÐкܶಽÖ裬һµ©ÒÅ©ij¸ö²½Öè»òÕߵߵ¹ÁË˳Ðò¾Í»á´øÀ´ÔÖÄÑÐԵĺó¹û¡£Ëæ×Å Microsoft Access for Microsoft Windows® 95 µÄ Security Wizard ³öÏÖ£¬ÒÔ¼° Microsoft ......