¹Ø±ÕÊý¾Ý¿âÁ¬½ÓµÄ¸ßЧ·½·¨ (asp.net 2.0 C#)
ÎÒÃÇ»¹¿ÉÒÔ²ÉÓÃÒ»ÖÖ¸ü¼Ó¼ò±ãµÄ·½
·¨À´ÊµÏÖÉÏÊö³ÌÐòµÄ¹¦ÄÜ¡£Õâ¾ÍÊǽ«SqlConnection¶ÔÏó°üº¬µ½usingÇø¿éÖУ¬ÕâÑù³ÌÐò»á×Ô¶¯µ÷ÓÃDispose()·½·¨ÊÍ·Å
SqlConnection¶ÔÏóËùÕ¼ÓõÄϵͳ×ÊÔ´£¬ÎÞÐèÔÙʹÓÃSqlConnection¶ÔÏóµÄClose()·½·¨¡£
·¶Àý³ÌÐò´úÂëÈçÏ£º
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string connectionString = "server=localhost;database=Northwind;
integrated security=SSPI";
SqlConnection mySqlConnection = new SqlConnection(connectionString);
using (mySqlConnection)
{
mySqlConnection.Open();
lblInfo.Text = "<b>mySqlConnection¶ÔÏóµÄConnectionStringÊôÐÔΪ£º<b>" +
mySqlConnection.ConnectionString + "<br>";
lblInfo.Text += "<b>mySqlConnection¶ÔÏóµÄConnectionTimeoutÊôÐÔΪ<b>" +
mySqlConnection.ConnectionTimeout + "<br>";
lblInfo.Text += "<b>mySqlConnection¶ÔÏóµÄDatabaseÊôÐÔΪ<b>" +
mySqlConnection.Database + "<br>";
lblInfo.Text += "<b>mySqlConnection¶ÔÏóµÄDataSourceÊôÐÔΪ<b>" +
mySqlConnection.DataSource + "<br>";
lblInfo.Text += "<b>mySqlConnection¶ÔÏóµÄPacketSizeÊôÐÔΪ<b>" +
mySqlConnection.PacketSize + "<br>";
lblInfo.Text += "<b>mySqlConnection¶ÔÏóµÄServerVersionÊôÐÔΪ<b>" +
Ïà¹ØÎĵµ£º
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔǰµÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕß¶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
[±à¼±¾¶Î]
ʲôÊÇ ASP£¿
¡¡¡¡ASP ÊÇÒ»ÖÖʹǶÈëÍøÒ³ÖеĽű¾¿ÉÓÉÒòÌØÍø·þÎñÆ÷Ö´ÐеķþÎñÆ÷¶Ë½Å±¾¼¼Êõ¡£
¡¡¡¡ASP ÊÇÒ»Ïî΢Èí¹«Ë¾µÄ¼¼Êõ
¡¡¡¡ASP Ö¸ Active Server Pages£¨¶¯Ì¬·þÎñÆ÷Ò³Ãæ£©
¡¡¡¡ASP ÊÇÔËÐÐÓÚ IIS Ö®ÖеijÌÐò
¡¡¡¡IIS Ö¸ Internet Information Services£¨ÒòÌØÍøÐÅÏ¢·þÎñ£©
¡¡¡¡IIS ÊÇ Windows 2000 À ......
ASP.NetÖÐ×îΪͷʹµÄ¿ÉÄܾÍÊÇ´òÓ¡ÉèÖÃÁË¡£
ΪÁËÕâ¸öÎÊÌ⣬ÎÒ¶¼Òª°¾°×Í·ÁË¡£ÍøÉÏÒ²ÕÒÁ˺ܶà´úÂ룬µ«ÊÇ×ÜÊÇ»á´æÔÚһЩÎÊÌâ¡£¸ù¾ÝÎÒ×Ô¼ºµÄʵ¼ÊÊÔÑé·¢ÏÖ²»ÄÜÓã¬ÎªÕÒ²»µ½¶ÔÏóÖ®ÀàµÄ´íÎóÌáʾ¡£
ÕâÀï¸ø³öÁ½ÖÖʵ¼Ê¿ÉÓõķ½·¨£º
Ò»¡£Í¨¹ý×¢²á±íÐÞ¸ÄIE´òÓ¡ÉèÖÃ
<HTML>
<HEAD>
< ......
//ÏòÊý¾Ý¿âÖÐдÈë
private void button1_Click(object sender, EventArgs e)
{
oracleConnection1.Open();
& ......
ÏÈÀ´Ð´Ò»¸ö¼òµ¥µÄAjax³ÌÐò£¬Ê¹Ó÷Çͬ²½µÄ·½Ê½Ïò·þÎñÆ÷¶ËÈ¡µÃTXTÎļþÖеÄÄÚÈÝ£¬²¢¼ÓÒÔÏÔʾ¡£Ê×ÏÈ£¬Çë×¼±¸Ò»¸öHelloAjax.aspx(HTMLÒ²¿É)£º
*HelloAjax.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="HelloAjax.aspx.cs" Inherits="HelloAjax._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD ......