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

c#ÈçºÎ·ÃÎʾÖÓòÍøÖеÄsqlÊý¾Ý¿â

ÓÐÒ»¸öc#³ÌÐò£¬Ô­À´±à³ÌµÄʱºòÉ趨·ÃÎʱ¾»úµÄsql serverÊý¾Ý¿â
app.configÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="try.Properties.Settings.abcdConnectionString" connectionString="Data Source=127.0.0.1;Initial Catalog=abcd;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

·ÃÎÊÊý¾Ý¿âʱʹÓÃÈçÏÂÓï¾ä£º
String MySQLConnectionString = global::try.Properties.Settings.Default.abcdConnectionString;
SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
MyConnection.Open();

ÏÖÔÚ°ÑÕâ¸ö³ÌÐòÄõ½²»ÊÇÊý¾Ý¿â·þÎñÆ÷µÄ»úÉÏÓã¬ÇëÎÊÓ¦¸ÃÈçºÎÐÞ¸ÄÕâ¸ö³ÌÐò£¬Ê¹ËüÄܹ»Í¨¹ý¾ÖÓòÍø·ÃÎÊÊý¾Ý¿â·þÎñÆ÷ÉϵÄSql ServerÊý¾Ý¿â£¿



connectionString="Data Source=Éè³ÉÄãµÄip;

¿ÉÒÔÔÚÃüÁîÐÐÌáʾ·ûÏÂÊäÈëipconfig²é¿´

Data Source=127.0.0.1

¸ÄΪ:ËùÒª·ÃÎʵÄÊý¾Ý¿â·þÎñÆ÷IP

ÆäËüµÄÓû§ÃûÃÜÂëºËʵһϾÍOK.



connectionString="Data Source=Êý¾Ý¿â·þÎñÆ÷µÄip;

connectionString="Data Source=192.168.*.*;Initi


Ïà¹ØÎÊ´ð£º

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ