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

ÓÃ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


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º ......

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ