Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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";
          


Ïà¹ØÎĵµ£º

SqlserverÓëaccessÊý¾Ý¿âsqlÓ﷨ʮ´ó²îÒì

ÊÀʶ´Ã÷½ÔѧÎÊ£¬ÈËÇéÁ·´ï¼´ÎÄÕ¡£×öASPʱ£¬×î³£ÓõÄÊý¾Ý¿â¼´SqlserverÓëAccessÊý¾Ý¿âĪÊôÁË£¡
µ«Ê¹Óûᾭ³£·¢ÏֺܶàSQLÖ´ÐеÄÎÊÌâ¡£ÕâÀïÕûÀí³öÖ®¼äµÄ²îÒ죬×ö¸öÊ®´ó²îÒìµÄ×ܽᡣ
ACCESS½á¹¹¼òµ¥ÈÝÒ×´¦Àí£¬¶øÇÒÒ²ÄÜÂú×ã¶àÊýµÄÍøÕ¾³ÌÐòÒªÇó£¬Ò²ÊdzõѧÕßµÄÊÔÅ£µ¶¡£
ACCESSÊÇСÐÍÊý¾Ý¿â£¬¼ÈÈ»ÊÇСÐ;ÍÓÐËû¸ù±¾µÄ¾ÖÏÞÐÔ£º
......

µÃµ½access±í×Ö¶ÎÃûVBS½Å±¾

 
set adoCN   =createobject("ADODB.CONNECTION")
set strCnn  =createobject("ADODB.Recordset")    
set rstSchema   =createobject("ADODB.Recordset")
  Dim   I   
dim n
        str1 ......

SQL SERVERÓëACCESS,EXCELµÄÊý¾Ýת»»

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......

Access×Ô¶¯±àºÅ×Ö¶ÎÖØÐ¼ÆÊýÎÊÌâ

  ÔÚÉè¼ÆaccessÊý¾Ý¿âʱ£¬±íÖÐ×Ö¶ÎÊôÐÔÓÐidÏîÉèΪ×Ô¶¯±àºÅÀàÐ͵ģ¬Ìí¼ÓÐí¶à¼Ç¼ºó£¬ÔڸñíÖн«ËùÓмǼɾ³ý£¬ÔÙÐÂÔö¼Ç¼²¢²»»á´Ó1¿ªÊ¼,ÈçºÎ²Ù×÷¿ÉÒÔʹÐÂÔö¼Ç¼±àºÅÖØÐ´Ó1¼ÆÊý£¿
 
½â¾ö·½·¨£ºÉ¾³ý±íÀïËùÓÐÊý¾Ý  È»ºóѹËõÐÞ¸´Êý¾Ý¿â  ÔÙÐÂÔö¾Í´Ó1±àºÅÁË
×¢:
 2000-2003ѹËõÐÞ¸´Êý¾Ý¿âµã»÷:¹¤¾ß ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ