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

AccessÊý¾Ý¿âÔÚC#.netϵĴ洢·¾¶ÎÊÌâ

¼´Ê¹ÎÒ½«Êý¾Ý¿â·ÅÔÚÏîÄ¿ÄÚ½¨µÄÎļþ¼ÐdbÏ£¬¿ÉÊǽøÐд洢²Ù×÷µÄʱºò£¬Êý¾Ý±íûÓÐÈκα仯¡£ºóÀ´·¢ÏÖ´¢´æ¸Ä±ä·¢ÉúÔÚbin\\debug\\dbĿ¼ÏµÄÊý¾Ý¿âÖУ¬Õâ¸öÊý¾Ý¿âÊÇÔÚ³ÌÐòÔËÐÐʱ×Ô¶¯¸´ÖƹýÈ¥µÄ£¬¿ÉÊÇΪʲô´æ´¢±ä»¯Ã»Óз´Ó¦µ½ÍâÃæÏîÄ¿ÄÚµÄÊý¾Ý¿âdbÏÂÄØ£¿ÎÒÏëÁ¬½Ó×Ö·û´®ÖÐdatasourceÖеÄdatadirectory´æÔÚһЩÐþ»ú£¬ÓÚÊÇÎÒÕÒµ½Ò»¸ö¸Ä±ä´æ´¢Â·¾¶µÄ·½·¨£¬ÒÔʵÏÖ¶ÔÊý¾Ý¿â²Ù×÷ÄÜÂäʵµ½ÄãÖ¸¶¨µÄÏîÄ¿Êý¾Ý¿âÎļþÖС£
        //¸Ä±äÊý¾Ý¿â´æ´¢Â·¾¶
¡¡¡¡ string p = AppDomain.CurrentDomain.BaseDirectory;//»ñÈ¡²Ù×÷µÄÖ±½Ó·¾¶
¡¡¡¡ //ÖØÐ¶¨Î»Êý¾Ý¿â
¡¡¡¡ if (p.IndexOf("\\bin\\") > 0)
¡¡¡¡ {
¡¡¡¡       if (p.EndsWith("\\bin\\Debug\\"))
¡¡¡¡       p = p.Replace("\\bin\\Debug", "");
¡¡¡¡       if (p.EndsWith("\\bin\\Release\\"))
¡¡¡¡       p = p.Replace("\\bin\\Release", "");
¡¡¡¡ }
¡¡¡¡ if (!p.EndsWith("App_Data\\"))
¡¡¡¡       p = p + "db\\";
¡¡¡¡       p = p + "App_Data\\";//ÕâÀï¿ÉÒÔÖ¸¶¨ÏîÄ¿Êý¾Ý¿âÎļþ¼ÐÃû
¡¡¡¡ AppDomain.CurrentDomain.SetData("DataDirectory", p);
¡¡¡¡ Application.EnableVisualStyles();
¡¡¡¡ Application.SetCompatibleTextRenderingDefault(false);
¡¡¡¡Æäʵ×îºóbin\\debug\\dbÏ»¹ÊÇ»áÓÐÒ»·ÝÊý¾Ý¿âÎļþ£¬µ«ÊǽøÐеIJÙ×÷¿ÉÒÔÂäʵ·´Ó¦µ½ÍâÃæÏîÄ¿ÀïÊý¾Ý¿âÎļþÁË¡£App.configÎļþÀïµÄÁ¬½Ó×Ö·û´®Îª£ºconnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Êý¾Ý¿âÃû.mdb"
¡£


Ïà¹ØÎĵµ£º

C#·¢ËÍÓʼþ´úÂë £¨B/S¡¢C/S½Ô¿ÉÓã©

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using  ......

C# ASP.NET »ñÈ¡½Å±¾Óï¾ä²¢ÓÃÎı¾µÄ·½Ê½ÏÔʾ³öÀ´

protected void Button6_Click(object sender, EventArgs e)
    {
        this.Label11.Text = HtmlEncode(this.TextBox3.Text);
 
       
    }
    protected static string HtmlEn ......

C#µ÷ÓÃSQL´æ´¢¹ý³ÌÒÔ¼°·µ»ØÖµºÍ²ÎÊýµÄ»ñÈ¡

QZone Editor
.dump{}

//TODO ÓòÃû
if (location.hash) {
document.domain=location.hash.substr(1);
}

//parent.qZEditor.callback();
function init(){
//»ñÈ¡±à¼­Æ÷Ãæ°åID
var pid = frameElement.panelID;

//»ñÈ¡±à¼­Æ÷Ãæ°å¶ÔÏó ......

½«accessµ¼ÈëSQL server

Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ  czdImport Dat ......

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

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