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

DataAdapter ¶ÔÏóÖеÄSQLÃüÁî

±êÇ©£ºÊý¾Ý·ÃÎÊ     ADO.NET
    DataAdapter ¶ÔÏóÖеÄSQLÃüÁî     ×¢£ºADO.NET¶ÔÏóÄ£ÐÍ ºÍ C#  Òª±È SQL ¸üÊʺϴ¦Àí¸´ÔÓÔËËã ºÍ µ¼º½Âß¼­£¨±ÈÈ磬²éÕÒÏà¹ØµÄÁíÒ»¸ö±íµÄÊý¾Ý£©
         ËùÒÔ£¬¿ÉÒÔ°ÑÊý¾ÝÌî³äµ½DataSetÖУ¬ÔÚ¿Í»§»úÉÏÖ´ÐÐÕâÖÖÂß¼­¡£
        ²é¿´SQL SELECT¡¢UPDATE¡¢INSERT ºÍ DELETEÃüÁ
    ÃüÁî¹¹½¨Æ÷(command builder)ÓÃÓÚ¸ù¾ÝSELECTÃüÁîÉú³ÉSQLÃüµÄUPDATE¡¢INSERTºÍDELETE)ÃüÁî¡£
    ¿ÉÒÔÓÃCommandBuilder¶ÔÏóµÄGetUpdateCommand()¡¢GetInsertCommand()ºÍGetDeleteCommand()·½·¨Éú³ÉÃüÁî¡£
    Àý£º
        SqlConnection thisConnection = new SqlConnection(@".........ConnectString...........");         thisConnection.Open();         SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT CustomerID from Customers", thisConnection);         SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);    //ÓÃCommand builder¹¹½¨ÃüÁî
    
        SqlCommand updateCommand = thisBuilder.GetUpdateCommand();
        Console.WriteLine(updateCommand.CommandText);    // Êä³öbuilder¹¹½¨µÄSQLÃüÁ¿ÉÒÔ¿´µ½SQLÃüÁîÊÇʲôÑùµÄ£¬
                                                               


Ïà¹ØÎĵµ£º

SQLÕù°ÔÈüÊÔÌâ¼°²Î¿¼´ð°¸

1.ijҽԺ²¡·¿¼ÆËã»ú¹ÜÀíÖÐÐèÒªÈçÏÂÐÅÏ¢£º£¨15·Ö£©
¿ÆÊÒ£º¿ÆÃû£¬¿ÆµØÖ·£¬¿Æµç»°
²¡·¿£º²¡·¿ºÅ£¬ËùÊô¿ÆÊÒÃû
Ò½Éú£ºÐÕÃû£¬Ö°³Æ£¬ËùÊô¿ÆÊÒÃû£¬ÄêÁ䣬¹¤×÷Ö¤ºÅ
²¡ÈË£º²¡ÀúºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬Õï¶Ï£¬Ö÷¹ÜÒ½Éú£¬²¡·¿ºÅ£¬ÈëסÈÕÆÚ
ÆäÖУ¬Ò»¸ö¿ÆÊÒÓжà¸ö²¡·¿¡¢¶à¸öÒ½Éú£¬Ò»¸ö²¡·¿Ö»ÄÜÊôÓÚÒ»¸ö¿ÆÊÒ£¬Ò»¸öÒ½ÉúÖ»ÊôÓÚÒ»¸ö¿ÆÊÒ£¬µ«¿É¸º ......

ä¯ÀÀLINQ to SQL¹ØÏµ

±êÇ©£ºÊý¾Ý·ÃÎÊ     LINQ     LINQ to SQL ²¿·Ö
ä¯ÀÀLINQ to SQL¹ØÏµ      Á½¸ö¹ØÁªµÄ±í£º
 & ......

javaÓësql server 2005µÄÏà¹Ø²Ù×÷

//±¾³ÌÐòÁ¬½ÓµÄÊÇsql server 2005£¬ÓëÁ¬½Ósql server 2000Óе㲻ͬ£ºdriverNameºÍURL¶¼²»Í¬
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class create{
   public void getConnection() th ......

SQL SERVERÓëACCESS,EXCELµÄÊý¾Ýת»»

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ