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
Ïà¹ØÎĵµ£º
public class DBHelper
{
private static SqlConnection connection;
public static SqlConnection Connection
{
&nb ......
Èý²ã¼Ü¹¹
±íʾ²ã
ÒµÎñ²ã
Âß¼²ã ÎÒ¾õµÃÖ÷ÒªÊÇDALµÄЧÂÊ£¬Õâ¸ö²ãÓ¦¸ÃÓÃCOMʵÏÖ£¬µ«ÊÇÕâÑùµÄ»°£¬Èç¹ûÊÇDNAµÄ·À»ðǽÓÖ³ÉÁËÎÊÌâ¡£ »¹ÓУ¬·Ö²ãºóµÄ×ÊÔ´ÊÍ·ÅÎÊÌâ¡£ BLL²ãµÄÖ»·ÅÂß¼¹æÔò¾Í¿ÉÒÔÁË£¬ÓÃËüÀ´Á¬½ÓUIºÍDAL ÒµÎñÂß¼²ã(BLL)£ºÖ÷ÒªÊÇÕë¶Ô¾ßÌåµÄÎÊÌâµÄ²Ù×÷£¬Ò²¿ÉÒÔÀ ......
µÚÒ»ÖÖ
<%=RetInfo("DB","Êý¾Ý¿â") %>
<%=RetInfo("YX_UpFile","ÉÏ´«Îļþ") %>
<%=RetfileInfo("Include/", "¹ã¸æ")%>
//´Óǰ̨µ÷Óúǫ́·½·¨
//´Óǰ̨µ÷Óúǫ́µÄ·½·¨..²¢ÏòÆä·½·¨´«È벻ͬµÄ²ÎÊý!
µÚ¶þÖÖ
<ItemTemplate >
<%#Ret_stat(Convert.ToInt16(Eval("YX_Stat1")), "Èȵã")%>
......
ǰ̨´úÂ룺
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="articleview.aspx.cs" Inherits="articleview" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"> ......