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
Ïà¹ØÎĵµ£º
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔǰµÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕß¶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
1. Êý¾Ý¿â·ÃÎÊÐÔÄÜÓÅ»¯
Êý¾Ý¿âµÄÁ¬½ÓºÍ¹Ø±Õ
·ÃÎÊÊý¾Ý¿â×ÊÔ´ÐèÒª´´½¨Á¬½Ó¡¢´ò¿ªÁ¬½ÓºÍ¹Ø±ÕÁ¬½Ó¼¸¸ö²Ù×÷¡£ÕâЩ¹ý³ÌÐèÒª¶à´ÎÓëÊý¾Ý¿â½»»»ÐÅÏ¢ÒÔͨ¹ýÉí·ÝÑéÖ¤£¬±È½ÏºÄ·Ñ·þÎñÆ÷×ÊÔ´¡£ASP.NETÖÐÌṩÁËÁ¬½Ó³Ø(Connection Pool)¸ÄÉÆ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â¶ÔÐÔÄܵÄÓ°Ï졣ϵͳ½«Óû§µÄÊý¾Ý¿âÁ¬½Ó·ÅÔÚÁ¬½Ó³ØÖУ¬ÐèҪʱȡ³ö£¬¹Ø±ÕÊ ......
ÎҲſªÊ¼¿´ASP.NETÓëÊý¾Ý¿âµÄÁ¬½Ó£¬½ñÌìÒ»¿ªÊ¼¾ÍÒ»Á¬Óöµ½Èý¸öÎÊÌ⣬ÕÛÌÚÁËÒ»ÍíÉÏ...Ï£ÍûÎҲ鵽µÄ×ÊÁ϶Դó¼ÒÓÐÓá£
×î³õÎÒдµÄÓï¾äÊÇ£º
//Create the Connection
//SqlConnection conn = new SqlConnection(@"Data Source=(local)\NetSDK; Initial Catalog=Northwind; User ID = sa; password = yourPassword;");
ÉÏÃæÕâ ......
1.Asp.NetÖм¸ÖÖÏàËÆµÄ±ê¼Ç·ûºÅ: < %=...%>< %#... %>< % %>< %@ %>½âÊͼ°Ó÷¨
´ð: < %#... %>: ÊÇÔڰ󶨿ؼþDataBind()·½·¨Ö´ÐÐʱ±»Ö´ÐУ¬ÓÃÓÚÊý¾Ý°ó¶¨
Èç: < %# Container.DataItem("tit") %>
< %= %>: ÔÚ³ÌÐòÖ´ÐÐʱ±»µ÷Ó㬿ÉÒÔÏÔʾºǫ́±äÁ¿Öµ
Èç:
*.aspxÖУº < %= ......
// <summary>
/// ¹ýÂËhtml´úÂë
/// </summary>
public static string RphtmlStr(string html)
{
&n ......