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

ʹÓÃasp.net 2.0ÖеÄSqlBulkCopyÀàÅúÁ¿¸´ÖÆÊý¾Ý

½éÉÜ£º
ÔÚÈí¼þ¿ª·¢ÖУ¬°ÑÊý¾Ý´ÓÒ»¸öµØ·½¸´ÖƵ½ÁíÒ»¸öµØ·½ÊÇÒ»¸öÆÕ±éµÄÓ¦ÓᣠÔںܶ಻ͬµÄ³¡ºÏ¶¼»áÖ´ÐÐÕâ¸ö²Ù×÷£¬°üÀ¨¾Éϵͳµ½ÐÂϵͳµÄÒÆÖ²£¬´Ó²»Í¬µÄÊý¾Ý¿â±¸·ÝÊý¾ÝºÍÊÕ¼¯Êý¾Ý¡£ ASP.NET 2.0ÓÐÒ»¸öSqlBulkCopyÀ࣬Ëü¿ÉÒÔ°ïÖúÄã´Ó²»Í¬µÄÊý¾ÝÔ´¸´ÖÆÊý¾Ýµ½SQL SERVERÊý¾Ý¿â¡£ ±¾ÎÄÖÐÎÒ½«Ê¾·¶SqlBulkCopyÀàµÄ²»Í¬Ó¦Óá£
Êý¾Ý¿âÉè¼Æ£º
Õâ¸öÊý¾Ý¿âµÄÉè¼Æ»¹ÊÇÂù¼òµ¥µÄ£¬Ëü»ùÓÚNorthwindÊý¾Ý¿âµÄProducts±í¡£ÁíÍâÎÒ»¹ÔÚNorthwindÊý¾Ý¿âÖд´½¨ÁË3¸ö±í¡£ ÏêÇé¿ÉÒÔ¿´Ò»ÏÂÏÂÃæµÄÊý¾Ý¿â¹ØÏµÍ¼¡£
Products_Archive ºÍProducts_LatestÓÐÓëProducts±íÏàͬµÄ½á¹¹£¬¶øProducts_TopSelling±íÔòÓëËüÃDz»Í¬¡£ ÉÔºóÎÒ½«ÔÚ±¾ÎĽâÊÍProducts_TopSelling±íµÄÓÃ;¡£
Products_Archive±í°üº¬770,000ÐС£ Äã²»ÓùÜÕâЩÊý¾ÝÊÇÈçºÎµÃµ½µÄ£¬ÄãÖ»ÐèÒª¿¼ÂÇÈçºÎ°ÑËùÓÐÕâЩÊý¾Ý¸´ÖƵ½Products_Latest±íÀï¡£
´ÓProducts_Archive±í ¸´ÖÆÊý¾Ýµ½ Products_Latest±í£º
SqlBulkCopy °üº¬Ò»¸ö·½·¨ WriteToServer£¬ËüÓÃÀ´´ÓÊý¾ÝµÄÔ´¸´ÖÆÊý¾Ýµ½Êý¾ÝµÄÄ¿µÄµØ¡£ WriteToServer·½·¨¿ÉÒÔ´¦ÀíµÄÊý¾ÝÀàÐÍÓÐDataRow[]Êý×飬DataTable ºÍ DataReader¡£ Äã¿ÉÒÔ¸ù¾Ý²»Í¬µÄÇéÐÎʹÓò»Í¬µÄÊý¾ÝÀàÐÍ£¬µ«ÊǸü¶àʱºòÑ¡ÔñDataReaderÊÇÒ»¸ö±È½ÏºÃµÄÖ÷Òâ¡£ ÕâÊÇÒòΪDataReaderÊÇÒ»¸öÖ»ÏòǰµÄ¡¢Ö»¶ÁµÄÊý¾ÝÁ÷£¬Ëü²»»á±£´æÊý¾Ý£¬ËùÒÔÒª±ÈDataTable ºÍ DataRows[]¶¼Òª¿ì¡£ ÏÂÃæµÄ´úÂëµÄ×÷ÓÃÊǰÑÊý¾Ý´ÓÔ´±í¸´ÖƵ½Ä¿µÄ±í¡£
private static void PerformBulkCopy()
{
string connectionString = @"Server=localhost;Database=Northwind;Trusted_Connection=true";

// Ô´
using (SqlConnection sourceConnection = new SqlConnection(connectionString))
{
SqlCommand myCommand = new SqlCommand("SELECT * from Products_Archive", sourceConnection);
sourceConnection.Open();
SqlDataReader reader = myCommand.ExecuteReader();

// Ä¿µÄ
using (SqlConnection destinationConnection = new SqlConnection(connectionString))
{
// ´ò¿ªÁ¬½Ó
destinationConnection.Open();

using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection.ConnectionString))
{
bulkCopy.BatchSize = 500;
bulkCopy.NotifyAfter = 1000;
bulkCo


Ïà¹ØÎĵµ£º

ASP.NETʹÓÃRequest»ñÈ¡À´Ô´ÍøÖ·URL²ÎÊý

Request¶ÔÏó¹¦ÄÜÊÇ´Ó¿Í»§¶ËµÃµ½Êý¾Ý£¬³£ÓõÄÈýÖÖÈ¡µÃÊý¾ÝµÄ·½·¨ÊÇ£ºRequest.Form¡¢Request.QueryString£¬Request¡£ÆäµÚÈýÖÖÊÇǰÁ½ÖÖµÄÒ»¸öËõд£¬¿ÉÒÔÈ¡´úǰÁ½ÖÖÇé¿ö¡£¶øÇ°Á½ÖÖÖ÷Òª¶ÔÓ¦µÄFormÌύʱµÄÁ½ÖÖ²»Í¬µÄÌá½»·½·¨£º·Ö±ðÊÇPost·½·¨ºÍGet·½·¨¡£
        Request ¶ÔÏóµÄÊôÐԺͷ½·¨± ......

asp.netÎÊÌ⣬Çë½Ì£¬¼±£¡£¡£¡

asp.net  »ùÓÚvb¡£net±à³ÌÓïÑÔ   sqlÊý¾Ý¿â
±í1                                         ......

asp.netÖÐÈÝÒ×»ìÏýµÄajax¸ÅÄî


AJAXÊÇAsynchronous JavaScript and XMLËõд¡£Õâ¸ö¸ÅÄî´ú±íµÄÊÇÒ»ÖÖ¼¼Êõ£¬µ±ÄúÔÚ˵“ÎÒÔÚÏîÄ¿ÖÐʹÓÃÁËAJAX¼¼Êõʱ”£¬Ö»ÊÇ´ú±íÁËÄúʹÓÿͻ§¶ËXMLHttpRequest¶ÔÏóÓë·þÎñÆ÷¶Ë½øÐÐÒ첽ͨÐÅ¡£²»¹ýÒòÎªËæ×ÅAJAX¼¼ÊõµÄÔËÓÃÍùÍù»á´øÀ´·á¸»µÄ¿Í»§¶ËЧ¹û£¬Òò´Ë¶ÔAJAX¼¼ÊõµÄ¹ãÒåÀí½âÒ²¿ÉÒÔÈÏΪÕâÊÇÒ»ÖÖ²Ù×÷ ......

asp.netÖÐ×öÊÓÆµ×ª»»£¬½«¸÷ÖÖÊÓÆµÎļþת»»³É.flv¸ñʽ

asp.netÖÐ×öÊÓÆµ×ª»»£¬½«¸÷ÖÖÊÓÆµÎļþת»»³É.flv¸ñʽ ×öÒ»¸öÊÓÆµ×ª»»µÄDemo,ÏÖÔÚ³öÏֺܵÄÍøÉÏÔÚÏßÊÓÆµÆäÎļþ¸ñʽ¶¼ÊÇ.FLV¸ñʽ£¬ÄÇЩÊÓÆµÍøÕ¾´ó¸ÅÒ²ÓÐÒ»¸öÊÓÆµ×ª»»Èí¼þ£¬ËùÎÒÔÚÒ²ÊÔ×ÅÈ¥×öÁËÒ»¸ödemoÄóöÀ´ºÍ´ó¼Ò¹²Ïíһϣ¬ÓÉÓÚ×Ô¼ºµÄ¼¼ÊõÓÐÏÞ£¬×öµÄ²»ÔõôÑù£¬Ô¸ÓиßÈË¿´Íê¸ø
ÔÚÏÂÖ¸µãÒ»¶þ. ºÇ....¡¡·Ñ»°²»¶à˵ÁË£¬ÏÂÃæÀ´·Ö½ ......

asp.net Ôö¼Ó²¥·Å¿Ø¼þ&²¥·ÅÊÓÆµÎļþ

asp.net Ôö¼Ó²¥·Å¿Ø¼þ&²¥·ÅÊÓÆµÎļþ2009-11-02 13:59/// <summary>//°ó¶¨ÊÓÆµ²¥·Å
    /// °ó¶¨ÊÓÆµ²¥·Å
    /// </summary>
    /// <param name="width">²¥·ÅÆ÷¿í¶È</param>
    /// <param name="height">²¥·ÅÆ÷¸ß¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ