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
Ïà¹ØÎĵµ£º
SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
SqlCommand cmdAdd = new SqlCommand( "Community_Disc ......
ÏÂͼÖкìÉ«¼ýÍ·ÊǸ¸Àà ¶øÇÒÊôÓÚ¸ùĿ¼¼¶±ð¡£
¡¡¡¡ÏÂÃæ¸ö×Ö¶ÎΪ£ºID¡¡¡¡¸¸ID¡¡ ÀàÐÍÃû³Æ¡¡ Éî¶È¡¡ ÅÅÐò
¡¡¡¡Ç°Ãæ3¸ö×Ö¶ÎûÓÐʲô¿É½âÊ͵ģ¬×ö¹ýÎÞÏÞ¼¶·ÖÀàÉè¼ÆµÄÈ˶¼Ó¦¸ÃÇå³þ
¡¡¡¡¶øµÚ5¸ö×Ö¶ÎÅÅÐò×Ö¶ÎID£º43µÄ23ÅÅÐò´ú±íËûÔÚÕâÕűíÅÅÔÚ23µÄ¸ùĿ¼
¡¡¡¡¶ø23ÏÂÃæµÄ23,01 ˵Ã÷ËûÊÇ2¼¶·ÖÀ࣬ÅÅÔÚ23ÏÂÃæµÄµÚ01¸ö£¬Ò²ÊÇÖ§³Ö99¼ ......
Ö÷Ìå¼Ü¹¹
¡¡¡¡¸÷ƵµÀ·Ö±ðλÓÚ²»Í¬µÄWeb Project(¾ßÓжÀÁ¢µÄ¶þ¼¶ÓòÃû)£¬²¢½«ËùÓеÄÒµÎñÂß¼ÒÔ¼°Êý¾Ý·ÃÎʹ¦ÄÜ·â×°³ÉClass Library£¬ËùÓÐƵµÀ¹²ÓÃÕâ¸öClass Library¡£
¡¡¡¡ÏÂÃæÏêϸ½éÉÜʵÏÖ·½·¨¡£
¡¡¡¡¼ÙÉèÍøÕ¾ÓÐÈý¸öƵµÀ£¬ÐÂÎÅ¡¢ÂÛ̳ÒÔ¼°²©¿Í£¬¶ÔÓ¦µÄ¶þ¼¶ÓòÃûΪ"news"¡¢"forum"¡¢"blog"¡£³ý´ËÖ®Í⣬»¹ÐèÒªÁ ......
ÅäÖÃASP.NETƽ̨ʱÓöµ½µÄ“·ÃÎÊIISÔªÊý¾Ý¿âʧ°Ü”²»ÖªµÀΪʲô½ñÌìÎÒµÄIISÍ£Ö¹ÁË£¬Í£Ö¹ÁËÎÒ¾ÍÆô¶¯Ï°ѣ¬¿ÉÊÇÆô¶¯²»ÆðÀ´Ñ½£¬ÄÇÔõô°ìѽ£¬Îʰٶȣ¬È˼Ò˵µÄÓиö·þÎñworld wide web Publishing ·þÎñ£¬¿ÉÊÇÎÒ»ú×ÓÉÏÁ¬Õâ¸ö·þÎñ¶¼Ã»ÓУ¬Ã»°ì·¨ÕÒ°Ñ£¬ÕÒÁË°ëÌìûÕÒµ½£¬Ö»ÓдÓа²×°ÁË£¬°²×°Á˺ÃÁË£¬Æô¶¯ÁË£¬ÓÖ³öÏ ......