¹Ø±ÕÊý¾Ý¿âÁ¬½ÓµÄ¸ßЧ·½·¨ (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>" +
Ïà¹ØÎĵµ£º
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlC ......
MVC¿ò¼ÜͼÈçÏ£º
ÔÚÄã¾ö¶¨Ê¹ÓÃMVC¿ò¼Ü»òWeb Formsģʽ¿ª·¢Ö®Ç°£¬ÇëÈÏÕæºâÁ¿Ò»Ï¸÷×ÔµÄÓŵ㡣
»ùÓÚMVCµÄWebÓ¦ÓóÌÐòÓŵ㣺
ËüÄܺÜÈÝÒ׵ĹÜÀí¸´ÔÓµÄÓ¦ÓóÌÐò£¬½«Ëü·ÖΪmodel£¬viewºÍcontroller¡£
Ëü²»ÄÜʹÓÃview stateºÍ·þÎñÆ÷¿Ø¼þ£¬ÕâʹµÃMVC¿ò¼Ü¿ª·¢ÈËÔ±ÓµÓжÔÓ¦ÓóÌÐòÍêÈ«¿ØÖƵÄÄÜÁ¦¡£
ËüʹÓÃǰ¶Ë¿ØÖÆÆ÷ģʽ£¬Í¨¹ýµ¥Ò ......
[±à¼±¾¶Î]
ʲôÊÇ ASP£¿
¡¡¡¡ASP ÊÇÒ»ÖÖʹǶÈëÍøÒ³ÖеĽű¾¿ÉÓÉÒòÌØÍø·þÎñÆ÷Ö´ÐеķþÎñÆ÷¶Ë½Å±¾¼¼Êõ¡£
¡¡¡¡ASP ÊÇÒ»Ïî΢Èí¹«Ë¾µÄ¼¼Êõ
¡¡¡¡ASP Ö¸ Active Server Pages£¨¶¯Ì¬·þÎñÆ÷Ò³Ãæ£©
¡¡¡¡ASP ÊÇÔËÐÐÓÚ IIS Ö®ÖеijÌÐò
¡¡¡¡IIS Ö¸ Internet Information Services£¨ÒòÌØÍøÐÅÏ¢·þÎñ£©
¡¡¡¡IIS ÊÇ Windows 2000 À ......
//ÏòÊý¾Ý¿âÖÐдÈë
private void button1_Click(object sender, EventArgs e)
{
oracleConnection1.Open();
& ......
Ê®Ììѧ»áASP.net֮ʵսϵÁУ¨C#ºÍVb.netË«°æ±¾£©
µÚÒ»Ìì
ÎÒÈÏΪASP.NET±ÈASPÄѺܶ࣬ϣÍû´ó¼Ò×öºÃ×¼±¸¡£ÄÑÄÑÔÚʵÏÖͬһ¸öЧ¹ûÓкܶ෽·¨£¬´ó¼Ò»òÐí»áÒÉ»ó¡£Ê®Ììѧ»áϵÁн̳̻áÇåÎúµÄд³ö¸÷ÖÖ·½·¨£¬Èôó¼ÒÄÜÉÙÒ»µã¿²¿À¡£ÔÚASPÀïÃæ£¬´ó¼Ò¼¸ºõ¶¼ÊÇʹÓÃVB£¬Êý¾Ý¿âÂҲÎÞ·ÇÊÇSQLºÍACCESS¡£ÔÚASP.NETÀïÃæ£¬Êý¾Ý¿â»¹ÊÇÕ ......