±£´æÎļþµ½AccessÊý¾Ý¿âÖÐ - .NET¼¼Êõ / C#
C# code:
//±£´æÎļþµ½AccessÊý¾Ý¿âÖÐ
FileInfo fi=new FileInfo(fileName);
FileStream fs=fi.OpenRead();
byte[] bytes=new byte[fs.Length];
fs.Read(bytes,0,Convert.ToInt32(fs.Length));
OleDbCommand cm=new OleDbCommand();
cm.Connection=cn;
cm.CommandType=CommandType.Text;
if(cn.State==0) cn.Open();
cm.CommandText="insert into "+tableName+"("+fieldName+") values(@file)";
OleDbParameter spFile=new OleDbParameter("@file",OleDbType.Binary);
spFile.Value=bytes;
cm.Parameters.Add(spFile);
cm.ExecuteNonQuery()
@fileÊÇʲô¶«Î÷£¿£¿£¿£¿ ¿´²»¶®
ÊÇÊý¾Ý±íÖеÄ×Ö¶ÎÃû×Ö»¹ÊdzÌÐòÖж¨ÒåµÄ±äÁ¿£¿
ÊÇʲôÀàÐ͵İ¡£¿
³ÌÐòÖж¨ÒåµÄ
×Ö·û´®ÀàÐÍ
... ²»ºÃÒâ˼£¬Ë¢ÐÂÂýÁË¡£Ì
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
´ó¼ÒºÃ£¬ÎÒÊÇÐÂÊÖ£¬¸Õ¿ªÊ¼½Ó´¥C/S½á¹¹µÄ³ÌÐò£¬ÏëҪʵÏÖÒ»¸ö·ÖÒ³¹¦ÄÜ£¬´ó¼ÒÓÐûÓкõãµÄ·ÖÒ³¿Ø¼þ»òÕß³ÌÐòÖ®ÀàµÄ£¬µ±È»Ô´³ÌÐò¸üºÃ£¬·ñÔò˵˵Á÷³ÌÒ²¿ÉÒÔ£¬Ð¡Ãü±°¡£¬ÔÚÏߵȡ£¡£¡£¡£
´ó¼Ò°ï°ï棬лÁË£¡
×Ô¼ºÐ´Ñ½£¡
......
ÍøÉϺöà¶þ¼¶Áª¶¯µÄ£¬Ö»ÊǶ¼Ã»ÓвÉÓÃAccessÊý¾Ý¿âµÄ£¬php²»ÊìϤ£¬ÓÐÁ½¸öÊý¾Ý±í·Ö±ðΪlb(Àà±ð£º±àºÅ£¬Àà±ðÃû³Æ£©into_product(²úÆ·¹ÜÀí£ºid,Ãû³Æ£¬Àà±ðµÈ×ֶΣ©
ÏëҪʵÏÖ£ºµÚÒ»¸öÏÂÀ²Ëµ¥Ñ¡ÔñÍêÀà±ðºó£¬µÚ¶þ²Ëµ¥¾Í°Ñ ......
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<id="1">
<user="test1" pass="12345" />
& ......
Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿
¸÷ÊãÆð¼û
Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË
¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã
Â¥Ö÷Çë²ÎÔÄ
http://msdn.micr ......