JS´úÂë:
<script type="text/javascript" language="javascript">
var speed = 25;
demo2.innerHTML = demo1.innerHTML
function Marquee() {
&nb ......
1. ʹÓÃQueryString±äÁ¿
¡¡¡¡QueryStringÊÇÒ»Öַdz£¼òµ¥µÄ´«Öµ·½Ê½£¬Ëû¿ÉÒÔ½«´«Ë͵ÄÖµÏÔʾÔÚä¯ÀÀÆ÷µÄµØÖ·À¸ÖС£Èç¹ûÊÇ´«µÝÒ»¸ö»ò¶à¸ö°²È«ÐÔÒªÇ󲻸߻òÊǽṹ¼òµ¥µÄÊýֵʱ£¬¿ÉÒÔʹÓÃÕâ¸ö·½·¨¡£µ«ÊǶÔÓÚ´«µÝÊý×é»ò¶ÔÏóµÄ»°£¬¾Í²»ÄÜÓÃÕâ¸ö·½·¨ÁË¡£ÏÂÃæÊÇÒ»¸öÀý×Ó£º
a.aspxµÄC#´úÂë
private void Button1_Click(object sender, System.EventArgs e)
{
string s_url;
s_url = "b.aspx?name=" + Label1.Text;
Response.Redirect(s_url);
}
b.aspxÖÐC#´úÂë
private void Page_Load(object sender, EventArgs e)
{
Label2.Text = Request.QueryString["name"];
}
2. ʹÓÃApplication ¶ÔÏó±äÁ¿ //²»¹ýApplicationÊÇÓÃÀ´´æÈ¡È«¾ÖÐÔµÄÖµµÄ
//µ¥¸öÓû§Èç¹ûÐèÒªÔÚÒ³Ãæ¼û´«µÝ²ÎÊýµÄ»°» ......
¼ÇÈ¡¼Ç¼¼¯
create procedure getArticle
as
select * from Article_Content
GO
asp.net µ÷Ó÷½·¨
SqlConnection Conn = new SqlConnection();
Conn.ConnectionString = Data.Connstr();
Conn.Open();
SqlDataAdapter sdr=new SqlDataAdapter();
sdr.SelectCommand = new SqlCommand("getArticle", Conn);
sdr.SelectCommand.CommandType=CommandType.StoredProcedure;
DataSet rs = new DataSet();
sdr.Fill(rs);
sdr.Dispose();
Conn.Dispose();
Response.Write(rs.Tables[0].Rows.Count);
---------------------------------------- ......
¼ÇÈ¡¼Ç¼¼¯
create procedure getArticle
as
select * from Article_Content
GO
asp.net µ÷Ó÷½·¨
SqlConnection Conn = new SqlConnection();
Conn.ConnectionString = Data.Connstr();
Conn.Open();
SqlDataAdapter sdr=new SqlDataAdapter();
sdr.SelectCommand = new SqlCommand("getArticle", Conn);
sdr.SelectCommand.CommandType=CommandType.StoredProcedure;
DataSet rs = new DataSet();
sdr.Fill(rs);
sdr.Dispose();
Conn.Dispose();
Response.Write(rs.Tables[0].Rows.Count);
---------------------------------------- ......
¼ÇÈ¡¼Ç¼¼¯
create procedure getArticle
as
select * from Article_Content
GO
asp.net µ÷Ó÷½·¨
SqlConnection Conn = new SqlConnection();
Conn.ConnectionString = Data.Connstr();
Conn.Open();
SqlDataAdapter sdr=new SqlDataAdapter();
sdr.SelectCommand = new SqlCommand("getArticle", Conn);
sdr.SelectCommand.CommandType=CommandType.StoredProcedure;
DataSet rs = new DataSet();
sdr.Fill(rs);
sdr.Dispose();
Conn.Dispose();
Response.Write(rs.Tables[0].Rows.Count);
---------------------------------------- ......
ʹÓö¨ÖÆ´íÎóÒ³Ãæ
ËäÈ»ÎÒÃÇ·¢Ë͸øÓû§µÄ¹«ÓôíÎóÐÅÏ¢Êǰ²È«µÄ£¬¾ÍÊÇ˵Ëü²»»áÍþвµ½Ó¦ÓóÌÐòµÄÃØÃÜ£¬µ«ÊÇÕâÑùµÄÐÅÏ¢²¢²»ºÃ¿´¡£Ò²ÐíÄãÏ£ÍûÓû§ÓÀÔ¶Ò²¿´²»µ½ÕâÑùµÄÐÅÏ¢¡£Ïà·´£¬µ±´¦ÀíÇëÇóµÄ¹ý³ÌÖУ¬Èç¹û·¢ÉúÁËÒ»¸öΪ´¦ÀíµÄ´íÎó£¬ÄãÏ£ÍûÄܹ»ÏÔʾ×Ô¼ºµÄ“¶¨ÖÆ´íÎóÒ³Ãæ”£¬ÏÔʾ³ö×Ô¼ºµÄÆ·ÅÆÒÔ¼°Ìض¨µÄ´íÎóÐÅÏ¢¡£
ÏòASP.NET Ó¦ÓóÌÐòÖÐÔö¼Ó¶¨ÖÆ´íÎóÐÅÏ¢·Ç³£ÈÝÒס£Ê×ÏÈ£¬±àд×Ô¼ºµÄ webÒ³Ãæ£¬Ëü¿ÉÒÔÊÇÈκÎÀàÐ͵ÄÎļþ£º.htm£¬.aspx£¬.asp£¬µÈµÈ¡£È»ºóÔÚÓ¦ÓóÌÐòµÄconfig.webÎļþÖÐÐÞ¸ÄÅäÖÃÐÅÏ¢£¬ÈÃËüÖ¸ÏòÕâ¸öÎļþ¡£
¾ÙÀý˵Ã÷£¬ÒÔÏÂÕâ¸öÅäÖÃÐÅϢ˵Ã÷ÔÚ·¢ÉúÁËÈκÎδÄÜÔ¤¶¨´¦Àí´íÎóµÄÇé¿öÏ£¬ä¯ÀÀÆ÷¶¼Ó¦¸Ã±»Öض¨Ïòµ½“ErrorPage.aspx”Ò³Ãæ£º
<configuration>
<customerrors mode="remoteonly" defaultredirect="ErrorPage.aspx" />
</configuration>
<customerrors>±ê¼ÇÖеēdefaultredirect”ÊôÐÔ¶¨ÒåÁËÔÚ·¢Éú´íÎóµÄÇé¿öÏ£¬Óû§½«±»Öض¨Ïòµ½µÄ“ĬÈÏ”Ò³Ãæ¡£»òÕߣ¬Ò²¿ÉÒÔ¸ù¾ÝÏìÓ¦µÄhttp´úÂë״̬£¬Öض¨Ïòµ½ÆäËüµÄÒ³ÃæÀ´¸²¸ÇÕâ¸öĬÈÏÖµ¡£ÀýÈç£ºÖØ¶¨Ïòµ½Ò»¸öÌØÊâµÄ“δÕÒµ ......
1.²éѯ¹¦ÄÜ£º
ÃèÊö£ºÍ¨³£ÔÚÍøÒ³Éϸù¾Ýµã»÷²éѯ°´Å¥»ñµÃËùÒª½á¹û
Àý£º
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:±ù˪
-- Create date: 2009-09-04
-- Description:²éѯ
-- =============================================
Alter PROCEDURE [dbo].[KDF_PackageMeetingRoom_Examine]
(
@HotelID varchar(20),
@State int,
@StartDate varchar(30),
@EndDate varchar(30)
)
as
DECLARE @MainStr VARCHAR(1000)
set @MainStr='select * from PackageMeetingRoom where ID=ID '
if(@HotelID<>'')
set @MainStr=@MainStr+'and HotelID like'+''''+'%'+@HotelID+'%'+''''
if (@State <> '-1')
set @MainStr=@MainStr+'and State='+''''+convert(varchar(20),@State)+''''
if(@StartDate<>'' or @EndDate<>'')
set @MainStr=@MainStr+'and Dtedate between'''+@StartDate+''''+'and'''+@EndDate+''''
set @MainStr=@MainStr+'order by Dtedate desc'
exec (@MainStr)
ºÜ²»ºÃÒâ˼,×î½üÓеãæ,ÏÖÔÚ°ÑһЩ³£ÓõĴ洢¹ý³ÌÌù³öÀ´,ÒÔºóÕûÀí
2,²åÈëÔö¼Ó
......
ASP.NETµÄ¹Ø¼üÄ¿±êÖ®Ò»ÊÇ´´½¨Ò»ÖÖÈÿª·¢ÈËÔ±Äܹ»ÏñWindowsÓ¦ÓóÌÐò¿ª·¢Õß¶¨ÖÆ×ÀÃæÓ¦ÓóÌÐòÄÇÑùµÄ¿ìËÙ¶¨ÖÆWeb FormsµÄģʽ¡£µ±È»WebÓ¦ÓóÌÐòÓ봫ͳ¸»¿Í»§¶ËÓ¦ÓóÌÐòÓкܴóµÄ²»Í¬£¬ÒªÊµÏÖÕâÖÖģʽÓÐÁ½¸ö¹Ø¼üµÄÕϰ¡£
1.WebÓ¦ÓóÌÐòÊÇÔÚ·þÎñÆ÷¶ËÖ´ÐеģºÀýÈ磬¼ÙÉè´´½¨Ò»¸öÔÊÐíÓû§Ñ¡ÔñÒ»¸ö²úÆ·¼Ç¼²¢¸üÐÂËüµÄÐÅÏ¢µÄForm¡£Óû§ÔÚä¯ÀÀÆ÷ÖÐÖ´ÐÐÕâЩÈÎÎñ£¬µ«ÊÇΪÁËÖ´ÐÐÕâЩ±ØÒªµÄ²Ù×÷£¨ÀýÈç¸üÐÂÊý¾Ý£©£¬´úÂë±ØÐëÔÚWeb·þÎñÆ÷ÉÏÖ´ÐС£ASP.NETʹÓÃÒ»ÖÖ½Ð×ö»Ø´«µÄ¼¼ÊõÀ´´¦ÀíÕâÖÖ·ÖÀëÐÔ£¬µ±Ä³Ð©¶¯×÷±»Ö´ÐеÄʱºò£¬Ëü°ÑÍøÒ³£¨°üÀ¨ËùÓÐÓû§ÌṩµÄÐÅÏ¢£©·¢Ë͸ø·þÎñÆ÷¡£ASP.NETÒ»µ©½ÓÊÕµ½Õâ¸öÍøÒ³£¬Ëü¾ÍÄܹ»´¥·¢ÏàÓ¦µÄ·þÎñÆ÷¶ËʼþÀ´¶ÔÓ¦µÄ´úÂë¡£
2.WebÓ¦ÓóÌÐòÊÇÎÞ״̬µÄ£º»»¾ä»°Ëµ£¬³ÊÏÖ¸øÓû§µÄHTMLÒ³±»·¢Ë͸øÓû§Ö®Ç°£¬Õâ¸öÍøÒ³µÄ¶ÔÏó±»Çå³ý²¢ÇÒËùÓеĿͻ§¶ËÖ¸¶¨µÄÐÅÏ¢±»½ûÖ¹¡£ÒòΪÕâÖÖģʽ·Ç³£ÊʺϸßÀ©Õ¹ÐÔºÍÍøÂçͨÐÅ·±Ã¦µÄÓ¦ÓóÌÐò¡£µ«ÊÇÕâҲʹµÃËûºÜÄÑ´´½¨Ò»ÖÖÎÞ·ìµÄÓû§ÌåÑé¡£ASP.NET°üº¬¼¸¸ö¹¤¾ßÀ´°ïÖúÎÒÃÇÏû³ýÕâÖв»×ã¡£×îÓÐÃûµÄ¾ÍÊDZ»½Ð×öView state µÄ³Ö¾Ã»¯»úÖÆ£¬ËüÄܹ»×Ô¶¯µÄ°Ñ¹ØÓÚÍøÒ³µÄ ......