Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

asp.net DBHelp.cs

 
 public class DBHelper
    {
        private static SqlConnection connection;
        public static SqlConnection Connection
        {
    &nb ......

ASP.NET¶à²ã½á¹¹

  Èý²ã¼Ü¹¹
±íʾ²ã 
ÒµÎñ²ã 
Âß¼­²ã  ÎÒ¾õµÃÖ÷ÒªÊÇDALµÄЧÂÊ£¬Õâ¸ö²ãÓ¦¸ÃÓÃCOMʵÏÖ£¬µ«ÊÇÕâÑùµÄ»°£¬Èç¹ûÊÇDNAµÄ·À»ðǽÓÖ³ÉÁËÎÊÌâ¡£  »¹ÓУ¬·Ö²ãºóµÄ×ÊÔ´ÊÍ·ÅÎÊÌâ¡£  BLL²ãµÄÖ»·ÅÂß¼­¹æÔò¾Í¿ÉÒÔÁË£¬ÓÃËüÀ´Á¬½ÓUIºÍDAL ÒµÎñÂß¼­²ã(BLL)£ºÖ÷ÒªÊÇÕë¶Ô¾ßÌåµÄÎÊÌâµÄ²Ù×÷£¬Ò²¿ÉÒÔÀ ......

c#(asp.net)¼¸Öв»Í¬´ÓÇ°Ì¨Ò³Ãæ²Ù×÷ºǫ́

µÚÒ»ÖÖ
<%=RetInfo("DB","Êý¾Ý¿â") %>
<%=RetInfo("YX_UpFile","ÉÏ´«Îļþ") %>
<%=RetfileInfo("Include/", "¹ã¸æ")%>
//´Óǰ̨µ÷Óúǫ́·½·¨
//´Óǰ̨µ÷Óúǫ́µÄ·½·¨..²¢ÏòÆä·½·¨´«È벻ͬµÄ²ÎÊý!
µÚ¶þÖÖ
<ItemTemplate >
<%#Ret_stat(Convert.ToInt16(Eval("YX_Stat1")), "Èȵã")%> ......

asp.net ³¤ÄÚÈÝÎÄÕÂ×Ô¶¯·ÖÒ³

ǰ̨´úÂ룺
<%@ 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"> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ