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

ÔÚ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


Ïà¹ØÎĵµ£º

Asp.netʹÓÃSqliteÊý¾Ý¿â

 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ÖÐcookieµÄ´¦Àí

Ô­ÎÄ£ºÁõÎä|asp.netÖÐcookieµÄ´¦Àí  
ʹÓÃÖз¢ÏÖÓÃRequest.Cookies.Remove()ÎÞ·¨É¾³ýcookie,googleÁËһϷ¢ÏÖÒ»°ãÊÇͨ¹ý½«¹ýÆÚʱ¼äÉèÖóɹýÈ¥µÄʱ¼äÀ´Íê³Éɾ³ýµÄ¡£Ë³±ãÕûÀíÏÂcookieµÄ²Ù×÷£º
Ò» ´´½¨
1 µ¥ÖµµÄ´´½¨
C#-Code:
HttpCookie hc = new HttpCookie("Value");
hc.Value = "value";
Response.Appe ......

ASP.NET ³ÌÐòÔ±µÄÐÞÁ¶Ö®Â·

³õ¼¶µÄ³ÌÐòÔ±»ò¾­Ñé²»×ãµÄ³ÌÐòÔ±ÍùÍùÖ»Òâʶµ½×Ô¼ºµÄ³ÌÐòÊÇд¸ø¼ÆËã»úµÄ£¬¶ø²»»áÔÚÒâ³ÌÐòÆäʵҲÊÇд¸øÈ˵쬻òÔÚÒâµÃ²»¹»¡¢²»È«Ãæ¡£
д¸ø»úÆ÷µÄ³ÌÐò£¬ÍùÍù×·ÇóµÄÊÇÔËÐÐÕýÈ·¡¢Ö´ÐÐЧÂÊÄÜÂú×ãÒªÇó¡£µ«³ÌÐòÔ±µÄÈÎÎñ½ö½ö¾ÍÊǰÑÒµÎñÂß¼­×ª³É»úÆ÷ÄܱàÒëµÄ¼ÆËã»úÓïÑÔÂð?
Æäʵ£¬³ÌÐòÊ×ÏÈ(×¢Ò⣬ÊÇÊ×ÏÈ)ÊÇд¸øÈ˵ġ£µÚÒ»£¬³ÌÐòÊÇд¸ ......

asp.net jquery Èý¼¶Áª¶¯

 var j = jQuery.noConflict();
var prov="";
var city="";
var area="";
j(function(){
    j.get("/Js/Message/address.xml",function(xml){
            j("body").data("xml",xml);
  ......

asp.net ÑéÖ¤Âë ʵÏÖ

µÚ1ÖÖ.
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ