ÓÃRDA ·½Ê½Í¬²½SQLCE ÓëSQL SERVER Êý¾Ý¿â
´úÂëÊÇÍøÉϸãµÄ£¬Ó¦¸ÃûÎÊÌâ¡£×îºóÔËÐеÄʱºò´íÎóÌáʾΪ¿Õ£¬µ«ÊÇÌáʾpullÀïÓдíµÄ£¬issÅäÖÃÊÇÕýÈ·µÄ¡£ÎÒ¹À¼ÆÊÇÎÒÔÚµçÄÔÉÏÊý¾Ý¿â½¨´íÁË£¬ÓÐûÓÐÈËÅöµ½¹ýÕâÎÊÌâ
´ò¿ªÆóÒµ¹ÜÀíÆ÷,´´½¨Ò»¸öÐÂÊý¾Ý¿â,ÃûΪ¡°ABC¡±,ÔÚ¡°ABC¡±Ï´´½¨Ò»¸öÊý¾Ý±í,ÕâÀïµÄÊý¾Ý¿âÊÇʲôÀàÐ͵ÄÊý¾Ý¿â£¿
if (File.Exists(dbPathName))
File.Delete(dbPathName);
string strCon = "Data Source =" + dbPathName + ";Password=";
SqlCeEngine engine = new SqlCeEngine(strCon);
engine.CreateDatabase();
engine.Dispose();
SqlCeRemoteDataAccess rda = null;
//SQL Server ËùÔÚµÄÖ÷»úµÄIP
string remoteIP = "172.16.108.61";
//SQL Server ÖеÄÊý¾Ý¿â,ÃûΪABC
string remoteDB = "abc";
// Êý¾Ý¿âABC µÄÓû§ºÍÃÜÂë
string user = "sa";
string pwd = "123456";
&nbs
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©
ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......