ʹÓÃ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Öе÷ÓÃEXCEL×é¼þµÄʱºò,Èç¹ûûÓÐÅäÖÃDCOMÖÐEXCELȨÏÞÎÊÌâ,½á¹û³ÌÐò»á±¨:Access is denied.
½â¾öµÄ·½·¨ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖ£¬ÔÚweb.configÖÐÉèÖÃÒ»¸ö½Úµã.
<identity impersonate="true" />
²»¹ýÕâÖÖ·½·¨Ö»Äܽâ¾ölocalµçÄÔÉϵÄExcel Access is deniedµÄÎÊÌâ
Èç¹ûÊÇ·þÎñÆ÷µÄ»°,Óпͻ§»ú·ÃÎÊÒ³ÃæµÄʱºò, ......
asp.net »ùÓÚvb¡£net±à³ÌÓïÑÔ sqlÊý¾Ý¿â
±í1 ......
´Ë´¦ÌṩµÄ´úÂëÓÃÀ´ÊµÏÖµ±asp.netÒ³ÃæÖеÄij¸öButton±»µã»÷ºódisableµô¸ÃÒ³ÃæÖÐËùÓеÄButton£¬´Ó¶ø·ÀÖ¹Ìá½»ÑÓʱµ¼ÖµĶà´ÎÌá½»¡£»ùÓÚ֮ǰµÄonceclickbutton½Å±¾.
//ASP.NETÖзÀÖ¹Ò³Ãæ¶à´ÎÌá½»µÄ´úÂë:javascript< script language=”javascript”> < !– function disableOtherSubmit() {
var obj ......
private void btnUploadPicture_Click(object sender, System.EventArgs e)
{
//¼ì²éÉÏ´«ÎļþµÄ¸ñʽÊÇ·ñÓÐЧ
if(this.UploadFile.PostedFile.ContentType.ToLower().IndexOf("image") < 0)
{
&n ......
asp.net Ôö¼Ó²¥·Å¿Ø¼þ&²¥·ÅÊÓƵÎļþ2009-11-02 13:59/// <summary>//°ó¶¨ÊÓƵ²¥·Å
/// °ó¶¨ÊÓƵ²¥·Å
/// </summary>
/// <param name="width">²¥·ÅÆ÷¿í¶È</param>
/// <param name="height">²¥·ÅÆ÷¸ß¶ ......