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
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......
ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......