Asp.Netϸ½ÚÐÔÎÊÌ⾫ÝÍ
1.<%=...%>Óë<%#... %>µÄÇø±ð:
´ð:<%=...%>ÊÇÔÚ³ÌÐòÖ´ÐÐʱµ÷Óã¬<%#... %>ÊÇÔÚDataBind()·½·¨Ö®ºó±»µ÷ÓÃ
2.¿Ø¼þ½ÓÊÕÄÄЩÀàÐÍÊý¾Ý?
´ð:½ÓÊÕBindµÄ¿Ø¼þ£¬Ò»°ãÓÐDropDownList,DataList,DataGrid,ListBoxÕâЩ¼¯ºÏÐÔÖʵĿؼþ£¬¶ø±»À¦°óµÄÖ÷ÒªÊÇArrayList(Êý×é),Hashtable(¹þÏ¡±í),DataView(Êý¾ÝÊÓͼ),DataReaderÕâËĸö,ÒÔºóÎÒÃǾͿÉÒÔ¶ÔºÅÈë×ù,²»»á³öÏÖDataTable±»À¦°óµÄ´íÎóÁË
3.DataBind,»ñµÃµÄÊý¾Ý£¬ÏµÍ³»á½«ÆäĬÈÏΪString,ÔõÑùת»¯ÎªÆäËüµÄÀàÐÍ?
DataBinder.Eval(Container.DataItem,"ת»»µÄÀàÐÍ","¸ñʽ")
×îºóÒ»¸ö"¸ñʽ"ÊÇ¿ÉÑ¡µÄ£¬Ò»°ã²»ÓÃÈ¥¹ÜËû£¬Container.DataItemÊÇÀ¦°óµÄÊý¾ÝÏî,"ת»»ÀàÐÍ"Ö¸µÄÊÇInteger,String,BooleanÕâÒ»Àà¶«Î÷.
4.Ö÷ÒªÃüÃû¿Õ¼ä:
<% @ Import Namespace="System.Data" %> ´¦ÀíÊý¾ÝʱÓõ½
<% @ Import Namespace="System.Data.ADO" % > ʹÓÃADO.net ; ʱÓõ½
<% @ Import Namespace="System.Data.SQL" %> SQL Server Êý¾Ý¿âרÓÃ
<% @ Import Namespace="System.Data.XML" %> ²»Óÿ´´¦ÀíXMLÓõ½
<% @ Import Namespace="System.IO" %> ´¦ÀíÎļþʱÓõ½
<% @ Import Namespace="System.Web.Util" %> ·¢Óʼþʱ´ó¼Ò»áÓõ½
<% @ Import Namespace="System.Text" %> Îı¾±àÂëʱÓõ½
5.Connections(SQLConection »òÕß ADOConnection)µÄ³£ÓÃÊôÐԺͷ½·¨:
ConnectionString È¡µÃ»òÉèÖÃÁ¬½áÊý¾Ý¿âµÄÓï¾ä
ConnectionTimeout È¡µÃ»òÉèÖÃÁ¬½áÊý¾Ý¿âµÄ×ʱ¼ä£¬Ò²ÊǾͳ¬Ê±Ê±¼ä
DataBase È¡µÃ»òÉèÖÃÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏÒª´ò¿ªµÄÊý¾Ý¿âÃû
DataSource È¡µÃ»òÉèÖÃDSN,´ó¼Ò²»»áİÉú°É£º£©
Password È¡µÃ»òÉèÖÃÃÜÂë
UserID È¡µÃ»òÉèÖõǽÃû
State È¡µÃĿǰÁª½áµÄ״̬
Open() ´ò¿ªÁª½á
Close() ¹Ø±ÕÁª½á
Clone() ¿Ë¡һ¸öÁª½á¡££¨ºÇºÇ£¬ÃàÑò¿ÉÒÔConnectionÎÒÒ²¿ÉÒÔ)
ʾÀý:
SQLConnection myConnection = new SQLConnection();
myConnection.DataSource = "mySQLServer";
myConnection.Password = "";
myConnection.UserID = "sa";
myConnection.ConnectionTimeout = 30;
myConnection.Open();
myConnection.Database = "northwind";
myConnection.IsolationLevel = IsolationLevel.ReadCommitted
6.Command³£Óõķ½·¨ºÍÊôÐÔ
ActiveConnection È¡µÃ»òÉèÖÃÁª½áConnections
CommandText Ö´ÐеÄSQLÓï¾ä»ò´¢´æ¹ý³Ì(StoredProcedure)Ãû
Ïà¹ØÎĵµ£º
Ê×ÏÈÌí¼ÓÃüÃû¿Õ¼ä
using System.Data.OleDb;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
strfile = Request.QueryString["filename"];//´ÓÆäËûÒ³Ãæ´«¹ýÀ´µÄÎļþ·¾¶
Excel(strfile);
}
}
private v ......
asp.netÈçºÎ°ÑÎļþÉÏ´«µ½ÁíÍâһ̨·þÎñÆ÷?
ÎÒÓÃÓ³ÉäÍøÂçÅ̵ÄÐÎʽ,¿ÉÊdzÌÐòÎÞ·¨½«Îļþ±£´æµ½ÍøÂçÓ³ÉäÅÌÉÏ.
ÈçºÎ¹²ÏíÎļþ¼ÐµÄ»°,Îļþ¼Ð±ØÐëÓÐдÈëµÄȨÏÞ,¿ÉÊÇÕâÑùµÄ»°¾ÖÓòÍøÄÚËùÓеÄÈ˶¼¿ÉÒÔÉÏ´«µ½Õâ¸ö¹²ÏíĿ¼ÁË?
½¨Ò飺
Õâ¸öÎÒÕýºÃ×ö¹ýµÄ£¬ºÇºÇ£¬¸øÄã²Î¿¼
¼ÙÉèÓзþÎñÆ÷AÊÇweb·þÎñÆ÷£¬ÎļþҪͨ¹ýA·þÎñÆ÷ÉϵÄweb³ÌÐòÉÏ´«µ ......
web.config¹ØÓÚsessionState½ÚµãµÄÅäÖ÷½°¸£¬sessionStateÓÐËÄÖÖģʽ£ºoff,inProc,StateServer,SqlServer¡£
1¡¢offģʽ
´Ó×ÖÃæÉϾͿÉÒÔ¿´³öÕâ¸öÊǹرÕģʽ£¬Èç¹ûµ±Ç°Ò³Ãæ²»ÐèÒªsessionµÄÖµ£¬ÎªÁ˼õÉÙ·þÎñÆ÷×ÊÔ´£¬Äã¿ÉÒÔÈ¥µôSessionµÄ¿ªÏú¡£
<sessionState mode="off">»òÕßÒ³ÃæÉÏ
<%@ Page EnableSessionState= ......