asp.netÊý¾Ý¿â²Ù×÷Àà(´æ´¢¹ý³Ì´¦Àí)
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.ComponentModel;
namespace SQLHelper
{
/// <summary>
/// Class1 µÄժҪ˵Ã÷¡£
/// </summary>
public class SQLHelper
{
// Á¬½ÓÊý¾ÝÔ´
private SqlConnection myConnection;
private readonly string RETURNVALUE = "RETURNVALUE";
/// <summary>
/// ´ò¿ªÊý¾Ý¿âÁ¬½Ó.
/// </summary>
private void Open()
{
// ´ò¿ªÊý¾Ý¿âÁ¬½Ó
if (myConnection == null)
{
myConnection = new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString());
}
if(myConnection.State == ConnectionState.Closed)
{
try
{
///´ò¿ªÊý¾Ý¿âÁ¬½Ó
myConnection.Open();
}
catch(Exception ex)
{
SystemError.SystemLog(ex.Message);
}
finally
{
///¹Ø±ÕÒѾ´ò¿ªµÄÊý¾Ý¿âÁ¬½Ó
}
}
}
/// <summary>
/// ¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
/// </summary>
public void Close()
{
///ÅжÏÁ¬½ÓÊÇ·ñÒѾ´´½¨
if(myConnection != null)
{
///ÅжÏÁ¬½ÓµÄ״̬ÊÇ·ñ´ò¿ª
if(myConnection.State == ConnectionState.Open)
{
myConnection.Close();
&
Ïà¹ØÎĵµ£º
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔǰµÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕß¶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
//postÇëÇó
string name = Request["name"].toString();
string name =Request.Form.Get("name").toString();
//getÇëÇó
string name = Request.QueryString["name"].toString();
µ«ÎÒ·¢ÏÖ ÎÞÂÛÊÇ·ñÊÇpostÓëget´«Öµ
¶¼¿ÉÓÃstring name = Request["name"].toString();
±íµ¥Ìá½»ÖÐgetºÍpost·½Ê½µ ......
Asp.Net FormsÑéÖ¤(×Ô¶¨Òå¡¢½ÇÉ«Ìṩ³ÌÐò¡¢µ¥µãµÇ¼)
ÒÔǰ¿ª·¢ÏîĿʱ¾³£ÊÇ×Ô¼º¿ª·¢Ò»Ì×Óû§È¨ÏÞ¹ÜÀíϵͳ½øÐÐÑéÖ¤£¬±È½ÏÁé»î¡£×î½üΪÁ˵¥µãµÇ¼µÄÎÊÌâÓÖ°ÑAsp.Net×Ô´øµÄÑéÖ¤·½Ê½¿´ÁËÒ»±é£¬·¢ÏÖÕâÖÖ·½Ê½Ò²±È½Ï·½±ã£¬¹¦ÄÜÒ²»¹¿ÉÒÔ¡£ÔÚAsp.NetÌṩÁËÈýÖÖ³£ÓõÄÑéÖ¤·½Ê½£ºWindows·½Ê½ÊǺÍIIS½áºÏÆðÀ´¿ÉÒÔʵÏÖ»ù±¾¡¢ÕªÒª¡¢¼¯³É ......
ÔÚ×î½ü¿ªÊ¼½«AJAX¼¼Êõ¼ÓÈëµ½ÈÕ³£µÄ¿ª·¢¹¤×÷ÖС£ÎÒÔÚ×î½üдÁ˸öAJAXµÄÎÞˢеǽÇÒ¶¯Ì¬Ìí¼Ó·þÎñÆ÷¿Ø¼þµÄ¹¤×÷£¬ÎÒ½«´Ë¹¦ÄܸæËß´ó¼ÒÏ£Íû¶Ô´ó¼ÒµÄ¹¤×÷ÓÐËù°ïÖú¡£Èç¹û´ó¼ÒÓиüºÃµÄ·½·¨ÇÒÔ¸ÒâÔÚ´ËÁôÑÔÈÃÎÒÒ²¿ÉÒÔ·ÖÏíµ½ÄãµÄ³É¹û¡£
Ê×ÏÈÔÚÒ³ÃæÖеÄHTML±ê¼ÇÖмÓÈë¿Ø¼þUpdatePanelºÍÁ½¸öTextboxÒ»¸öButton£º
<asp:UpdatePanel ID ......
Ò»£¬JS¶¯Ì¬´´½¨±íµ¥
var result = " <form method='post' action='../xiazai.aspx'><table width='100%' border='0' cellpadding='0' cellspacing='1' bgcolor='#BDB4A2'>"+
"&l ......