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

C#Êý¾Ý¿â±à³Ì»ù´¡Ö®sqlÓï¾ä²Ù×÷Êý¾Ý¿âÊý¾Ý

        Á¬½Ósql serverÊý¾Ý¿âÓõ½µÄÃüÃû¿Õ¼äÊÇusing System.Data.SqlClient;
  Êý¾Ý¿âÁ¬½Ó´úÂë:¿ÉÒÔÔÚ´óÀàÖ®ÏÂÉùÃ÷ public SqlConnection myConnection;  //sqlÁ¬½Ó¶ÔÏó
                                    public  SqlCommand myCmd;  //ÓÃÓÚ´æ´¢sqlÓï¾äµÄ¶ÔÏó
        ÁíÒ»ÖÖ¶ÁÈ¡¶ÔÏóÊÇdataset     public SqlDataReader myreader; //ÓÃÓÚ¶ÁÈ¡Êý¾Ý¿âµÄ¶ÔÏó
   SqlConnection myConnection;µÄÓ÷¨ÊÇÔÚÆä¹¹Ô캯ÊýÄÚÖ¸Ã÷Á¬½Ó×Ö·û´®
    myConnection = new SqlConnection("Á¬½Ó×Ö·û´®");
   ¿ÉÒÔÓÃÅäÖÃÎļþÀ´±£´æ¸ÃÁ´½ÓÎļþ,ÕâÑù¼´±ã¸ü»»SQL SERVERÊý¾Ý¿âµÄ·þÎñÆ÷,Ö»ÒªÔÚ½â¾ö·½°¸Àï¸Ä±äÅäÖÃÎļþapp.configÀïµÄÁ¬½Ó×Ö·û´®¾Í¿ÉÒÔÁË¡£¾ßÌåµÄ²Ù×÷ÊÇ:ÔÚVSÖÐË«»÷ÊôÐÔ,ÔÚ³öÏֵĶԻ°¿òÖÐÑ¡"ÉèÖÃ",ÔÚÀïÃæÌîºÃ"Ãû³Æ","ÀàÐÍ","Öµ"¡£Òª¼ÇסÄãÌíµÄÃû³Æ£¨¼ÙÉèΪconnectionstring£©¡£ÔÙÔÚ´úÂëÖÐÉùÃ÷Ò»¸ö×Ö·û´®±äÁ¿str,¸øËû¸³ÖµÎª:Properties.Settings.Default.connectionstring;È»ºó myConnection = new SqlConnection("str"); myConnection.Open(); ¾Í¿ÉÒÔÁ¬½ÓÊý¾Ý¿âÁË¡£
   SqlCommand myCmd; µÄÓ÷¨ÊÇÔÚÆä¹¹Ô캯ÊýÄÚд³ösqlÓï¾äºÍÁ¬½Ó×Ö·û´®¶ÔÏó
    myCmd = new SqlCommand("sqlÓï¾ä",myConnection);
   ÕâÖ»ÊÇ´æ´¢sqlÓï¾ä,»¹Ã»ÓаÑËü½»¸øÊý¾Ý¿â´¦Àí,Òª½»¸øÊý¾Ý¿â´¦Àí¿ÉÒÔÓà myCmd.ExecuteNonQuery();¸Ã·½·¨ÊÇÖ´ÐÐmyCmdÄÚµÄsqlÓï¾ä,²¢·µ»ØintÐ͵ÄÊÜÓ°ÏìµÄÐÐÊý, ¸ü¶àÓõÄÊÇ SqlDataReader myreader¶ÁÈ¡Êý¾Ý¿âµÄ¶ÔÏó.
   SqlDataReader myreader;  Ö»ÄÜͨ¹ýSqlCommand myCmdµÄExecuteReader()´´½¨ÊµÀý Ó÷¨ÊÇ:
   myreader = myCmd.ExecuteReader();  ´´½¨ SqlDataReaderʵÀýµÄͬʱ,ÏòÊý¾Ý¿âÌá½»ÁËsqlÓï¾ä
   ÓÃSELECTÓï¾ä²éѯÊý¾Ýºó¿ÉÒÔÓÃmyreader.Read()À´ÅжÏÊý¾Ý¿âÖÐÓÐûÓÐÒª²éѯµÄÊý¾Ý£¬¸Ã·½·¨·µ»ØµÄÊÇÒ»¸ö²¼¶ûÀàÐÍ,Èç¹ûmyreader.Read()·µ»Øtrue˵Ã÷Êý¾Ý¿âÖÐÓÐÒª²éѯµÄÊý¾Ý,·´Ö®,˵Ã÷Êý¾Ý¿âÖÐûÓÐÒª²éѯµÄÊý¾Ý¡£Èç¹û²éѯ


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

Pro*C ÖÐǶÈëpl/sql¿é

/* °üº¬CÍ·Îļþ */
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
/* °üº¬SQLCAÍ·Îļþ */
EXEC SQL INCLUDE sqlca;
EXEC SQL INCLUDE sqlda;
int main()
{
    EXEC SQL BEGIN DECLARE SECTION;
    int  money;
    ......

ÈçºÎʵÏÖÁ½¸ösqlÊý¾Ý¿â»¥Ïàͬ²½

Ó¦Óû·¾³¾ÍÊdzÌÐòÔÚÁ½¸öµØµãÔËÐеģ¬Á½±ß¶¼Òª²Ù×÷ÐÞ¸ÄÊý¾Ý£¬Á½µØÍ¨¹ý²¦ºÅÁ¬½Ó£¬ÊÇÓÃsql2000·½±ã£¬»¹ÊÇ2005·½±ã£¬ÓÃ2̨»úÆ÷¾Í¿ÉÒÔ»¹ÊÇ3̨»úÆ÷£¬Óô¥·¢Æ÷»¹ÊDZðµÄ·½·¨ÊµÏÖ£¿SQL codeÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆÎªÀý£©
ÔËÐÐÆ½Ì¨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜ ......

SQLÓï¾äÓÅ»¯¼¼Êõ·ÖÎö

SQLÓï¾äÓÅ»¯¼¼Êõ·ÖÎö
·­Ò룺Jerry [2005-11-11]
Ô­Îijö´¦£ºhttp://www.51testing.com
Ô­ÎÄ×÷Õߣº²»Ïê
×ªÔØÇë×¢Ã÷£ºÀ´×ÔSawinϵͳ·ÖÎöÖ®´°
²Ù×÷·ûÓÅ»¯
IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵쬴ÓORACLEÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃI ......

sql ÖÐ case when Óï·¨

sqlÓïÑÔÖÐÓÐûÓÐÀàËÆCÓïÑÔÖеÄswitch caseµÄÓï¾ä£¿£¿
  ûÓÐ,ÓÃcase   when   À´´úÌæ¾ÍÐÐÁË.   
       
  ÀýÈç,ÏÂÃæµÄÓï¾äÏÔʾÖÐÎÄÄêÔ  
   
  select   getdate()   as   ÈÕÆÚ,case   month(get ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ