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·þÎñδÆô¶¯
ÓûìºÏģʽ ×Ö·û´®ÊÇ
Ïà¹ØÎÊ´ð£º
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2   ......
СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......
ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE
ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......
ÏÖÔÚÓÐa1,a2Á½±í
a1
id name aa cc
001 aaaa bbb cc
002 bbb bbb bbb
003 ccc ccc ccc
004 ddd ddd ddd
005 eee eee eee
a2
id ida2 ff b ......