Image To Access
using System;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.IO;
using System.Windows.Forms;
namespace ImageDB
{
public partial class FormImageAccess : Form
{
#region ×Ô¶¨Òå¶ÔÏó
private OleDbConnection ole;
private DataTable table;
#endregion
public FormImageAccess()
{
#region
InitializeComponent();
openFileImage.Filter = "ͼÏñÎļþ|*.bmp;*.gif;*.jpg;*.jpeg;*.png|ËùÓÐÎļþ|*.*";
pictureBox1.SizeMode = PictureBoxSizeMode.Zoom; // ͼÏñ´óС°´ÆäÔÓеĴóС±ÈÀý±»Ôö¼Ó»ò¼õС¡£
table = new DataTable();
DataColumn column = table.Columns.Add("Name", typeof(String));
table.Columns.Add("Image", typeof(Image));
table.Constraints.Add("PK", column, true);
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder();
builder.Provider = "Microsoft.Jet.OLEDB.4.0"; // "Microsoft.ACE.OLEDB.12.0"
builder.DataSource = @"|DataDirectory|\Images.mdb";
 
Ïà¹ØÎĵµ£º
½ñÌìÔÚÐÞ¸ÄÒÔǰ¿ª·¢µÄÒ»¸öÍøÕ¾µÄʱºòÓöµ½Ò»¸öÎÊÌ⣬ÒòΪ¹¦ÄܵÄÐèÒª£¬ÒÔǰµÄÒ»¸öÊý×ÖÀàÐÍ×ֶθıäΪÎı¾×ֶΣ¬ÒòΪÕâ¸ö×Ö¶ÎÐèÒª°üº¬¶à¸öÀà±ðµÄID£¬ÒÔǰÕâ¸ö×Ö¶ÎÖ»¶ÔÓ¦Ò»¸öIDµÄ¡£
ÍøÕ¾ÊÇASP VBÓïÑԵģ¬Êý¾Ý¿âʹÓõÄÊÇAccess
ÐÞ¸ÄÊý¾ÝÀàÐÍÖ®ºóǰ̨µÄ²éѯ´úÂë¾Í²»ÄÜʹÓÃÖîÈçxID=1ÕâÖÖÌõ¼þÁË¡£ÓÉÓÚÏÖÔÚ¸Ã×ֶαäΪÎı¾ÀàÐ ......
½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬ ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
ÔÚÉè¼ÆaccessÊý¾Ý¿âʱ£¬±íÖÐ×Ö¶ÎÊôÐÔÓÐidÏîÉèΪ×Ô¶¯±àºÅÀàÐ͵ģ¬Ìí¼ÓÐí¶à¼Ç¼ºó£¬ÔڸñíÖн«ËùÓмǼɾ³ý£¬ÔÙÐÂÔö¼Ç¼²¢²»»á´Ó1¿ªÊ¼,ÈçºÎ²Ù×÷¿ÉÒÔʹÐÂÔö¼Ç¼±àºÅÖØÐ´Ó1¼ÆÊý£¿
½â¾ö·½·¨£ºÉ¾³ý±íÀïËùÓÐÊý¾Ý È»ºóѹËõÐÞ¸´Êý¾Ý¿â ÔÙÐÂÔö¾Í´Ó1±àºÅÁË
×¢:
2000-2003ѹËõÐÞ¸´Êý¾Ý¿âµã»÷:¹¤¾ß ......
1.Asc
˵Ã÷:·µ»Ø×ÖĸµÄAcsiiÖµ
¾ÙÀý:select Asc("A")·µ»Ø65
2.Chr
˵Ã÷:½«asciiֵת»»µ½×Ö·û
¾ÙÀý:select chr(65)·µ»Ø"A"
3.Format
˵Ã÷:¸ñʽ»¯×Ö·û´®
¾ÙÀý:Select Format(now(),"yyyy-mm-dd")·µ»ØÀàËÆÓÚ"2008-04-03"
&n ......