Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 µÄ»Ø¸´:
ÊÇʲôÀàÐ͵İ¡£¿

×Ö·û´®ÀàÐÍ


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


Ïà¹ØÎÊ´ð£º

±éÀúÒ»¸öxml²¢Êä³öÖ¸¶¨½ÚµãµÄÖµ - .NET¼¼Êõ / C#

ÎÒÓÐÒ»¸öÀàËƵÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
  <RequestType>DISCOVER_XML_ME ......

accessÊý¾Ý¿âÁ¬½Ó - Web ¿ª·¢ / ASP

ÎÒÁ¬½ÓaccessÊý¾Ý¿â£¬ÒÔÇ°Ò»Ö±ºÜºÃ£¬×î½üÈ´×ÜÊdzö´í£¨Êý¾Ý¿âÁ¬½Ó³ö´í!£¡£©£¬´úÂëÈçÏ£º
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&" ......

ÇóÒ»±¾C#Éè¼ÆģʽµÄÊé - .NET¼¼Êõ / C#

ÇóÒ»±¾C#Éè¼ÆģʽµÄÊé ,ÎҸоõÎҵĴúÂëÔËÓýӿÚ,ίÍÐ,ÊôÐԵĵط½ºÜÉÙ,¿Ï¶¨ÊÇÎÒµÄÉè¼Æģʽ̫²îÁË ,ÓÐûÓÐÕâ·½Ãæ,´Ó¹úÍâ·­Òë¹ýÀ´µÄ,±È½ÏºÃµÄÉè¼ÆģʽµÄÊé,ÍƼöһϰÉ,·Ç³£¸Ðл.
¸ßÈËÃÇ˵ ´úÂëÖع¹µÄÊéºÃЩ,ÄÇÎÒÒª¸Ä¿´ ......

Çë´ó¼ÒÖ¸µãÒ»ÏÂC/S½á¹¹µÄ·ÖÒ³Á÷³Ì - .NET¼¼Êõ / C#

´ó¼ÒºÃ£¬ÎÒÊÇÐÂÊÖ£¬¸Õ¿ªÊ¼½Ó´¥C/S½á¹¹µÄ³ÌÐò£¬ÏëҪʵÏÖÒ»¸ö·ÖÒ³¹¦ÄÜ£¬´ó¼ÒÓÐûÓкõãµÄ·ÖÒ³¿Ø¼þ»òÕß³ÌÐòÖ®ÀàµÄ£¬µ±È»Ô´³ÌÐò¸üºÃ£¬·ñÔò˵˵Á÷³ÌÒ²¿ÉÒÔ£¬Ð¡Ãü±°¡£¬ÔÚÏߵȡ£¡£¡£¡£
´ó¼Ò°ï°ï棬лÁË£¡

×Ô¼ºÐ´Ñ½£¡ ......

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ºÅ