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

asp.net´Ósql server2005ÖвéѯÊý¾Ý

 Ê×ÏÈÒªÌí¼Ó
using System.Data;
using System.Data.SqlClient;    
½ÓÏÂÀ´£º
          SqlConnection conn = new SqlConnection("server=QLPC\\SQL2005;uid=sa;pwd=£¨ÄãµÄÃÜÂ룩;database=£¨ÄãµÄÊý¾Ý±í£©");                  //ÓÃÓÚÁ¬½ÓÊý¾Ý¿â
            conn.Open();       //´ò¿ªÊý¾Ý¿â
            SqlCommand cmd = new SqlCommand("select * from [user]", conn);              //Ï൱ÓÚÖ´ÐÐÊý¾ÝÓï¾ä°É
            SqlDataReader read = cmd.ExecuteReader();                                   //´´½¨Ò»¸öSqlDataReaderµÄreadÏó  
            while (read.Read())                                                  //µ±¶ÁÈ¡µÄÊý¾Ý´æÔÚʱÔòд³öÀ´
            {
                Response.Write(read[0]);
            }
conn.close();                //¹Ø±ÕÊý¾Ý¿âµÄÁ´½Ó


Ïà¹ØÎĵµ£º

sql serverÖÐinºÍexistsµÄÐ¡Çø±ð oracleδ²âÊÔ

in µÄ»°£¬ Èç¹ûÊÇnull ¾Í²»±È½ÏÁË£¬¼È²»ÊÇin Ò²²»ÊÇ not in
existsµÄ»° ÒòΪÓà = ¼ÓÔÚÌõ¼þÀï±È½ÏÁË£¬ËùÒÔ null ÊÇ not exists
select *
from pricetemp
where cast(ÉÌÆ·¥³ー¥É as varchar(10))not in(
           select shohin_cd
  &nbs ......

[ת]asp.netÇø·ÖÖÐÓ¢ÎÄ×Ö·û´®½ØÈ¡

/// <summary>
/// ×Ö·û´®Çиî
/// </summary>
/// <param name="p_SrcString"></param>
/// <param name="p_Length"></param>
/// <returns></returns>
public static string GetSubString(string p_SrcString, int ......

ASP.NETÈý²ã¼Ü¹¹µÄ˵Ã÷¼°Èý²ã¼Ü¹¹µÄÌØµã

ASP.NETÈý²ã½á¹¹ËµÃ÷
ÍêÉÆµÄÈý²ã½á¹¹µÄÒªÇóÊÇ:Ð޸ıíÏÖ²ã¶ø²»ÓÃÐÞ¸ÄÂß¼­²ã,ÐÞ¸ÄÂß¼­²ã¶ø²»ÓÃÐÞ¸ÄÊý¾Ý²ã¡£·ñÔòÄãµÄÓ¦ÓÃÊDz»ÊǶà²ã½á¹¹,»òÕß˵ÊDzã½á¹¹µÄ»®·ÖºÍ×éÖ¯ÉÏÊDz»ÊÇÓÐÎÊÌâ¾ÍºÜÄÑ˵.²»Í¬µÄÓ¦ÓÃÓв»Í¬µÄÀí½â£¬ÕâÖ»ÊÇÒ»¸ö¸ÅÄîµÄÎÊÌ⣮
Àí½âASP.NETÈý²ã½á¹¹——ΪʲôҪ·ÖÈý²ã£¿
ÎÒÃÇÓÃÈý²ã½á¹¹Ö÷ÒªÊÇÊ¹Ï ......

asp.netÒ³Ãæ»Ø´«Óëjsµ÷Ó÷þÎñ¶Ëʼþ£¬PostbackµÄÔ­Àí

 
Asp.net ÖÐÔÚ¿Í»§¶Ë´¥·¢·þÎñÆ÷¶Ëʼþ·ÖΪÁ½ÖÖÇé¿ö£º
Ò».   WebControlsÖеÄButton ºÍHtmlControlsÖеÄTypeΪsubmitµÄHtmlInputButton
ÕâÁ½ÖÖ°´Å¥×îÖÕµ½¿Í»§¶ËµÄ±íÏÖÐÎʽΪ£º<input type="submit" value="Submit">£¬ÕâÊÇForm±íµ¥µÄÌá½»°´Å¥£¬µã»÷ÒÔºó»á×÷Ϊ²ÎÊý·¢Ë͵½·þÎñ¶Ë£¬²ÎÊýÊÇÕâÑùµÄ£º
¿Ø¼ ......

ASP.NET±ÊÊÔÌâÄ¿

 ADO.NET³ÌÐòÉè¼ÆÄ£ÄâÌâ(¹²206Ìâ)
1
ADO.NET Ä£ÐÍÖеÄÏÂÁÐÄÄЩ¶ÔÏóÊôÓÚConnected ¶ÔÏó
A. Connection
B. DataAdapter
C. DataReader
D. DataSet
ÕýÈ·´ð°¸:ABC
2
ÔÚADO.NET ÖÐ,Ϊ·ÃÎÊDataTable ¶ÔÏó´ÓÊý¾ÝÔ´ÌáÈ¡µÄÊý¾ÝÐÐ.¿ÉʹÓÃDataTable ¶ÔÏóµÄ_______ÊôÐÔ.
A. Rows
B. Columns
C. Constraints
D. Data ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ