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ÕâÖÖÌõ¼þÁË¡£ÓÉÓÚÏÖÔÚ¸Ã×ֶαäΪÎı¾ÀàÐ ......
string sql = "select a.orderId,a.UserName,b.CodeValue as Delivery ,a.DeliveryAddress,a.PhoneNum,c.CodeValue as Payment,d.CodeValue as OrderStatus,d.CodeValue as OrderStatusID,a.OrderTime,a.Merchant from (( m_Order a ";
sql += " left j ......
set adoCN =createobject("ADODB.CONNECTION")
set strCnn =createobject("ADODB.Recordset")
set rstSchema =createobject("ADODB.Recordset")
Dim I
dim n
str1 ......
×î³£¼ûµÄÊý¾ÝÀàÐÍÓ³ÉäµÄÁбí
ϱíÁгöÁËÔÚ Microsoft Access ºÍÈçºÎÕâЩÊý¾ÝÀàÐÍÓëÏà¹Ø Microsoft.net ¿ò¼ÜÊý¾ÝÀàÐÍ£¬²¢ OleDbType ö¾ÙÖÐʹÓÃ×î³£¼ûµÄÊý¾ÝÀàÐÍ¡£
ÊÕÆð¸Ã±í¸ñÕ¹¿ª¸Ã±í¸ñ
·ÃÎÊÀàÐÍÃû³Æ
Êý¾Ý¿âÊý¾ÝÀàÐÍ
OLE DB ÀàÐÍ
.NET ¿ò¼ÜÀàÐÍ
³ÉÔ±Ãû³Æ
Îı¾
VarWChar
DBTYPE_WSTR
System.String
OleDbType.V ......