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·þÎñδÆô¶¯
ÓûìºÏģʽ ×Ö·û´®ÊÇ
Ïà¹ØÎÊ´ð£º
//C ½Ó¿Ú
extern "C"
{
TESSDLL_API int __cdecl GetTessText(const char *imagefile, char *text);
}
//ÎÒÔÚC#ÖÐÉùÃ÷
//µ÷ÓÃC DLL Öеĺ¯Êý
[DllImport("OCRapi.dll&quo ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
A±í B±í
WZID WZJG WZID CKID WZSL
ÏÖÔÚÒª²é¶ÔÓ¦µÄÿһ¸öCKIDϵÄ×ܵĽð¶î
¾ÍÊÇÏȲéÿ¸öWUIDÔÚB±íÀïµÄÊýÁ¿£¬È»ºóÓÃWZJG*sum(wzsl)£¬È»ºóÔÙ°´ÕÕÿ¸ ......