.NET²åÈëSQLSERVERÑÓʱÎÊÌ⣿ - .NET¼¼Êõ / C#
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ¿´¿´ÊÇÍøËÙµÄÎÊÌâÁË
¾ÖÓòÍø ÍøÂçÕý³£
»º´æ »òÕß¾ÍÊÇÄãÓÐÒµÎñÂß¼¿ØÖƵģ¨ÀýÈç²åÈëºóÑé֤ϡ£¡£¡££©
ÄãÊý¾Ý¿â Óõ½ÊÂÎñûѽ£¿ »á²»»áÓÐЩ ¹ØÁªÄØ£¿
¿ÉÄÜÄã²éѯµÄÊý¾ÝÁ¿Ì«´óÁË»òÕßÄãÁ¬µÄÊÇÉú²ú·þÎñÆ÷£¬²¢·¢ÊýºÜ¸ß£¬²éѯЧÂÊ×ÔÈ»ÂýÁË
LZ¿ÉÒÔÊÔÊÔ¿´²éѯ±¾µØµÄ
¼ì²éµã£º
1¡¢ä¯ÀÀÆ÷»º´æ£¨¿ÉÔÚURLºó¼Ó¸öËæ»ú²ÎÊý×ö²âÊÔ£©
2¡¢²åÈë²Ù×÷ûÓм°Ê±·´Ó³µ½Êý¾Ý¿â£¨¿´²åÈë³ÌÐò´úÂ룩
3¡¢·´Ó³µ½ÁËÊý¾Ý¿âµ«Ã»Óм°Ê±¸üÐÂÊý¾Ý£¨¿´sqlÈçºÎÖ´ÐУ¬ÊDz»ÊÇ×î¼òµ¥µÄÒ»¾ä²åÈ룩
4¡¢ÍøÂçÂý
Ïà¹ØÎÊ´ð£º
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using Syst ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó)
Ð ......
ÎÒÓÐÒ»¸öXML.ÏëÈ¡
<Portfolio _Name="XXXX" _Id="AUD" >
ÖеÄÊôÐÔ_IdµÄÖµ.µ«ÊÇÓÃÏÂÃæµÄÓï¾äºÃÏó²»ÐÐ.
XmlNode CId = xdoc_Msg.SelectSingleNode("/Portfolio");
&n ......