asp.net ´æ´¢¹ý³ÌÖ´ÐÐʵÀý
protected void Page_Load(object sender, EventArgs e)
{
/*
sql½Å±¾-´´½¨Ñ§Éú±í
create table student(id int,name varchar(50))
insert into student select 1,'СÕÅ'
insert into student select 2,'СÍõ'
´æ´¢¹ý³Ì ¹¦ÄÜ£º²éѯѧÉúÃû³Æ
create proc proc_getName
@id int,
@name varchar(50) output
as
begin
if exists(select 1 from student where id=@id)
select @name=name from student where id=@id
else
set @name='--δÕÒµ½Ñ§Éú--'
end
*/
}
//Ö´Ðд洢¹ý³Ì
public void RunProcedure(string storedProcName, IDataParameter[] parameters)
{
string connectionString = "server=.;database=my;uid=sa;pwd=bb";//Êý¾Ý¿âÁ¬½Ó´®
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet dataSet = new DataSet();
connection.Open();
SqlDataAdapter sqlDA = new SqlDataAdapter();
Ïà¹ØÎĵµ£º
1.½«flex±àÒëºóµÄ³ÌÐò²åÈëµ½asp.netÒ³Ãæ
flexµÄ×îÖÕÊä³ö¾ÍÊÇÒ»ÕÅÍøÒ³+Ò»¸öflash(.swfÎļþ)
Õâô˵ÄãÃ÷°×Á˰ɣ¬Æäʵ¾ÍÊÇÓÃËûÉú³ÉµÄÍøÒ³µÄ·½Ê½°ÑÄǸö.swfÎļþ²åÈëµ½ÄãµÄasp.netÒ³Ãæ¾Í¿ÉÒÔÁË¡£
¼ÙÈçÄãµÄflex3ÏîÄ¿Ãû×Ö½ÐTestApp£¬×î¼òµ¥Ö±½ÓµÄ°ì·¨¾ÍÊÇ£¬
°Ñ"bin-debug"Ŀ¼Ïµģº
TestApp.html
TestApp.swf
AC_OETags.js ......
ASP.NET·þÎñÆ÷¿Ø¼þÖ®ÊÓͼ״̬
ΪWebÒ³Ãæ¼°Æä¿Ø¼þ±£³Ö״̬ÐÅÏ¢ÊǷdz£ÓбØÒªµÄ¡£È»¶ø£¬ÓÉÓÚWebÓ¦ÓóÌÐò´´½¨ÓÚHTTPÐÒéµÄ¶¥²ã£¬ÕâÊÇÒ»¸öÎÞ״̬µÄÐÒ飬Òò´Ë£¬±£³Ö״̬ÐÅÏ¢Ôò±äµÃ·Ç³£À§ÄÑ¡£ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬ASP.net 2.0¼¼ÊõÌṩÁ˶àÖÖ½â¾ö·½°¸£¬ÀýÈ磬ÀûÓÃSession¡¢Cookie¡¢ÊÓͼ״̬¡¢¿Ø¼þ״̬¡¢Òþ²ØÓò¡¢²éѯ×Ö·û´®¡¢¸ö ......
ASP.NET·ÖÒ³·½·¨µÄÁ˽â³Ì¶È
¡¾³öÏÖÆµÂÊ¡¿
¡ï¡ï¡ï¡ï¡î
¡¾½â´ð¡¿
ASP.NET·ÖÒ³µÄ³£Ó÷½·¨ÓÐÒÔϼ¸ÖÖ¡£
q ÆôÓò¿·ÖÊý¾Ý¿Ø¼þµÄÄÚÖ÷ÖÒ³¹¦ÄÜ£¬ÈçÉèÖÃGridView¿Ø¼þµÄ“AllowPaging”ÊôÐÔΪ“true”£¬ÀàËÆµÄÊý¾Ý¿Ø¼þ»¹ÓÐDetailsViewµÈ¡£
q ͨ¹ýSQL²éѯÓï¾ä£¬ÒÔÌáȡָ¶¨²¿·ÖµÄÊý¾ÝµÄ·½Ê½Íê³É·ÖÒ³µÄ¹¦ÄÜ¡£Ò ......
ÎÊ£ºÎªÊ²Ã´SessionÔÚÓÐЩ»úÆ÷ÉÏż¶û»á¶ªÊ§£¿
´ð£º¿ÉÄܺͻúÆ÷µÄ»·¾³ÓйØÏµ£¬±ÈÈ磺·À»ðǽ»òÕßɱ¶¾Èí¼þµÈ£¬³¢ÊԹرշÀ»ðǽ¡£
ÎÊ£ºÎªÊ²Ã´µ±µ÷ÓÃSession.Abandonʱ²¢Ã»Óм¤·¢Session_End·½·¨£¿
´ð£ºÊ×ÏÈSession_End·½·¨Ö»Ö§³ÖInProc£¨½ø³ÌÄڵģ©ÀàÐ͵ÄSession¡£Æä´ÎÒª¼¤·¢Session_End·½·¨£¬±ØÐë´æÔÚSession£¨¼´ÏµÍ³ÖÐÒÑ¾Ê¹Ó ......
1.Êý¾ÝÁ¬½Ó·½Ê½
ASP.NET±¾ÉíµÄÊý¾Ý·ÃÎÊADO.NET²»Ö§³Ö¶ÔÓÚMySqlµÄÁ¬½ÓºÍ²éѯ£¬µ«ÊÇMySQL¹ÙÍøÉϾùÌṩÁ˶àÖÖASP.NETÁ¬½Óµ½MySQLµÄ·½Ê½£º
£¨1£©ODBCÇý¶¯µÄ·ÃÎÊ·½Ê½£ºmysql-connector-odbc-5.1.5-win32.msi£¬ODBC
£¨2£©ADO.NET¶ÔÓÚMySQLµÄ·ÃÎÊ·½Ê½£ºmysql-connector-net-6.2.2.zip
¸öÈËÑ¡ÓõÄÊǵڶþÖÖ£¬¸Ð¾õ·½±ã£¬ºÍ.NET¶ÔS ......