×¢²á | µÇ¼ Íü¼ÇÃÜÂ룿 51ctoÊ×Ò³ | ²©¿Í | ÂÛ̳ | ÕÐÆ¸
ÈȵãÎÄÕ ÔÚ¾ÖÓòÍøÄÚ¿ª±ÙÒ»¸öÊôÓÚ×Ô..
¡¡°ïÖú

Visual C# 2005 - ÈçºÎÀûÓóÌÐò´úÂ붯̬´æÈ¡É趨Îļþ


2006-10-13 12:55:45
°æÈ¨ÉùÃ÷£ºÔ­´´×÷Æ·£¬ÈçÐè×ªÔØ£¬ÇëÓë×÷ÕßÁªÏµ¡£·ñÔò½«×·¾¿·¨ÂÉÔðÈΡ£
Ò»°ã¶øÑÔ£¬³£ÓõÄÉ趨Îļþ¿É·ÖΪӦÓóÌÐòÉ趨ÎļþÒÔ¼°Ó¦ÓóÌÐò×é̬ÎļþÁ½ÖÖ¡£Ó¦ÓóÌÐòÉ趨ÎļþÓÃÀ´¶¯Ì¬´¢´æ»òߢȡӦÓóÌÐòµÄÊôÐÔÉ趨ÓëÆäËü×Ô¶©ÐÅÏ¢£¬ÈÃά»¤¿Í»§¶Ë¼ÆËã»úÉϵÄÓ¦ÓóÌÐòÑ¡ÏîºÍʹÓÃÕ߯«ºÃÉ趨±äµÄºÜÈÝÒס£¶øÓ¦ÓóÌÐò×é̬Îļþ´¢´æÔÚÓ¦ÓóÌÐòÏîÄ¿µÄ×é̬Îļþ app.config ÖУ¬Í¨³£°üº¬Ó¦ÓóÌÐòÌØÓеÄÉ趨ֵ£¬ÀýÈ磺ӦÓóÌÐò×é¼þϵ½á¡¢ÃÜÂë±àÒëÉ趨ÓëÆôʼÉ趨¡£
 
Visual C# ±¾Éí²¢Ã»ÓÐÌṩÀàËÆ Visual Basic ÖÐµÄ My.Setting Àà±ð¶ÔÏóÀ´´æÈ¡´¢´æ»òߢȡÉ趨µµÄÚÈÝ£¬Òò¶øÔÚ´ËÎÒÃǽ«Ê¾·¶ÈçºÎ͸¹ý³ÌÐò´úÂë´æÈ¡Á½ÖÖ²»Í¬µÄÉ趨µµÄÚÈÝ¡£
 
³ÌÐò·¶Àý 1
                       ͼ±í 1
Ê×ÏÈ£¬Èçͼ±í 1  Ëùʾ£¬ÎÒÃÇÒѾ­½«Á¬½Ó×Ö·û´®´¢´æ³ÉÒ»¸öÓ¦ÓóÌÐòÉ趨¡£ÏÖÔÚ£¬ÎÒÃÇ¿ÉÒÔÔÚ³ÌÐòÖÐʹÓà CH4.Properties.Settings Àà±ð¶ÔÏóÀ´È¡µÃ´ËÓ¦ÓóÌÐòÉ趨ÒÔ±ãÁ¬½ÓÖÁÊý¾Ý¿â¡£³ÌÐò·¶Àý CH4_DemoForm003.cs ʾ·¶ÈçºÎÍê³É´ËÏî×÷Òµ£¬×Ƚ«³ÌÐò´úÂëÁÐʾÈçÏ£º
using CH4.Properties;
...
Settings MySettings = new Settings();
using (SqlConnection cn = new SqlConnection(MySettings.LocalSQLExpressChtNorthwind))
{
 cn.Open();
...
}
 
³ÌÐò·¶Àý 2
 
½ÓÏÂÀ´£¬ÏȽ«Á¬½Ó×Ö·û´®Ó¦ÓóÌÐòÉ趨´¢´æÔÚÓ¦ÓóÌÐòÏîÄ¿µÄ×é̬Îļþ app.config ÖУ¬²¢ÄÚº¬ÓÚÒ»¶Ô ¡­ ±ê¼ÇÄÚ¡£ÒÔÎÒÃÇÏÈÇ°Ôø¾­Êµ¼Ê½¨Á¢¹ýµÄÁ¬½Ó×Ö·û´®Ó¦ÓóÌÐòÉ趨 LocalSQLExpressChtNorthwind ¶øÑÔ£¬½«»áÔÚ×é̬µµ app.config ÖÐдÈëÏÂÁÐÐÅÏ¢£º

connectionString="Data Source=(local)SQLExpress;Initial
Catalog=
±±·çóÒ×;Integrated Security=True"
  />
ÊÂʵÉÏ£¬²»ÂÛÒ»¸öÁ¬½Ó×Ö·û´®ÊÇÀûÓÃÓ¦ÓóÌÐòÉ趨Ëù½¨Á¢Òà»òÊÇ×ÔÐбàдÕߣ¬¶¼¿ÉÒÔʹÓà System.Configuration ÃüÃû¿Õ¼äÖеÄÀà±ðÀ´¼ÓÒÔ´¦Àí²¢È¡ÓÃÖ®¡£³ÌÐò·¶Àý CH4_DemoForm004.cs ¿ÌÒâÒÔ System.Configuration ÃüÃû¿Õ¼äÖÐµÄ ConnectionStringSettings Óë ConfigurationManager Àà±ðÀ´È¡µÃÁ¬½Ó×Ö·û´®Ó¦ÓóÌÐòÉ趨£¬¶ø²»Ê¹Óà CH4.Properties.Settings Àà±ð£¬×Ƚ«³ÌÐò´úÂëÁÐʾÈçÏ£º£¨×¢Ò⣺ÄúµÄ Windows Ó¦ÓóÌÐòÏîÄ¿±ØÐë¼ÓÈë¶Ô System.Configuration.dll µÄ²Î¿¼£©
using System.Configuration;
...
ConnectionStringSettings settings =
  ConfigurationManager.ConnectionStrings[
  "CH4.Properties.Settings.LocalSQLExpressChtNorthwind"]
;
if (settings != null)
{
 using (SqlConnection cn = new SqlConnection(settings.ConnectionString))
 {
  cn.Open();
  ...
 }
}

±¾Îijö×Ô ¡°ÕÂÁ¢Ãñ¡± ²©¿Í£¬×ªÔØÇëÓë×÷ÕßÁªÏµ£¡





    ÎÄÕÂÆÀÂÛ
 
 

·¢±íÆÀÂÛ

êÇ   ³Æ£º
ÑéÖ¤Â룺 ¡¡µã»÷ͼƬ¿ÉË¢ÐÂÑéÖ¤Âë¡¡¡¡²©¿Í¹ý2¼¶£¬ÎÞÐèÌîдÑéÖ¤Âë
ÄÚ   ÈÝ£º