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

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ØÒªµÄ¡£
¸½Â¼£


Ïà¹ØÎĵµ£º

ORACLE SQL ÓÅ»¯

http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
Çø×¨ÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......

c# ½«Ã¶¾Ù×÷Ϊ¼üÖµµÄÐÎʽ´æ´¢

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
namespace ½«Ã¶¾Ù×÷Ϊ¼üÖµµÄÐÎʽ´æ´¢
{
    enum Myenum
    {
       First=3,
       Second ......

c#¶àÏß³ÌˢнçÃæ

Õâ¸öÎÊÌâÒ²²»ÖªµÀÄѵ¹Á˶àÉÙC#ºÀ½Ü¡£±ÈÆðMFCµÄ½çÃæË¢Ð£¬ÔÚWINFORMÖÐÀ´ÊµÏÖ¶àÏß³ÌË¢ÐÂÕæÊǺÜÍ´¿à£¬¹Êд´ËÎÄ¡£
¶àÏß³ÌˢнçÃæÖ÷ÒªÓõ½¶àỊ̈߳¬Î¯ÍУ¬Ḭ̈߳²È«¡¢Ê¼þµÈһϵÁиßÄѶȵÄC#²Ù×÷¡£
¹ØÓÚίÍкÍʼþ£¬ÕâÓÐһƪºÜÒ×¶®µÄÎÄÕ£ºhi.baidu.com/anglecloudy/blog/item/a52253ee804d052f2df534ab.html
£½£½£½£½£½£½£½£½ ......

תÌû£º¾²Ì¬ÀàºÍ¾²Ì¬Àà³ÉÔ±£¨C# ±à³ÌÖ¸ÄÏ£©

Ô­ÎĵØÖ·£ºhttp://msdn.microsoft.com/zh-cn/library/79b3xss3(VS.80).aspx
    ¾²Ì¬ÀàºÍÀà³ÉÔ±ÓÃÓÚ´´½¨ÎÞÐè´´½¨ÀàµÄʵÀý¾ÍÄܹ»·ÃÎʵÄÊý¾ÝºÍº¯Êý¡£¾²Ì¬Àà³ÉÔ±¿ÉÓÃÓÚ·ÖÀë¶ÀÁ¢ÓÚÈκζÔÏó±êʶµÄÊý¾ÝºÍÐÐΪ£ºÎÞÂÛ¶ÔÏó·¢Éúʲô¸ü¸Ä£¬ÕâЩÊý¾ÝºÍº¯Êý¶¼²»»áËæÖ®±ä»¯¡£µ±ÀàÖÐûÓÐÒÀÀµ¶ÔÏó±êʶµÄÊý¾Ý»òÐÐΪʱ£¬ ......

ASP.NET/XMLÉîÈë±à³Ì¼¼Êõ

ÕâÊǹØÓÚAsp.Net/XMLÉîÈë±à³ÌµÄ¼¼ÊõÊ飬×÷Õß¾«ÐÄÉè¼ÆÁË66¸öʵÀýÏêϸ½éÉÜÁË.Net   FrameworkÒÔ¼°XML¼¼ÊõÔÚ.Net   FrameworkµÄ±à³Ì·½·¨ºÍ¼¼ÇÉ¡£È«ÊéÓÉ12Õ¹¹³É£¬ÄÚÈݰüÀ¨.Netƽ̨µÄ½¨Á¢¡¢Asp.NetµÄWeb   Forms¡¢¿Ø¼þ¡¢Êý¾Ý·ÃÎÊ¡¢Web   Service¡¢Asp.NetµÄÉèÖú͸ú×Ù¡¢Asp.NetµÄ°²È« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ