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

±£´æÎļþµ½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ÊÇʲô¶«Î÷£¿£¿£¿£¿ ¿´²»¶®

ÒýÓÃ
@fileÊDzÎÊý
insert into "+tableName+"("+fieldName+") values(@file)
Öж¨ÒåµÄ

ÊÇÊý¾Ý±íÖеÄ×Ö¶ÎÃû×Ö»¹ÊdzÌÐòÖж¨ÒåµÄ±äÁ¿£¿

ÊÇʲôÀàÐ͵İ¡£¿

ÒýÓÃ
ÒýÓà 1 Â¥ net_lover µÄ»Ø¸´:
@fileÊDzÎÊý
insert into "+tableName+"("+fieldName+") values(@file)
Öж¨ÒåµÄ

ÊÇÊý¾Ý±íÖеÄ×Ö¶ÎÃû×Ö»¹ÊdzÌÐòÖж¨ÒåµÄ±äÁ¿£¿

³ÌÐòÖж¨ÒåµÄ

ÒýÓÃ
ÊÇʲôÀàÐ͵İ¡£¿

×Ö·û´®ÀàÐÍ

ÒýÓÃ
ÒýÓà 3 Â¥ owlcity µÄ»Ø¸´:
ÊÇʲôÀàÐ͵İ¡£¿

×Ö·û´®ÀàÐÍ


... ²»ºÃÒâ˼£¬Ë¢ÐÂÂýÁË¡£Ì


Ïà¹ØÎÊ´ð£º

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

linux²»ÄÜ·ÃÎÊaccess - Java / Java EE

rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬Ë­ÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿

AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿

Java code:

static String DBDRIVER = "sun.jd ......

access ×éºÏ¿òÄ£ºý²éѯ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÓÉÓÚ×éºÏ¿òµÄÐÐÀ´Ô´Êý¾ÝºÜ¶à,ËùÒÔÎÒдÁËÒÔÏ´úÂë:
Private Sub F_NAME_Change()
  Me.F_NAME_±êÇ©.SetFocus
  Me.F_NAME.Requery
  Me.F_NAME.SetFocus
  If Nz(F_NAME) <& ......

Accessͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ