ASP.NET¿çÒ³Ãæ´«Öµ¼¼ÇÉ×ܽá
¹ØÓÚÒ³Ãæ´«ÖµµÄ·½·¨£¬Òý·¢Á˺ܶàÌÖÂÛ¡£1. ʹÓÃQueryString±äÁ¿¡£2. ʹÓÃApplication ¶ÔÏó±äÁ¿¡£4. ʹÓÃCookie¶ÔÏó±äÁ¿¡£Õâ¸ö²Å¿ÉÒÔ˵ÊÇÃæÏó¶ÔÏ󿪷¢ËùʹÓõķ½·¨£¬ÆäʹÓÃServer.Transfer·½·¨°ÑÁ÷³Ì´Óµ±Ç°Ò³ÃæÒýµ¼¡£
¡¡¡¡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¶ÔÏóµÄ×÷Ó÷¶Î§ÊÇÕû¸öÈ«¾Ö£¬Ò²¾ÍÊÇ˵¶ÔËùÓÐÓû§¶¼ÓÐЧ¡£Æä³£Óõķ½·¨ÓÃLockºÍUnLock¡£
a.aspxµÄC#´úÂë
private void Button1_Click(object sender, System.EventArgs e)
{
Application["name"] = Label1.Text;
Server.Transfer("b.aspx");
}
b.aspxÖÐC#´úÂë
private void Page_Load(object sender, EventArgs e)
{
string name;
Application.Lock();
name = Application["name"].ToString();
Application.UnLock();
}
¡¡¡¡3. ʹÓÃSession±äÁ¿
¡¡¡¡Ïë±ØÕâ¸ö¿Ï¶¨ÊÇ´ó¼ÒʹÓÃÖÐ×î³£¼ûµÄÓ÷¨ÁË£¬Æä²Ù×÷ÓëApplicationÀàËÆ£¬×÷ÓÃÓÚÓû§¸öÈË£¬ËùÒÔ£¬¹ýÁ¿µÄ´æ´¢»áµ¼Ö·þÎñÆ÷ÄÚ´æ×ÊÔ´µÄºÄ¾¡¡£
a.aspxµÄC#´úÂë
private void Button1_Click(object sender, System.EventArgs e)
{
Session["name"] = Label.Text;
}
b.aspxÖÐC#´úÂë
private void Page_Load(object sender, EventArgs e)
{
string name;
name = Session["name"].ToString();
}
¡¡¡¡4. ʹÓÃCookie¶ÔÏó±äÁ¿
¡¡¡¡Õâ¸öÒ²ÊÇ´ó¼Ò³£Ê¹Óõķ½·¨£¬ÓëSessionÒ»Ñù£¬ÆäÊÇʲ¶Ôÿһ¸öÓû§¶øÑԵ쬵«ÊÇÓиö±¾ÖʵÄÇø±ð£¬¼´CookieÊÇ´æ·ÅÔÚ¿Í»§¶ËµÄ£¬¶
Ïà¹ØÎĵµ£º
ASP.NETÒ³ÃæÌø×ªÓÐʲô·½·¨ÄØ£¿£¬ÏÖÔÚ¸ø´ó¼Ò½éÉÜÈýÖÖ·½·¨£¬ËûÃǵÄÇø±ðÊÇÊ²Ã´ÄØ£¿ÈÃÎÒÃÇ¿ªÊ¼°É£º
ASP.NETÒ³ÃæÌø×ª1¡¢response.redirect Õâ¸öÌø×ªÒ³ÃæµÄ·½·¨Ìø×ªµÄËٶȲ»¿ì£¬ÒòΪËüÒª×ß2¸öÀ´»Ø(2´Îpostback)£¬µ«Ëû¿ÉÒÔÌø×ªµ½ÈκÎÒ³Ãæ£¬Ã»ÓÐÕ¾µãÒ³ÃæÏÞÖÆ(¼´¿ÉÒÔÓÉÑÅ»¢Ìøµ½ÐÂÀË)£¬Í¬Ê±²»ÄÜÌø¹ýµÇ¼±£»¤¡£µ«ËÙ¶ÈÂýÊÇÆä×î´óȱÏÝ! ......
using (con)
{
con.Open();
String sqltext = "select * from emp where empno=@empno";
......
ÔÚASP.NETÓ¦ÓóÌÐò³£³£»áÓöµ½ÐèÒª´ÓExcelÎļþÖжÁÈ¡Êý¾Ý»ò½«Êý¾ÝдÈëExcelµÄÐèÇó¡£Ò»°ãÀ´½²£¬ÔÚASP.NETÖжÁдExcelÎļþÓÐËÄÖÖ½â¾ö·½°¸¡£
1.1.1 ʹÓÃOLE DB
ʹÓÃOLE DB¿ÉÒÔÒÔ²éѯÊý¾Ý¿âµÄ·½Ê½À´¶ÁÈ¡ExcelÎļþ£¬ÒòΪÔÚijÖ̶ֳÈÉÏExcel±í¸ñ¿ÉÒÔ¿´³ÉÊÇÒ»ÕÅÒ»ÕŵÄÊý¾Ý±í¡£Æä¶þÕßµÄÖ÷񻂿±ðÔÚÓÚËùʹÓõÄÊý¾ÝÒýÇæ²»Ò»Ñù¡£Ê¹ÓÃOLE ......
ASP.NETÒ³ÃæË¢Ð·½·¨×ܽá
ÏÈ¿´¿´ASP.NETÒ³ÃæË¢ÐµÄʵÏÖ·½·¨£º
µÚÒ»£º
private void Button1_Click(objectsender,System.EventArgse)
{
Response.Redirect(Request.Url.ToString());
}
µÚ¶þ£º
private void Button2_Click(objectsender,System.EventArgse)
{
Response.Write("<mce:script language=javascript& ......
Abs(number) È¡µÃÊýÖµµÄ¾ø¶ÔÖµ¡£
Asc(String) È¡µÃ×Ö·û´®±í´ïʽµÄµÚÒ»¸ö×Ö·ûASCII Âë¡£
Atn(number) È¡µÃÒ»¸ö½Ç¶ÈµÄ·´ÕýÇÐÖµ¡£
CallByName (object, procname, usecalltype,[args()]) Ö´ÐÐÒ»¸ö¶ÔÏóµÄ·½·¨¡¢É趨»ò´«»Ø¶ÔÏóµÄÊôÐÔ¡£
CBool(expression) ת»»±í´ïʽΪBoolean ÐÍ̬¡£
CByte(expression) ת»»±í´ïʽΠ......