c#ÖиßЧµÄexcelµ¼ÈësqlserverµÄ·½·¨
±¾ÎÄÀ´×ÔCSDN²©¿Í£ºhttp://blog.csdn.net/jinjazz/archive/2008/07/14/2650506.aspx
½«oledb¶ÁÈ¡µÄexcelÊý¾Ý¿ìËÙ²åÈëµÄsqlserverÖУ¬ºÜ¶àÈËͨ¹ýÑ»·À´Æ´½Ósql£¬ÕâÑù×ö²»µ«ÈÝÒ׳ö´í¶øÇÒЧÂʵÍÏ£¬×îºÃµÄ°ì·¨ÊÇʹÓÃbcp£¬Ò²¾ÍÊÇSystem.Data.SqlClient.SqlBulkCopy ÀàÀ´ÊµÏÖ¡£²»µ«Ëٶȿ죬¶øÇÒ´úÂë¼òµ¥£¬ÏÂÃæ²âÊÔ´úÂëµ¼ÈëÒ»¸ö6Íò¶àÌõÊý¾ÝµÄsheet£¬°üÀ¨¶ÁÈ¡£¨È«²¿¶ÁÈ¡±È½ÏÂý£©ÔÚÎҵĿª·¢»·¾³ÖÐÖ»ÐèÒª10Ãë×óÓÒ£¬¶øÕæÕýµÄµ¼Èë¹ý³ÌÖ»ÐèÒª4.5Ãë¡£
using System;
using System.Data;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
//²âÊÔ£¬½«excelÖеÄsheet1µ¼Èëµ½sqlserverÖÐ
string connString = "server=localhost;uid=sa;pwd=sqlgis;database=master";
System.Windows.Forms.OpenFileDialog fd = new OpenFileDialog();
if (fd.ShowDialog() == DialogResult.OK)
{
TransferData(fd.FileName, "sheet1", connString);
}
}
public void TransferData(string excelFile, string sheetName, string connectionString)
{
&nbs
Ïà¹ØÎĵµ£º
Ö»ÈÃÖ¸¶¨µÄ»úÆ÷Á¬½ÓSQLServer·þÎñÆ÷ ÊÕ²Ø
±³¾°
Ö»Ïëʹij¸öIPµÄ¼ÆËã»ú²ÅÄÜÁ¬½Óµ½SQL Server·þÎñÆ÷£¬²»ÔÊÐíÆäËû¿Í»§¶ËÁ¬½Ó¡£
½â¾ö·½·¨
¿ÉÒÔÖ±½ÓÔÚ·À»ðǽÖÐ×öÏÞÖÆ£¬Ö»ÔÊÐíÓëÖ¸¶¨µÄIPµØÖ·½¨Á¢1433µÄͨѶ¡£µ±È»£¬´Ó¸üΪ°²È«µÄ½Ç¶ÈÀ´¿¼ÂÇ£¬Ó¦¸Ã°Ñ1433¶Ë¿Ú¸Ä³ÉÆäËûµÄ¶Ë¿Ú¡£
ÆäËû½â¾ö·½·¨1£¨ÏÞ´ÓÖ¸¶¨IP½ÓÈëµÄ¿Í»§¶Ë£©
Èç¹ûʹ ......
ÔÚËÑË÷ÒýÇæµÄ¿ª·¢ÖУ¬ÎÒÃÇÐèÒª¶ÔÍøÒ³µÄHtmlÄÚÈݽøÐмìË÷£¬ÄÑÃâµÄ¾ÍÐèÒª¶ÔHtml½øÐнâÎö¡£²ð·Öÿһ¸ö½Úµã²¢ÇÒ»ñÈ¡½Úµã¼äµÄÄÚÈÝ¡£´ËÎĽéÉÜÁ½ÖÖC#½âÎöHtmlµÄ·½·¨¡£
µÚÒ»ÖÖ·½·¨£º
ÓÃSystem.Net.WebClientÏÂÔØWeb Page´æµ½±¾µØÎļþ»òÕßStringÖУ¬ÓÃÕýÔò±í´ïʽÀ´·ÖÎö¡£Õâ¸ö·½·¨¿ÉÒÔÓÃÔÚWeb CrawlerµÈÐèÒª·ÖÎöºÜ¶àWeb PageµÄÓ¦ÓÃÖ ......
ÏÈ¿´¿´¿Ø¼þµÄÍâ¹Û
Ò»¡¢²»ºÃ½â¾öµÄÎÊÌâ
ÕûÌåÀ´Ëµ£¬¿Ø¼þ±¾Éíûʲô´óÎÊÌ⣬ֻÊÇÓеãССµÄÎÊÌâÏȽ»´úһϡ£
1. FirefoxµÄijЩÀÏ°æ±¾¶ÔFLASH²»¼æÈÝ£¬Õâ¸ö²»Êǿؼþ×ÔÉíÄܽâ¾öµÄÎÊÌâ¡£
2. аæFirefoxËäÈ»¼æÈÝÁËFLASH£¬µ«ÊǶÔSESSIONÓëCOOKIES¾ÍÕÒ²»µ½ÁË£¬ÔÒòÊÇFriefoxʹÓÃÓëFLASHʹÓÃÁ˲»Í¬µÄ³ÌÐò³ØÔì³É¡£
3. Õâ¸ö¿Ø¼þ²»Ö ......
HOLDLOCK ½«¹²ÏíËø±£Áôµ½ÊÂÎñÍê³É£¬¶ø²»ÊÇÔÚÏàÓ¦µÄ±í¡¢ÐлòÊý¾ÝÒ³²»ÔÙÐèҪʱ¾ÍÁ¢¼´ÊÍ·ÅËø¡£HOLDLOCK µÈͬÓÚ SERIALIZABLE¡£
NOLOCK ²»Òª·¢³ö¹²ÏíËø£¬²¢ÇÒ²»ÒªÌṩÅÅËüËø¡£µ±´ËÑ¡ÏîÉúЧʱ£¬¿ÉÄÜ»á¶ÁȡδÌá½»µÄÊÂÎñ»òÒ»×éÔÚ¶ÁÈ¡Öмä»Ø¹öµÄÒ³Ãæ¡£ÓпÉÄÜ·¢ÉúÔà¶Á¡£½öÓ¦ÓÃÓÚ SELECT Óï¾ä¡£
PAGLOCK ÔÚͨ³£Ê¹Óõ¥¸ö±íËøµ ......