(¾ÈÃüѽ¾ÈÃüѽ¾ÈÃüѽ)ASP.NETͻȻ²»ÄÜÁ¬½ÓSQL2000
ÈçÌâ:Ç°¼¸Ìì·þÎñÆ÷»¹ÊÇºÃºÃµÄ ½ñÌìÍøÒ³´ò²»¿ªÍ»È»³öÏÖ´íÎó,Ò»²éÊÇÁ´½Ó²»ÉÏÊý¾Ý¿âÁË?
(²éѯ·ÖÎöÆ÷ºÍÆóÒµ¹ÜÀíÆ÷¶¼¿ÉÒÔÕý³£ÏÔʾ)
[SqlException (0x80131904): Óû§ 'sa' µÇ¼ʧ°Ü¡£]
getdb.GetDataSet(String sql) +167
index.Databind() +42
index.Page_Load(Object sender, EventArgs e) +24
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
ÄѵÀsa±»½ûÁË»ò¸ÄÃÜÂëÁË
SA¿ÉÒÔÕý³£µÇ¼
SA¿ÉÒÔ²éѯ·ÖÎöÆ÷µÇ¼
http://blog.csdn.net/java2000_net/archive/2008/04/05/2252640.aspx
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÕâÑùдµÄ
select top 5 * from city where id not in(select top (5*"&page-1&") id from city) ..
ºÜʧ°ÜµÄ »¹ÒªÏÈÅжÏÊDz»ÊǵÚÒ»Ò³ È»ºóÑ¡ÔñÐÔÖ´ÐÐ sql .. д×Åд×ÅÎÒ ......
ÎÒÏëÒªÒ»¸öºÍqqÒ»ÑùµÄµ¯³ö¿ò£¬Äܹ»¹Ø±Õ£¬²»ÊÇ×Ô¶¯µÄ£¬¶øÊÇÊÖ¶¯µÄÄÇÖÖ£¬ÔÚµ¯³ö¿òÖÐÎÒÏë¼ÓÒ»¸öÊÓƵ£¬²»ÖªÓÐûÓÐÈË×ö¹ý°¡£¬ÔÚÏߵȰ¡£¬Ï£ÍûÓÐÈËÄܸøÎÒ·¢¸öʵÀý´úÂ룬ÔÚÏߵȣ¬
²»ÖªµÀÄãҪʲôЧ¹û£¬
²»¹ýÒ²¿Ï¶¨ÊÇ ......
RT```
ÏÖÔÚÓÐÒ»¸öÐÂÏîÄ¿Òª×ö, ÓÃÄĸö°æ±¾µÄAsp.Net À´¿ª·¢ºÃÄØ? ¸øµãÒâ¼û.
ÒÔÇ°Ö»ÓùýAsp.Net 2.0 ºÍ Sql 2000
лл!
.net2.0 + sql05
ÓÃvs2008+sql server 2005
vs2008Äã¿ÉÒÔÑ ......
ÀýÈçÓÐÁ½¶Î´úÂë
FirstPageCodeBehind.aspx
HTML code:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="FirstPageCodeBehind.aspx.cs" Inherits="FirstPag ......
ÎʸöÎÊÌ⣬×öºÃµÄasp.netÍøÕ¾Òª¼ÙÉèÔÚftp·þÎñÆ÷ÉÏ£¿
ÎÒÒѾÉú³ÉºÃÍøÕ¾£¬Ö±½Ó¿½±´µ½ftp·þÎñÆ÷ÉÏÊÇô£¿
½¨ÒéÈÓµ½iisÉÏ
Ò»°ã¼ÜÉèµ½·þÎñÆ÷µÄiisÖС£
Ôõô¼ÙÉèµ½IISÖÐÄØ£¿
³ÁÁË£¿
µÚÒ»²½£ºÖØбàÒë³Ì ......