¹Ø±ÕÊý¾Ý¿âÁ¬½ÓµÄ¸ßЧ·½·¨ (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Êý¾Ý¿âÁ¬½Ó×Ö·û´®µÄ¼ÓÃÜÓë½âÃÜ
ASP.NETÊý¾Ý¿âÁ¬½Ó×Ö·û´®µÄ¼ÓÃÜÓë½âÃÜ
ASP.NET web.configÖУ¬Êý¾Ý¿âÁ¬½Ó×Ö·û´®µÄ¼ÓÃÜÓë½âÃÜ¡£
¿ªÊ¼--->ÔËÐÐ,ÊäÈëcmd£¬½Ó×ÅÊäÈëÒÔÏÂÄÚÈÝ
¼ÓÃÜ£º
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -pef "connectionStrings" "ÄãµÄWebÏîĿ·¾¶"
¸´ÖÆ´úÂë ......
Stephen Walther
Superexpert
ÊÊÓÃÓÚ£º
Microsoft ASP.NET 2.0
Microsoft Visual Studio 2005
¼ò½é
ÔÚ Microsoft ASP.NET 2.0 Framework ÖУ¬Êý¾Ý¿â·ÃÎʵõ½Á˼«´óµÄ¼ò»¯¡£ÀûÓÃÈ«Ð嵀 SqlDataSource ¿Ø¼þ£¬ÄúÎÞÐè±àдһÐдúÂë¾Í¿ÉÒÔÑ¡Ôñ¡¢¸üС¢²åÈëºÍɾ³ýÊý¾Ý¿âÊý¾Ý¡£
Éú³É¼òµ¥µÄÓ¦ÓóÌÐòʱ£¬SqlDataSource ¿ ......
Ê®Ììѧ»áASP.net֮ʵսϵÁУ¨C#ºÍVb.netË«°æ±¾£©
µÚÒ»Ìì
ÎÒÈÏΪASP.NET±ÈASPÄѺܶ࣬ϣÍû´ó¼Ò×öºÃ×¼±¸¡£ÄÑÄÑÔÚʵÏÖͬһ¸öЧ¹ûÓкܶ෽·¨£¬´ó¼Ò»òÐí»áÒÉ»ó¡£Ê®Ììѧ»áϵÁн̳̻áÇåÎúµÄд³ö¸÷ÖÖ·½·¨£¬Èôó¼ÒÄÜÉÙÒ»µã¿²¿À¡£ÔÚASPÀïÃæ£¬´ó¼Ò¼¸ºõ¶¼ÊÇʹÓÃVB£¬Êý¾Ý¿âÂҲÎÞ·ÇÊÇSQLºÍACCESS¡£ÔÚASP.NETÀïÃæ£¬Êý¾Ý¿â»¹ÊÇÕ ......