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";
 
Ïà¹ØÎĵµ£º
ÎÊÌâ:
Óжþ¸ö±í
A±í:
id Comment yuyan lanmuid
1 aaaa chinese 1
2 bbbb english 1
3 cccc chinese 2
4 ddddd english 2
B±í:
id lanmu
1 ¹«Ë¾¼ò½é
2 ÁªÏµ·½Ê½
3 ¾Óª·¶Î§
ÔÚɾ³ýB±íµÄÒ»ÐÐÊý¾Ýʱ»á°ÑA±í¹ØÁªIDµÄÊý¾ÝҲɾ³ý,ÇëÎÊÓÐʲôºÃ·½·¨?ÎÒ²»Ïë²Ù×÷2´Îɾ³ýµÄÓï¾ä.
½â¾ö·½ ......
½ñÌìÔÚÐÞ¸ÄÒÔǰ¿ª·¢µÄÒ»¸öÍøÕ¾µÄʱºòÓöµ½Ò»¸öÎÊÌ⣬ÒòΪ¹¦ÄܵÄÐèÒª£¬ÒÔǰµÄÒ»¸öÊý×ÖÀàÐÍ×ֶθıäΪÎı¾×ֶΣ¬ÒòΪÕâ¸ö×Ö¶ÎÐèÒª°üº¬¶à¸öÀà±ðµÄID£¬ÒÔǰÕâ¸ö×Ö¶ÎÖ»¶ÔÓ¦Ò»¸öIDµÄ¡£
ÍøÕ¾ÊÇASP VBÓïÑԵģ¬Êý¾Ý¿âʹÓõÄÊÇAccess
ÐÞ¸ÄÊý¾ÝÀàÐÍÖ®ºóǰ̨µÄ²éѯ´úÂë¾Í²»ÄÜʹÓÃÖîÈçxID=1ÕâÖÖÌõ¼þÁË¡£ÓÉÓÚÏÖÔÚ¸Ã×ֶαäΪÎı¾ÀàÐ ......
ǰЩÌìŪһ¸ö·ÃÎÊACCESSÊý¾Ý¿âµÄС¶«Î÷£¬·ÑÁËЩÁ¦Æø²ÅŪºÃ¡£
ËäÈ»»¹ÓÐЩ²»¾¡ÈËÒ⣬µ«ÊÇÖÕ¾¿»¹ÊÇ¿ÉÒÔÓÃÁË£¬
ÔÚÕâÀï·ÖÏíÒ»ÏÂ×Ô¼ºµÄʵÏÖ·½·¨ºÍ¾Ñé¡£
ÀïÃæµÄ¶«Î÷ÍøÉ϶¼ÓУ¬µ«ÊÇ£¬ÕâÀïµÄÊÇ×îÈ«µÄ¡£
VC/MFC·ÃÎÊACCESSÊý¾Ý¿â
·½·¨1£º
1 ´´½¨Ò»¸ö»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐò¡£
·ÅÈëÁ½¸öActiveX ¿Ø¼þ Mic ......
Access SQL×¢Èë²Î¿¼
°æ±¾ 0.2.1
(×î½ü¸üР10/10/2007)
Ô×÷Õß²»Ïê
ÃèÊö SQL²éѯ¼°×¢ÊÍ
×¢ÊÍ·û AccessÖÐûÓÐרÃŵÄ×¢ÊÍ·ûºÅ.Òò´Ë"/*", "--"ºÍ"#"¶¼Ã»·¨Ê¹ÓÃ.µ«ÊÇ¿ÉÒÔʹÓÿÕ×Ö·û"NULL"(%00)´úÌæ:
' UNION SELECT 1,1,1 from validTableName%00
Óï·¨´íÎóÐÅÏ¢ "[Microsoft][Driver ODBC Micros ......
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 ......