C# Home / Ïê½âAsp.Net SqlÊý¾Ý¿âÁ¬½Ó×Ö·û´®
1.Á¬½ÓÊý¾Ý¿âÎļþ
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
SqlConnectionStringBuilderʵÀý»¯Ê±£¬ÒªÓõ½connectionString£¬È磺SqlConnectionStringBuild builder = new SqlConnectionStringBuild(connectionString)¡£
Ò»¡¢Data Source
SqlConnectionStringBuilderµÄDataSourceÊôÐÔ£¬¶ÔÓ¦connectionStringÖеÄData Source£¬“Data Source”¿ÉÒÔÓÉÏÂÁÐ×Ö·û´®´úÌæ£º“server”£¬“address”£¬“addr”ºÍ“network address”¡£
Data Source=.\SQLExpressÒ²¿ÉÒÔд³ÉÕâÑùData Source=(local)\SQLExpress¡£
¶þ¡¢Integrated Security
SqlConnectionStringBuilderµÄIntegratedSecurityÊôÐÔ£¬¶ÔÓ¦connectionStringÖеÄIntegrated Security£¬“Integrated Security”¿ÉÒÔд³É“trusted_connection”£¬Îªtrueʱ£¬Ê¹Óõ±Ç°µÄ Windows ÕÊ»§Æ¾¾Ý½øÐÐÉí·ÝÑéÖ¤£¬Îªfalseʱ£¬ÐèÒªÔÚÁ¬½ÓÖÐÖ¸¶¨Óû§ ID ºÍÃÜÂë¡£
Èý¡¢AttachDBFilename
SqlConnectionStringBuilderµÄAttachDBFilenameÊôÐÔ£¬¶ÔÓ¦connectionStringÖеÄAttachDBFilename£¬“AttachDBFilename”¿ÉÒÔд³É“extended properties”£¬“initial file name”¡£AttachDbFileNameÊôÐÔÖ¸¶¨Á¬½Ó´ò¿ªµÄʱºò¶¯Ì¬¸½¼Óµ½·þÎñÆ÷ÉϵÄÊý¾Ý¿âÎļþµÄλÖá£Õâ¸öÊôÐÔ¿ÉÒÔ½ÓÊÜÊý¾Ý¿âµÄÍêÕû·¾¶ºÍÏà¶Ô·¾¶£¨ÀýÈçʹÓÃ|DataDirectory|Óï·¨£©£¬ÔÚÔËÐÐʱÕâ¸ö·¾¶»á±»Ó¦ÓóÌÐòµÄApp_DataĿ¼Ëù´úÌæ¡£
ÓÐһƪÎÄÕ£¬×¨ÃŽâÊÍDataDirectoryÊÇʲô¡£
ËÄ¡¢User Instance
SqlConnectionStringBuilderµÄUserInstanceÊôÐÔ£¬¶ÔÓ¦connectionStringÖеÄUser Instance ,¸ÃֵָʾÊÇ·ñ½«Á¬½Ó´ÓĬÈ쵀 SQL Server Express ʵÀýÖØ¶¨Ïòµ½ÔÚµ÷Ó÷½ÕÊ»§Ö®ÏÂÔËÐв¢ÇÒÔÚÔËÐÐʱÆô¶¯µÄʵÀý¡£UserInstance=true£¬ÔÚÕâÖÖÇé¿öÏ£¬SQLServerExpressΪÁ˰ÑÊý¾Ý¿â¸½¼Óµ½ÐµÄʵÀý£¬½¨Á¢Ò»¸öеĽø³Ì£¬ÔÚ´ò¿ªÁ¬½ÓµÄÓû§Éí·ÝÏÂÔËÐС£ÔÚASP.NETÓ¦ÓóÌÐòÖУ¬Õâ¸öÓû§ÊDZ¾µØµÄASPNETÕʺŻòĬÈϵÄNetworkService£¬ÕâÒÀÀµÓÚ²Ù×÷ϵͳ¡£ÎªÁ˰²È«µØ¸½¼Ó·Çϵͳ¹ÜÀíÔ±Õʺţ¨ÀýÈçASP.NETÕʺţ©ÌṩµÄÊý¾Ý¿âÎļþ£¬½¨Á¢Ò»¸ö¶ÀÁ¢µÄSQLServerÓû§ÊµÀýÊDZØÒªµÄ¡£
¸½Â¼£
Ïà¹ØÎĵµ£º
ÔÚ³ÌÐòÖÐÎÒÃÇ¿ÉÄܾ³£»áÓöµ½ÕâÖÖÇé¿ö£¬±ÈÈçҪȡһ¸ölistboxÀïÃæµÄÑ¡ÔñÏµÃµ½µÄ½á¹û¿ÉÄÜÊÇstring ID="id1,id2,id3,id4",È»ºóÎÒÃÇÒª°ÑÕâЩID²åÈëµ½Êý¾Ý¿âÖУ¬Í¬Ê±Ã¿¸öid¶ÔÓ¦µÄÊÇÒª²åÈëÒ»Ìõ¼Ç¼¡£ÊµÏֵķ½·¨Óкܶ࣬µ«ÊÇÈç¹ûÎÒÃÇͨ¹ýÏÂÃæÕâ¸öº¯Êý£¨RecurrentSplit£©¾ÍÄܼòµ¥µÄ´ïµ½ ......
±¾ÊéÊÇ΢Èí¼¼ÊõÅàѵͳ±à½Ì²ÄÖ®Ò»£¬¶Ô±à³ÌÓïÑÔC#½øÐÐÁËÏêϸµÄ½éÉÜ¡£ C#ÊÇ»ùÓÚ΢ÈíÏÂÒ»´ú²Ù×÷ƽ̨£®NETµÄȫеÄÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼ÆÓïÑÔ¡£ËüÔÚ±£³ÖÁËC+ÖÐÊìϤµÄÓï·¨µÄͬʱ£¬Ìí¼ÓÁË´óÁ¿µÄ¸ßЧ´úÂëºÍÍêÈ«ÃæÏò¶ÔÏóÌØÐÔ£¬ÒÔ¼°¸ü¸ßµÄ¿É¿¿ÐԺͰ²È«ÐÔ¡£C#ÓïÑÔ½«ÔÚ±£³ÖC£¯C++Áé»îÐԵĻù´¡ÉÏΪ³ÌÐòÔ±´øÀ´¸ü¸ßЧµÄ¿ª·¢·½Ê½¡£Ëü²»½öÄÜÓÃÓ ......
´ÓContainerControlÀà¼Ì³ÐµÄ×ÓÀà×÷ΪÈÝÆ÷´°Ì壬¿ÉÒÔÈÝÄɳýFormÀà¶ÔÏóÍâµÄÆäÓà´°Ìå¶ÔÏó¡£
ÔÚËùÓÐÈÝÆ÷´°ÌåÄÚ£¬×î»ù±¾µÄ¾ÍÊǶ¥¼¶ÈÝÆ÷FormÀàÒÔ¼°Ãæ°åÈÝÆ÷PanelÀà¡£ÕâÁ½ÕßµÄÖ÷񻂿±ðΪ£ºÇ°Õß¾ßÓÐWindows±ê×¼¿ò¼Ü£¨±êÌâÀ¸£¬×î´ó»¯¡¢×îС»¯ºÍ¹Ø±Õ°´Å¥£¬´°Ìå±ß¿ò£¬¿Éµ÷Õû³ß´ç£©£¬²¢ÇÒ¿ÉÒÔ¶ÀÁ¢´æÔÚ£»ºóÕßÖ»ÊÇÒ»¿éÇøÓò£¬²¢ÇÒ±ØÐëÒÀ¸½ ......
Õâ¸öÎÊÌâÒ²²»ÖªµÀÄѵ¹Á˶àÉÙC#ºÀ½Ü¡£±ÈÆðMFCµÄ½çÃæË¢Ð£¬ÔÚWINFORMÖÐÀ´ÊµÏÖ¶àÏß³ÌË¢ÐÂÕæÊǺÜÍ´¿à£¬¹Êд´ËÎÄ¡£
¶àÏß³ÌˢнçÃæÖ÷ÒªÓõ½¶àỊ̈߳¬Î¯ÍУ¬Ḭ̈߳²È«¡¢Ê¼þµÈһϵÁиßÄѶȵÄC#²Ù×÷¡£
¹ØÓÚίÍкÍʼþ£¬ÕâÓÐһƪºÜÒ×¶®µÄÎÄÕ£ºhi.baidu.com/anglecloudy/blog/item/a52253ee804d052f2df534ab.html
£½£½£½£½£½£½£½£½ ......