ÔÚasp.net 2.0ÖÐʹÓÃSqlBulkCopyÀàÇ¨ÒÆÊý¾Ý
ÎÒÃǾ³£ÒªÔÚÒ»¸ö±íÖн«Êý¾ÝÇ¨ÒÆµ½ÁíÒ»¸ö±í£¬µ±È»£¬Óõķ½·¨Ê®·Ö¶àÁË¡£ÔÚ.net 2.0ÖУ¬ÌṩÁËÒ»¸ösqlbulkcopyÀ࣬Ҳ¿ÉÒÔʵÏÖÈçϵIJÙ×÷£¬ÏÂÃæ¼òµ¥½éÉÜÏ¡£±ÈÈçÒ»¸ö±íÈçÏÂ
CREATE TABLE Person3
(
PersonID int IDENTITY(1,1) PRIMARY KEY,
Name nvarchar(200),
Email nvarchar(200),
Picture image
)
INSERT INTO Person3(Name,Email,Picture)
SELECT Name,Email,Picture from Person
¼ÙÉèperson±íÒѾ´æÔÚÁË£¬ÔòÉÏÃæµÄÓï¾ä¿ÉÒÔÍùperson3±íÖвåÈëÊý¾Ý(ÔÚsql server 2005ÖÐÖ´ÐУ©¡£ÏÖÔÚÎÒÃÇʹÓÃÏÂÃæµÄ´úÂëÀ´ÊµÏÖ
string connectionString = ConfigurationManager.ConnectionStrings["MyDatabase"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
SqlCommand myCommand = new SqlCommand("SELECT * from Person", myConnection);
myConnection.Open();
SqlDataReader dr = myCommand.ExecuteReader();
SqlConnection myNewConnection = new SqlConnection(connectionString);
myNewConnection.Open();
SqlBulkCopy bulk = new SqlBulkCopy(myNewConnection);
bulk.DestinationTableName = "[Person3]";
try
{
bulk.WriteToServer(dr);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
myNewConnection.Close();
dr.Close();
myConnection.Close();
bulk.Close();
}
ÏÂÃæÀ´½âÎöÏ¡£Ê×ÏÈ£¬Ð½¨Ò»¸öÊý¾Ý¿âÁ¬½Ó£¬Ö®ºóÊǺܾµäµÄ´úÂëÁË£¬´Óperson±íÖÐÄóöÊý¾Ý£¬µ±µ½datareaderÖÐÈ¥¡£Ö®ºó£¬ÎÒÃÇÓÖн¨Á¢Á˸öÊý¾ÝÁ¬½Ó£¬Ö®ºó£¬Ê¹ÓÃ
SqlBulkCopy bulk = new SqlBulkCopy(myNewConnection);
bulk.DestinationTableName = "[Person3]";
ÆäÖУ¬½«mynewconnection×÷Ϊ²ÎÊý´«µ½ sqlbulkcopyÀàµÄ¹¹Ôì²ÎÊýÖÐÈ¥£¬²¢Ö¸¶¨Ä¿±êÇ¨ÒÆµÄ±íÃûÊÇperson3.
Ö®ºó£¬ÔÙʹÓÃbulk.WriteToServer(dr);¾Í¿ÉÒÔÇ¨ÒÆÁË¡£
¶øÉÏÃæµÄperson±íºÍperson3µÄ½á¹¹ÊÇÍêÈ«ÏàͬµÄ£¬ÄÇôÈç¹û½á¹¹²»Í¬µÄ£¬Ôõô°ìÄØ£¿ÏÂÃæ¾ÙÀý×Ó˵Ã÷£¬´´½¨Ò»¸ö±íperson2
CREATE TABLE Person2
(
PersonID int IDENTITY(1,1) PRIMARY KEY,
FirstName nvarchar(200),
LastName nvarchar(200),
Email nvarchar(200),
Picture image
)
Èç¹ûÎÒÃǰ´ÉÏÃæ½«person±íÇ¨ÒÆµ½person2±íÖÐÈ¥£¬½«»á³ö´í£¬ÒòΪ×ֶβ»Í¬£¬¶øÎÒÃǽ«²ÉÓÃÏÂÃæµÄ´úÂë
string conn
Ïà¹ØÎĵµ£º
1. ´Óhttp://sqlite.phxsoftware.com ÏÂÔØSystem.Data.SQLite.dll
2. ´Óhttp://www.sqlite.org/download.html ÏÂÔØ sqlite3.dll
3. Copy ÒÔÉÏ2¸öDllµ½Asp.netÍøÕ¾µÄbinĿ¼Ï£¬ÀàËÆ E:\2009work\MyWeb\Bin
4. ÓÃsqlitespy ¹¤¾ßн¨Êý¾Ý¿â£¬E:\2009work\MyWeb\App_Data\db.db3 £ ......
ÔÎÄ£ºÁõÎä|ÈçºÎÔÚASP.NETÒ³ÃæÖÐǶÈëWINFORM¿Ø¼þÒ»
ÔÚ.NET֮ǰ£¬ÎÒÃÇÈç¹ûÏë·ÃÎʿͻ§¶ËµÄ×ÊÔ´£¬×î³£¼ûµÄ·½Ê½¾ÍÊÇÔÚÍøÒ³ÀïÃæÇ¶ÈëACTIVEX¿Ø¼þ¡£ÏÖÔÚÓÐÁË.NET£¬ÎÒÃÇ¿ÉÒÔ½«WINFORM¿Ø¼þǶÈëÔÚÍøÒ³ÀïÃæ£¬´Ó¶øÖ±½Ó¿ØÖƿͻ§¶Ë£¬²»¹ýǰÌáÊǿͻ§¶Ë±ØÐë°²×°ÁË.NET¿â¡£ÕâÓеãÏñJAVA µÄAPPLET£¨±ÊÕß¶ÔJAVA²»ÊǺÜÊ죬ÈçÓÐÎÊÌâ ......
¹ØÓڿؼþͼ±êµÄÊ£¬¿ÉûÉÙϹÕÛÌÚ£¬´ÓǰÄêÏëÈëÊÖÕâ·½Ãæ¿ªÊ¼£¬¾Íû¸ã¶¨¹ý¡£N¶à´óϺµÄÌù×Ó¶¼·ÀÃÁË£¬Ò²Ã»ÕÒ³ö¸öÍ·Ð÷À´¡£Æäʵ×ʼÓдÎÕæ¸øÃɳöÀ´ÁË£¡²»¹ýºóÀ´¸Ä¿Ø¼þ£¬Ò²²»ÖªµÀ¸ÄÄÄÁË¡£Ã»ÁË£¡ÓÚÊÇÂúÊÀ½çµÄCSDN¡¢MSDN¡£¡£¡£¡£NBµÄÈË£¬NBµÄÎÄÕ¿´ÁËÑÛÔΣ¬´òËÀҲûÓÐŪ³öÀ´¡£×òÌìÏîÄ¿ÖÐÓöµ½ÎÊÌ⣬¿´ÁËÒ»¸çÃǵĿؼþ£¨WEBABCD£ºÖÁ½ñ ......
using System;
using System.Text;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
& ......
ÔÎÄ http://www.886s.com/blog/?p=96
Ëæ×ÅAjaxµÄÊ¢ÐУ¬´ó¼Ò¶¼È¥´ÕÈÈÄÖ£¬ÎÒÃǵÄÏîĿҲ²»ÀýÍâ¡£
¿´ÁËÒ»ÏÂÏÖÓеĴúÂ룬¶ÔÓÚÒ»¸ö²Ù×÷³éȡһ¸öµÄÒ³Ãæ£¬°Ñ²ÎÊý½ÓÊÕ£¬µ÷ÓÃÂß¼²ãµÄÏà¹Øº¯Êý²¢·µ»ØÏàÓ¦µÄJson»òÕßXml£¬ËÑË÷ÁËһϣ¬¹¤³ÌÖо¹È»ÓÐÁË360+¸öÕâÖÖÒ³Ãæ£¬ÕâÕæÊÇÒ»ÖÖÀË·Ñ£¡Èç¹ûÓ÷´É䣬һ¸öÒ³Ãæ¾Í¿ÉÒԸ㶨£¡½ÚÊ¡Á˶àÉ ......