asp.net Êý¾Ý¿â²Ù×÷Àà
using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace op_db
{
/**//// <summary>
/// רÃÅÓÃÀ´´¦ÀíÓëÊý¾Ý¿âµÄ²Ù×÷
/// </summary>
public class db_class
{
³ÉÔ±#region ³ÉÔ±
private SqlConnection conn=new SqlConnection();
/**//// <summary>
/// ˽ÓгÉÔ±
/// </summary>
private string _sql;
/**//// <summary>
/// ÊôÐÔ£ºÊý¾Ý¿â²éѯÓï¾ä
/// </summary>
private string _er;
public string er
{
get{return _er;}
}
public string sql
{
get{return _sql;}
set{_sql=value;}
}
#endregion
º¯Êý#region º¯Êý
&nbs
Ïà¹ØÎĵµ£º
1. Êý¾Ý¿â·ÃÎÊÐÔÄÜÓÅ»¯
Êý¾Ý¿âµÄÁ¬½ÓºÍ¹Ø±Õ
·ÃÎÊÊý¾Ý¿â×ÊÔ´ÐèÒª´´½¨Á¬½Ó¡¢´ò¿ªÁ¬½ÓºÍ¹Ø±ÕÁ¬½Ó¼¸¸ö²Ù×÷¡£ÕâЩ¹ý³ÌÐèÒª¶à´ÎÓëÊý¾Ý¿â½»»»ÐÅÏ¢ÒÔͨ¹ýÉí·ÝÑéÖ¤£¬±È½ÏºÄ·Ñ·þÎñÆ÷×ÊÔ´¡£ASP.NETÖÐÌṩÁËÁ¬½Ó³Ø(Connection Pool)¸ÄÉÆ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â¶ÔÐÔÄܵÄÓ°Ï졣ϵͳ½«Óû§µÄÊý¾Ý¿âÁ¬½Ó·ÅÔÚÁ¬½Ó³ØÖУ¬ÐèҪʱȡ³ö£¬¹Ø±ÕÊ ......
ÔÚ.NET֮ǰ£¬ÎÒÃÇÈç¹ûÏë·ÃÎʿͻ§¶ËµÄ×ÊÔ´£¬×î³£¼ûµÄ·½Ê½¾ÍÊÇÔÚÍøÒ³ÀïÃæÇ¶ÈëACTIVEX¿Ø¼þ¡£ÏÖÔÚÓÐÁË.NET£¬ÎÒÃÇ¿ÉÒÔ½«WINFORM¿Ø ¼þǶÈëÔÚÍøÒ³ÀïÃæ£¬´Ó¶øÖ±½Ó¿ØÖƿͻ§¶Ë£¬²»¹ýǰÌáÊǿͻ§¶Ë±ØÐë°²×°ÁË.NET¿â¡£ÕâÓеãÏñJAVA µÄAPPLET£¨±ÊÕß¶ÔJAVA²»ÊǺÜÊ죬ÈçÓÐÎÊÌâ»¶ÓÖ¸Õý£©¡£ÓÉÓÚÐèÒª.NETµÄÔËÐп⣬ËùÒÔʹÓÃÆðÀ´ÓкܶàÏÞÖÆ£¬²» ......
ÎҲſªÊ¼¿´ASP.NETÓëÊý¾Ý¿âµÄÁ¬½Ó£¬½ñÌìÒ»¿ªÊ¼¾ÍÒ»Á¬Óöµ½Èý¸öÎÊÌ⣬ÕÛÌÚÁËÒ»ÍíÉÏ...Ï£ÍûÎҲ鵽µÄ×ÊÁ϶Դó¼ÒÓÐÓá£
×î³õÎÒдµÄÓï¾äÊÇ£º
//Create the Connection
//SqlConnection conn = new SqlConnection(@"Data Source=(local)\NetSDK; Initial Catalog=Northwind; User ID = sa; password = yourPassword;");
ÉÏÃæÕâ ......
Ò»¡¢Response¶ÔÏó
Response¶ÔÏóÊÇHttpResponseÀàµÄÒ»¸öʵÀý¡£¸ÃÀàÖ÷ÒªÊÇ·â×°À´×ÔASP.NET²Ù×÷µÄHTTPÏìÓ¦ÐÅÏ¢¡£
1.Response¶ÔÏóµÄÊôÐÔ
¢Ù BufferOutput
˵Ã÷£º»ñÈ¡»òÉèÖÃÒ»¸öÖµ£¬¸ÃֵָʾÊÇ·ñ»º³åÊä³ö£¬²¢ÔÚÍê³É´¦ÀíÕû¸öÒ³Ö®ºó½«Æä·¢ËÍ
ÊôÐÔÖµ£ºÈç¹û»º³åÁ˵½¿Í»§¶ËµÄÊä³ö£¬ ......
1.Asp.NetÖм¸ÖÖÏàËÆµÄ±ê¼Ç·ûºÅ: < %=...%>< %#... %>< % %>< %@ %>½âÊͼ°Ó÷¨
´ð: < %#... %>: ÊÇÔڰ󶨿ؼþDataBind()·½·¨Ö´ÐÐʱ±»Ö´ÐУ¬ÓÃÓÚÊý¾Ý°ó¶¨
Èç: < %# Container.DataItem("tit") %>
< %= %>: ÔÚ³ÌÐòÖ´ÐÐʱ±»µ÷Ó㬿ÉÒÔÏÔʾºǫ́±äÁ¿Öµ
Èç:
*.aspxÖУº < %= ......