asp.netµÄÒ»¸ödbhelperÀà
using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;
using System.Text;
namespace Maticsoft.DBUtility
{
/// <summary>
/// Copyright (C) 2004-2008
/// Êý¾Ý·ÃÎÊ»ù´¡Àà(»ùÓÚSQLServer)
/// Óû§¿ÉÒÔÐÞ¸ÄÂú×ã×Ô¼ºÏîÄ¿µÄÐèÒª¡£
/// </summary>
public abstract class DbHelperSQL
{
//Êý¾Ý¿âÁ¬½Ó×Ö·û´®(web.configÀ´ÅäÖÃ)
//<add key="ConnectionString" value="server=127.0.0.1;database=DATABASE;uid=sa;pwd=" />
protected static string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString();
public DbHelperSQL()
{
}
#region ¹«Ó÷½·¨
public static int GetMaxID(string FieldName,string TableName)
{
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = GetSingle(strsql);
if (obj == n
Ïà¹ØÎĵµ£º
<%%>ÊÇÔÚ³ÊÏÖÒ³ÃæµÄ¹ý³ÌÖÐÖ´ÐеķþÎñÆ÷´úÂ룬°üÀ¨·½·¨£¬±äÁ¿£¬Ò»°ãÊÇǶÈëʽ·þÎñÆ÷´úÂëд·¨£¬²»ÊʺϷÖÀëģʽ¡£
<%=%>ÊÇÔÚ³ÊÏÖÒ³ÃæµÄ¹ý³ÌÖÐÖ´ÐеķþÎñÆ÷´úÂ룬Ö÷ÒªÊDZäÁ¿µÄÖµ¡£
<%#%>¿É°üÀ¨±äÁ¿£¬±í´ïʽ£¬»òÕßµ÷Ó÷½·¨·µ»ØµÄÖµ£¬µ«±ØÐëµÄ±£Ö¤Õâ¶Î´úÂëλÓÚ
°ó¶¨¿Ø¼þµÄÄÚ²¿£¬ÒòΪֻÓе±°ó¶¨¿Ø¼þÔÚÖ´ÐÐD ......
ÀûÓÃJQueryµÄ$.ajax()¿ÉÒԺܷ½±ãµÄµ÷ÓÃasp.netµÄºǫ́·½·¨¡£
ÏÈÀ´¸ö¼òµ¥µÄʵÀýÈÈÈÈÉí°É¡£
1¡¢ÎÞ²ÎÊýµÄ·½·¨µ÷ÓÃ
asp.net code£º
using System.Web.Script.Services;
[WebMethod]
public static string SayHello()
{
return "Hello Ajax!";
}
×¢Ò⣺1.·½·¨Ò»¶¨Òª¾²Ì¬·½·¨£¬¶øÇÒÒªÓÐ[WebMethod]µÄÉùÃ÷
JQuery ......
ASP.NET Ò³ÃæÊ¼þÖ´ÐÐ˳Ðò ÊÕ²Ø
¹ý³ÌÃèÊö
ÏÂÃæÊÇASP.NETÒ³Ãæ³õʼµÄ¹ý³Ì:
1. Page_Init();
2. Load ViewState;
3. Load Postback data;
4. Page_Load();
5. Handle control events;
6. Page_PreRender();
7. Page_Render();
8. Unload event;
9. Dispose method called;
ÏÂÃæ¶ÔÆäÖеÄһЩ¹ý³Ì×÷ÏÂÃèÊö£º
1. Pa ......
URL ÖØÐ´ÊǽØÈ¡´«Èë Web ÇëÇó²¢×Ô¶¯½«ÇëÇóÖØ¶¨Ïòµ½ÆäËû URL µÄ¹ý³Ì¡£
±ÈÈçä¯ÀÀÆ÷·¢À´ÇëÇóhostname/101.aspx £¬·þÎñÆ÷×Ô¶¯½«Õâ¸öÇëÇóÖж¨ÏòΪhttp://hostname/list.aspx?id=101¡£
urlÖØÐ´µÄÓŵãÔÚÓÚ£º
Ëõ¶Ìurl£¬Òþ²ØÊµ¼Ê·¾¶Ìá¸ß°²È«ÐÔ
Ò×ÓÚÓû§¼ÇÒäºÍ¼ ......
asp.netÔÚ¿ª·¢Ê±,ÔÚ²»Í¬µÄÒ³Ãæ¼äÌø×ªÊÇÎÒÃdz£Óöµ½µÄÒ»¼þÊÂ,µ±Ò»¸ö¸´ÔÓµÄÂß¼ÔÚÒ»¸öÒ³Ãæ·Å²»Ï·ֳɶþ¸ö»ò¶à¸öÒ³Ãæ´¦Àí¾ÍÐèÒªÔÚÒ³Ãæ¼äÌø×ª,ÓõÄ×î¶à»¹ÊÇÓû§µÄµÇ½°É.
ASP.NETÓõÄ×î¶àµÄÌø×ªÊÇResponse.Redirect,Õâ¸öÃüÁî¿ÉÒÔÖ±½Ó°ÑÇëÇóÖØ¶¨Ïòµ½Ò»¸öÏà¶Ô»ò¾ø¶ÔµÄ·¾¶.Ëü»á°Ñµ±Ç°Ò³ÃæµÄµÄHttpÁ÷×è¶ÏÖ±½ÓÖØ¶¨Ïòµ½ÐµÄU ......