asp.net DBHelp.cs
public class DBHelper
{
private static SqlConnection connection;
public static SqlConnection Connection
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings["MyCommerce"].ConnectionString;
if (connection == null)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
Ïà¹ØÎĵµ£º
1. µÄ.net£¬ÓÃÊó±êÓÒ»÷ÄãµÄ¹¤³Ì(½â¾ö·½°¸)£¬Ñ¡Ôñadd new project(Ìí¼Óн¨ÏîÄ¿)¡£
2.Ñ¡Ôñsetup and deployment projects£¨°²×°ºÍ²¿ÊðÏîÄ¿£©µÄ web setup project(web°²×°ÏîÄ¿)¡££¨×¢ÒâsetupprojectµÄ´æ·Å·¾¶¡£Í¨³£Ä¬ÈÏ£©
3.vsµÄ´°¿Ú»áÏÔʾÎļþϵͳ£¨you setup name£©¡£ÓÃÊó±êµã»÷×óÀ¸ÏµÄ"web application folder" µÄ¼Óº ......
ÎҲſªÊ¼¿´ASP.NETÓëÊý¾Ý¿âµÄÁ¬½Ó£¬½ñÌìÒ»¿ªÊ¼¾ÍÒ»Á¬Óöµ½Èý¸öÎÊÌ⣬ÕÛÌÚÁËÒ»ÍíÉÏ...Ï£ÍûÎҲ鵽µÄ×ÊÁ϶Դó¼ÒÓÐÓá£
×î³õÎÒдµÄÓï¾äÊÇ£º
//Create the Connection
//SqlConnection conn = new SqlConnection(@"Data Source=(local)\NetSDK; Initial Catalog=Northwind; User ID = sa; password = yourPassword;");
ÉÏÃæÕâ ......
CheckBoxÑ¡Ôñ×é¼þÊÇÒ»¸ö³ÌÐòÖж¼¾³£µÄ×é¼þ¡£ÔÚ³ÌÐòÉè¼ÆÖÐʹÓõ½¸Ã×é¼þ£¬Ò»°ã¶¼²»»áֻʹÓõ½Ò»¸ö£¬ÍùÍùÊÇÒÔ¶à¸ö´ËÀà×é¼þµÄÐÎʽ³öÏֵġ£ÔÚASP.NETÒ³ÃæÖÐÈç¹ûҪʹÓõ½¶à¸öCheckBox×é¼þ£¬³ýÁËÌí¼Ó¶à¸öCheckBox×é¼þÔÚÒ³ÃæÖÐÖ®Í⣬»¹ÓÐÒ»ÖֱȽϷ½±ãµÄ·½·¨£¬¾ÍÊÇʹÓÃCheckBoxList ×é¼þ¡£CheckBoxList×é¼þÊÇÓÉÒ»×éµÄCheckBox×é¼þ×é ......
Ò»¡¢ÈÏʶWeb.configÎļþ
Web.config ÎļþÊÇÒ»¸öXMLÎı¾Îļþ£¬ËüÓÃÀ´´¢´æ ASP.NET Web Ó¦ÓóÌÐòµÄÅäÖÃÐÅÏ¢£¨Èç×î³£ÓõÄÉèÖÃASP.NET Web Ó¦ÓóÌÐòµÄÉí·ÝÑéÖ¤·½Ê½£©£¬Ëü¿ÉÒÔ³öÏÖÔÚÓ¦ÓóÌÐòµÄÿһ¸öĿ¼ÖС£µ±Äãͨ¹ý.NETн¨Ò»¸öWebÓ¦ÓóÌÐòºó£¬Ä¬ÈÏÇé¿öÏ»áÔÚ¸ùĿ¼×Ô¶¯´´½¨Ò»¸öĬÈϵÄWeb.configÎļþ£¬°üÀ¨Ä¬ÈÏ ......