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

ASP.NET·ÀSQL×¢Èë½Å±¾³ÌÐò

public class SqlCheck  
{  
    public SqlCheck()  
    {  
        //  
        // TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­  
        //     
    }  
 
      
    public SqlConnection oconn()  
    {  
        SqlConnection conn = new SqlConnection();  
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["StudyConnectionString"].ToString();  
        //µÚ1ÖÖµ÷Óõķ½·¨   JK1986_CheckSql();  
        JK1986_CheckSql();  
        if ( conn.State == ConnectionState.Closed  )   
        {  
            conn.Open();  
        }  
        return conn;  
    }  
 
 
    public DataTable  getsource(string getds)   
    {  
        SqlConnection conn = oconn();  
        SqlDataAdapter da = new SqlDataAdapter(getds, conn);  
        DataSet ds = new DataSet();  
        da.Fill(ds,"news" );  
        return ds.Tables["news"];  
 


Ïà¹ØÎĵµ£º

SQL Server 2005ÖÐдÎļþµÄ·½·¨

--´´½¨Ð´ÎļþµÄ´æ´¢¹ý³Ì
ALTER proc [dbo].[p_movefile]
 @filename varchar(1000),--Òª²Ù×÷µÄÎı¾ÎļþÃû  
 @text varchar(8000),   --ҪдÈëµÄÄÚÈÝ
 @obj int
as  
begin
 declare @err  int,
   @src  varchar(255),
 &n ......

oraleÖÐsqlÓï¾ä¶ÔnullÖµµÄ´¦Àí

µÚÒ»ÖÖ·½·¨£ºÊ¹ÓÃNVLº¯Êý´¦ÀíNULLÖµ¡£
ÆäÓï·¨¸ñʽÊÇNVL(exp1,exp2)¡£ÆäÖвÎÊýexp1ºÍexp2¿ÉÒÔʹÈÎÒâÊý¾ÝµÄÀàÐÍ£¬µ«Á½ÕßÊý¾ÝÀàÐͱØÐëÆ¥Å䡣ʾÀý£ºselect ename,sal,comm,sal+nvl(comm,0) as salary from emp;
µÚ¶þÖÖ·½·¨£ºÊ¹ÓÃNVL2º¯Êý´¦ÀíNULLÖµ¡£
ÆäÓï·¨¸ñʽÊÇNVL2(exp1,exp2,exp3)¡£ÕâÊÇoracle9iÐÂÔö¼ÓµÄº¯Êý¡£Èç¹ûexp1 ......

Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü


¡¡ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
¡¡¡¡select * from v$version;
¡¡¡¡²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
¡¡¡¡select sum(bytes)/(1024*1024) as free_space,tablespace_name
¡¡¡¡from dba_free_space
¡¡¡¡group by tablespace_name;
¡¡¡¡SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
¡¡¡¡(B.BYTE ......

asp.net¸öÈËѧϰÀú³Ì³õѧµ½¾«Í¨ ÊÕ²Ø

 asp.net¸öÈËѧϰÀú³Ì³õѧµ½¾«Í¨ ÊÕ²Ø
 Èç¹ûÄãÊÇÒ»¸ö²ËÄñ»òÕß×ÔÈÏΪ³õѧÕßÄÇô±¾Îķdz£ÊʺÏÄ㣻
²»ÄÜ˵Õâ30±¾Êé¾ÍÊÇ×î¼Ñ×éºÏ£¬µ«ÊÇ¿ÉÒÔ˵Õâ¸ö×éºÏ²»²î£»
±¾ÈËÔø²©ÀÀȺÊ飬ºÜ¶àÊéÖØ¸´£¬ºÜ¶àÊé½²µÄ²»ÊÊÓã¬ÕâЩÊé¶¼ÊÇĿǰÊéµê¿ÉÒÔÂòµ½µÄ£»
´ïµ½Öм¶³ÌÐòÔ±ÒÔºóÔõô³ÉΪ¸ß¼¶³ÌÐòÔ±¾Í¿¿Äã×Ô¼ºÁË£¬¶ø´ËʱÄãÒѾ­ ......

asp.net ·µ»ØÉÏÒ»Ò³µÄʵÏÖ·½·¨

·µ»ØÉÏÒ»Ò³µÄÕâ¸ö¶«¶«ÔÚÎÒÃÇ×öÏîÄ¿µÄʱºòÒ»°ãÊÇÓÃÓÚÌîдÍê±íµ¥ºóÈ·ÈϵÄʱºò£¬ÓжÔÔ­À´ÊäÈëµÄÊý¾Ý½øÐÐÐÞ¸Äʱ
Óõ쬻òÕßÊÇÒòÎªÍøÕ¾ÎªÁË·½±ãä¯ÀÀÕß¶øÓÐÐÄÌí¼ÓµÄÒ»¸ö¶«¶«£¬Ò»°ãÕâÖÖ¹¦ÄܵÄʵÏÖÔÚASP.netÖж¼ÊÇÓÃÒ»¸öbuttonµÄ¿Ø¼þÀ´ÊµÏֵģ¬ÊµÏֵķ½·¨ÓкÜ
¶à£¬½ñÌìÇ¡ºÃÔÚ×öÏîĿʱÅöµ½ÒªÓÃÕâ¸ö¶«¶«£¬ÎҾͰÑÄÜʵÏÖ" · ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ