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
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......