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

C#Á¬½ÓAccessÊý¾Ýʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ

½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ßд³Édbo.xxxTable£¬ËùÒÔÈç¹ûÄãÒªÊÇÒ²ÔÚAccessÖÐÕâÑùдµÄ»°£¬¾Í»á±¨ÈçÉÏÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£ÐÞ¸ÄSQLÓï¾ä£¬È¥µôdboºó£¬ÎÊÌâ½â¾ö¡£


Ïà¹ØÎĵµ£º

ASP.NETµÄACCESSÊý¾Ý¿â²Ù×÷Àà

//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ· 
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ· 
/// 
/// È¡µÃdataset 
// 
/// ²éѯÓï¾ä 
/// 
public DataSet GetDataSet(string Commandtext) 
{&nbs ......

EA2A(Excel/Access to Access)

Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐÆ½Ì¨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔ­ÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼Èë£¨Ç¨ÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½Ó ......

AccessÊý¾Ý¿â×Ö¶ÎÀàÐÍ˵Ã÷ÒÔ¼°ÓëSQLÖ®¼äµÄ¶ÔÕÕ¹ØÏµ

Îı¾ nvarchar(n)
±¸×¢ ntext
Êý×Ö(³¤ÕûÐÍ) int
Êý×Ö(ÕûÐÍ) smallint
Êý×Ö(µ¥¾«¶È) real
Êý×Ö(Ë«¾«¶È) float
Êý×Ö(×Ö½Ú) tinyint
»õ±Ò money
ÈÕÆÚ smalldatetime
²¼¶û bit
¸½£º×ª»»³ÉSQLµÄ½Å±¾¡£
ALTER TABLE tb ALTER COLUMN aa Byte Êý×Ö[×Ö½Ú]
ALTER TABLE tb ALTER COLUMN aa Long Êý×Ö[³¤ÕûÐÍ]
ALTER T ......

Js Öд´½¨XmlÎĵµ£¬ÓÃAjax´«µ½CsÖд¦Àí£¨C#£©

function ImportRun()
{
    if(document.all.Content.children.length>0)
 {
     var oTable=document.all.Content.children(0);
     var oFldInfo=new Array();
      var oSendDom=CreateXmlDom("<dl/>");
&nb ......

asp.netÁ´½Ósqlserver2000¡¢2005¡¢access´úÂë

Data Source=sqlservername;Initial Catalog=dbname;User ID=userid;Password=userpwd
Data Source=(local)\\SQLEXPRESS;Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;User ID=ÕʺÅ;Password=ÕʺÅÃÜÂë
Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\BegASPNET\ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ