ÎÊÌ⣺
ÎÒ½«Ò³ÃæÉÏÏà¹ØÐÅÏ¢µÄÓÐЧÐÔ¼ì²é¶¼Ð´ÔÚÒ»¸öʼþÀïÃæ£¬ÎÒÏÖÔÚµÄÏë·¨ÊÇ£ºÈç¹ûʼþÀïËùÓÐÓÐЧÐÔ¼ì²é¶¼Í¨¹ý£¬Ôòʼþ·µ»Ø1£¬·ñÔò·µ»Ø-1£¬ÏÖÔÚÎÊÌâÊÇ£¬Ê¼þ²»ÄÜÓзµ»ØÖµ£¬ÄÇô¸ÃÔõô°ì£¿
Ïà¹ØÐÅÏ¢µÄÓÐЧÐÔ¼ì²éµ¥¶Àд³ÉÒ»¸ö·½·¨¡£
µ¥¶Àд¸ö·½·¨µ÷ÓþͿÉÒÔÁË
C# code:
//ÓÐЧÐÔ¼ì²é
private bool check()
......
µÚÒ»£º ÎÒµ¼³öexcelºóµ±´ò¿ªµÄʱºòÌáʾ£ºÄú³¢ÊÔ´ò¿ªµÄÎļþµÄ¸ñʽÓëÎļþÀ©Õ¹ÃûÖ¸¶¨µÄ¸ñʽ²»Ò»ÖÂ
ÍøÉÏÕÒÁ˺ܶàûÕÒµ½½â¾ö°ì·¨¡£¡£¡£
µÚ¶þ£º ÒòΪÎÒÊÇÉú³ÉÒ»¸öÓû§ÐÅÏ¢Ìí¼ÓµÄexcel¡£¿ÉÄÜÏÂÔØÓû§ÒªÌí¼Ó¼ÓÁ½¸ö»òÒÔÉϵÄÓû§ÐÅÏ¢ËùÒÔÎÒÏëÔÚexcelÐÐβ¼ÓÒ»¸öÀàËÆÓÚwebÖеİ´Å¥¿ÉÒÔÓû§µã»÷ºó Ôö¼Ó³öºÍ³õʼһÃþÒ»ÑùµÄÁíÒ»¸öÓû§ÐÅÏ ......
Óиö·ÖÀà±í£¬ÒªÏëÔÚÒ»¸öÒ³ÃæÉÏÏÔʾ£¬ÏÔʾµÄÇé¿öÈçÏ£º
Ò»¼¶À¸Ä¿
¶þ¼¶À¸Ä¿
¶þ¼¶À¸Ä¿
¶þ¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
¶þ¼¶À¸Ä¿
¶þ¼¶À¸Ä¿
Ò»¼¶À¸Ä¿ &n ......
ÎÒÔÚASP.NETÖÐÒýÓÃÀïÌí¼ÓÁËÒ»¸öDLL
ÔÚVS2008»·¾³Ïµ÷ÊÔÊÇ£¬DLL·µ»ØµÄ½á¹ûÊǶԵģ¬
µ«ÊÇ£¬·Åµ½IISÏÂʱ£¬DLL·µ»ØµÄ½á¹û¾Í²»¶ÔÁË¡£
Èç¹û´ËʱÔÚWeb.config ÖÐÌí¼ÓÁË
<identity impersonate="true" userName="administrator" password="123456" />
ʱ£¬IISÏÂDLL·µ»Ø½á¹û¾ÍÊǶԵġ£
µ« ......
ÎÒÔÚдһ¸öÁôÑÔ°å³ÌÐò£¬µ«ÊÇÔÚ»ñÈ¡ËùÓÐÁôÑÔʱ×ÜÊÇÓÐ´í£¬ÓжàÌõ»Ø¸´µÄÁôÑÔ»áÖØ¸´ÏÔʾ£¬Çë½Ì¸÷λÕâ¸öµÄsqlÓï¾äÓ¦¸ÃÔõÑùд£¬ÎÒÓÐÈý¸ö±í£¬Ò»¸öLeaveword,Ò»¸öReplies,Ò»¸öReplyLeaveword£¬ReplyLeaveword´æ·ÅµÄÊÇReplyID£¬LeavewordID £¬ÎÒÊÇÕâÑùдµÄGETLEAVEWORDS = "SELECT Leavewords.*,Replies.Body AS ReplyBody from ......
ÎÊÌ⣺ASP.NET³ÌÐò£¬ÓÃADO.NET·ÃÎÊSQLÊý¾Ý¿â£¬ÓÃVB.NETÓïÑÔ±àд´úÂë¡£
´úÂëÈçÏ£º
Imports System.Data
Imports System.Data.OleDb
Imports system.Data.Sql
Imports System.Web.UI
Imports System.Web
Imports Microsoft.VisualBasic
Imports System
Imports System.Collections
Imports System.ComponentModel
......