Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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"];  
 


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

asp.net³£¼ûÆß´óÄÚÖöÔÏó

Ò»¡¢Response¶ÔÏó
Response¶ÔÏóÊÇHttpResponseÀàµÄÒ»¸öʵÀý¡£¸ÃÀàÖ÷ÒªÊÇ·â×°À´×ÔASP.NET²Ù×÷µÄHTTPÏìÓ¦ÐÅÏ¢¡£
1.Response¶ÔÏóµÄÊôÐÔ
   ¢Ù BufferOutput
   ˵Ã÷£º»ñÈ¡»òÉèÖÃÒ»¸öÖµ£¬¸ÃֵָʾÊÇ·ñ»º³åÊä³ö£¬²¢ÔÚÍê³É´¦ÀíÕû¸öÒ³Ö®ºó½«Æä·¢ËÍ
   ÊôÐÔÖµ£ºÈç¹û»º³åÁ˵½¿Í»§¶ËµÄÊä³ö£¬ ......

ÁÙʱ±íÔÚSQL ServerºÍMySqlÖд´½¨µÄ·½·¨

SQL Server´´½¨ÁÙʱ±í£º
´´½¨ÁÙʱ±í
·½·¨Ò»£º
create table #ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
create table ##ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
·½·¨¶þ£º
select * into #ÁÙʱ±íÃû from ÄãµÄ±í;
select * into ##ÁÙʱ±íÃû from ÄãµÄ±í;
×¢£ºÒÔÉϵÄ#´ú±í¾Ö²¿ÁÙʱ±í£¬##´ú±íÈ«¾ ......

Sql Server 2005 ExpressÆôÓÃsaÕÊ»§

ÎÊÌâÃèÊö£º
       Express°æÓÃsaÕÊ»§µÇ¼ʱʧ°Ü
½â¾ö·½°¸£º
       µÚÒ»²½£ºÓÃWindowsÉí·ÝµÇ¼Management Studio£¬ÓÒ»÷·þÎñÆ÷Ñ¡ÔñÊôÐÔ£¬½«°²È«ÐÔÑ¡Ïî ¸ü¸ÄΪ:SQL Server ºÍ Windows
Éí·ÝÑéÖ¤
         & ......

asp.net mvc¿ò¼ÜÖÐjsonÐòÁл¯µÄ¿ØÖÆ

ÏÈ¿´ÏÂÃæµÄÒ»¶Î´úÂ룺
 public class UserTest
        {
           public int age { set; get;
}          
¡¡¡¡¡¡¡¡ public string name { set; get; }  & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ