ʹÓÃ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&
Ïà¹ØÎĵµ£º
1£© ¶àѡЧ¹û
¶àѡЧ¹ûÍêÈ«¿ÉÒÔͨ¹ý½Å±¾½øÐÐʵÏÖ¡£ÎÒÃÇÖªµÀ£¬¶àÑ¡µÄ¿Ø¼þ×îÖÕÉú³ÉÒ»¸öinputµÄHTML±êÇ©£¬ËüµÄÀàÐÍÊÇcheckbox¡£ÓÉÓÚÕâ¸öÒ³ÃæÖÐÖ»ÓÐÒ»×鸴ѡ¿ò£¬ËùÒÔʵÏÖÆðÀ´Ò²±È½Ï·½±ã£ºÎÒÃÇ¿ÉÒÔ±éÀúËùÓеÄinput±êÇ©£¬¶Ô±ÈÆätypeÊôÐÔÊDz»ÊÇcheckbox£¬Èç¹ûÊÇcheckbox£¬¾Í¸øËüÉèÖÃÏàÓ¦µÄÑ¡ÖÐ״̬¾ÍÐÐÁË¡£
´úÂëÈçÏ£º
<scri ......
ǰ̨´úÂ룺
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="articleview.aspx.cs" Inherits="articleview" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"> ......
SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
SqlCommand cmdAdd = new SqlCommand( "Community_Disc ......
ASP.NET¶ÔÇëÇó´¦ÀíµÄ¹ý³Ì£º
µ±ÇëÇóÒ»¸ö*.aspxÎļþµÄʱºò£¬Õâ¸öÇëÇó»á±»inetinfo.exe½ø³Ì½Ø»ñ£¬ËüÅжÏÎļþµÄºó׺£¨aspx£©Ö®ºó£¬½«Õâ¸öÇëÇóת½»¸øASPNET_ISAPI.dll£¬ASPNET_ISAPI.dll»áͨ¹ýhttp¹ÜµÀ£¨Http PipeLine£©½«ÇëÇó·¢Ë͸øASPNET_WP.exe½ø³Ì£¬ÔÚASPNET_WP.exe½ø³ÌÖÐͨ¹ýHttpRuntimeÀ´´¦ÀíÕâ¸öÇëÇ󣬴¦ÀíÍê±Ï½«½á¹û·µ» ......
֮ǰд¹ýһϵÁеÄExtJSµÄʹÓý̳̣¬µ«ÊÇ»ù±¾±È½ÏÁãÉ¢£¬±¾ÎÄÖ÷Òª¶ÔÆä½øÐйéÄÉ×ܽᡣϣÍû¶ÔÓÚ³õѧ»òÕ߸´Ï°extjsµÄͬÃËÃÇÓÐËù°ïÖú¡£
ÁбíÇåµ¥ÈçÏÂËùʾ£º
1¡¢ExtJSµÄʹÓ÷½·¨»ã×Ü(1)——ÅäÖúͱí¸ñ¿Ø¼þʹÓà £º
http://blog.csdn.net/rocket5725/archive/2009/09/09/4535323.aspx
2¡¢ExtJSµÄʹÓ÷½·¨»ã×Ü(2)&mdash ......