ASP.netÒ³ÃæʵÏÖMSSQLÊý¾Ý¿âµÄ´´½¨ºÍ²Ù×÷£¬ÊÇ¿â´´½¨£¡
/// <summary>
/// ´´½¨Êý¾Ý¿â¡£
/// </summary>
/// <param name="srvName">±íʾҪÁ¬½ÓµÄ·þÎñÆ÷Ãû</param>
/// <param name="dbName">Ö¸¶¨Òª´´½¨µÄÊý¾Ý¿âÃû</param>
private string CreateDB(string srvName, string dbName)
{
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
SQLDMO.SQLServer srv = new SQLDMO.SQLServerClass();
srv.Connect(srvName, "sa", "");
// н¨Êý¾Ý¿âÃû(°üÀ¨Â·¾¶)
string dbPath = srv.Registry.SQLDataRoot + "\\DATA\\" + dbName;
bool DBExist = false;
foreach (SQLDMO.Database db in srv.Databases)
{
if (db.Name == dbName)
{
DBExist = true;
}
}
&nbs
Ïà¹ØÎĵµ£º
Èý²ã¼Ü¹¹
±íʾ²ã
ÒµÎñ²ã
Âß¼²ã ÎÒ¾õµÃÖ÷ÒªÊÇDALµÄЧÂÊ£¬Õâ¸ö²ãÓ¦¸ÃÓÃCOMʵÏÖ£¬µ«ÊÇÕâÑùµÄ»°£¬Èç¹ûÊÇDNAµÄ·À»ðǽÓÖ³ÉÁËÎÊÌâ¡£ »¹ÓУ¬·Ö²ãºóµÄ×ÊÔ´ÊÍ·ÅÎÊÌâ¡£ BLL²ãµÄÖ»·ÅÂß¼¹æÔò¾Í¿ÉÒÔÁË£¬ÓÃËüÀ´Á¬½ÓUIºÍDAL ÒµÎñÂß¼²ã(BLL)£ºÖ÷ÒªÊÇÕë¶Ô¾ßÌåµÄÎÊÌâµÄ²Ù×÷£¬Ò²¿ÉÒÔÀ ......
ÉÏһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÀûÓÃASP.NET MVC´´½¨×Ô¼ºµÄÒ³Ã棬ÔÚÎÄÕ½éÉÜÁËÈçºÎÀûÓÃViewDataÓÉControllerÏòViewÎļþ´«Öµ£¬ÄÇеÄÎÊÌâÔٴγöÏÖ£¬ÎÒÃdzýÁËÄÜÏÔʾaspxÎļþÍ⻹ÄÜÏÔʾÆäËüµÄÎļþô£¿
±¾ÎĽ«Ïêϸ½éÉÜÈçºÎÏòView´«Öµ¡£
Ò»¡¢ViewDataÓëTempDataÊôÐÔÀ´ÏòViewÒ³´«µÝ¶ÔÏó
ÉÏÎÄÖÐÒѾÌáµ½,ʹÓÃViewData¿ÉÒÔ½«Êý¾ÝÓÉCont ......
ºÃ¶àÈ˶ÔÏà¶Ô·¾¶Óë¾ø¶Ô·¾¶ÀÏÊÇ»ìÏý¼Ç²»Çå³þ£¬ÎÒ´ÓÕûÀíÁËһϣ¬Ï£Íû¶Ô´ó¼ÒµÄÈÏʶÓаïÖú¡£
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1.Request.ApplicationPath->µ±Ç°Ó¦ÓõÄĿ¼
JspÖÐ, ApplicationPathÖ¸µÄÊǵ±Ç°µÄapplication(Ó¦ÓóÌÐò)µÄĿ¼,ASP.NETÖÐÒ²ÊÇÕâ¸öÒâ˼¡£
¶ÔÓ¦ ......
1£© ¶àѡЧ¹û
¶àѡЧ¹ûÍêÈ«¿ÉÒÔͨ¹ý½Å±¾½øÐÐʵÏÖ¡£ÎÒÃÇÖªµÀ£¬¶àÑ¡µÄ¿Ø¼þ×îÖÕÉú³ÉÒ»¸öinputµÄHTML±êÇ©£¬ËüµÄÀàÐÍÊÇcheckbox¡£ÓÉÓÚÕâ¸öÒ³ÃæÖÐÖ»ÓÐÒ»×鸴ѡ¿ò£¬ËùÒÔʵÏÖÆðÀ´Ò²±È½Ï·½±ã£ºÎÒÃÇ¿ÉÒÔ±éÀúËùÓеÄinput±êÇ©£¬¶Ô±ÈÆätypeÊôÐÔÊDz»ÊÇcheckbox£¬Èç¹ûÊÇcheckbox£¬¾Í¸øËüÉèÖÃÏàÓ¦µÄÑ¡ÖÐ״̬¾ÍÐÐÁË¡£
´úÂëÈçÏ£º
<scri ......
ÏÂÔØ ADO.NET Driver for MySQLMySql.Data.dll
°²×°ºó£¬ÔÚ°²×°Ä¿Â¼ÏÂÃæÕÒµ½Assemblies
Îļþ¼Ð£¬ÕÒµ½ MySql.Data.dll
(´ËÎļþÊÇ.Net·ÃÎÊMySQLÊý¾Ý¿âµÄÒ»¸öÇý¶¯£¬ÍêÈ«ADO.NETÊý¾Ý·ÃÎÊģʽ£¬ÓÉMySQL¹Ù·½Ìṩ£¬Óжà¸ö°æ±¾¿ÉÑ¡Ôñ¡£)
ѧϰµÄÒ»¸öÁ´½Ó£ºhttp://www.cnblogs.com/wcfgroup/articles/1242256.html
´´½¨Ò»¸ö ......