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

C#Á¬½ÓSQLÊý¾Ý¿âÁ¬²»ÉÏ£¿

SqlConnection conn = new SqlConnection("server = (local)\\sqlexpress;integrated security = SSPI;database = Northwind");
            conn.Open();
Á¬½Ó²»ÉÏ£¬Ìáʾ£º

Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'hp-326-PC\hp-326'.
³õѧ£¬ÇëÖ¸µã
Óû§ÃûºÍÃÜÂëûÓÐ

SqlConnection conn = new SqlConnection(
"Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;");

ÕÒµ½loginµÄusertºÍpsssword,²¹Éϼ´¿É¡£

requested by the login. The login failed
ÒªÇóµÇ½,µ«µÇ½ʧ°Ü.
NorthwindÒ»°ãÊÇûÓÐÓÃÃÜÂëµÄ


        string conn = System.Configuration.ConfigurationManager.ConnectionStrings["ÄãµÄÁ¬½Ó×Ö·û´®"].ToString();


http://blog.csdn.net/clzdl/archive/2009/07/10/4338284.aspx

SqlConnection conn = new SqlConnection("server = (local)\\sqlexpress;database = Northwind" uid=sa; pwd=123);

uid ÊǵǽÃû
pwd ÊÇÃÜÂë

ÊÔһϿÉÒÔ²»


»òÕßÓÃsql×Ô¼º´øµÄĬÈϵÄÕË»§Á¬½ÓÒ²¿ÉÒԵģ¡

uid
pwd
¿ÉÄÜÄãÁ¬½ÓÊý¾Ý¿âÊÇûÓÐдÃÜÂëºÍÓû§¡£

ÄãÓÃvsÀïÃæµÄServer ExplorerÁ¬½ÓÒ»ÏÂÊý¾Ý¿âµÄ£¬Èç¹ûÄÜÁ¬ÉÏ£¬°ÑÁ¬½Ó×Ö·û´®¿½Ò»ÏµľͿÉÒÔÁË

¿ÉÄÜÄãÁ¬½ÓÊý¾Ý¿âÊÇûÓÐдÃÜÂëºÍÓû§¡£

»òÕßÊÇsqlexpress·þÎñδÆô¶¯

ÓûìºÏģʽ ×Ö·û´®ÊÇ


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

ÇóÒ»Ìõoracle¶à±í²éѯµÄsql£¬Çó¸ßÊÖÃDz»ÁߴͽÌ~

table1:
uID    uName
1      СÀî 
2      СÕÅ

table2:
pID  uID  type
1    1    H1
2    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ