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(); //¹Ø±ÕÊý¾Ý¿âµÄÁ´½Ó
Ïà¹ØÎĵµ£º
in µÄ»°£¬ Èç¹ûÊÇnull ¾Í²»±È½ÏÁË£¬¼È²»ÊÇin Ò²²»ÊÇ not in
existsµÄ»° ÒòΪÓà = ¼ÓÔÚÌõ¼þÀï±È½ÏÁË£¬ËùÒÔ null ÊÇ not exists
select *
from pricetemp
where cast(ÉÌÆ·¥³ー¥É as varchar(10))not in(
select shohin_cd
&nbs ......
/// <summary>
/// ×Ö·û´®Çиî
/// </summary>
/// <param name="p_SrcString"></param>
/// <param name="p_Length"></param>
/// <returns></returns>
public static string GetSubString(string p_SrcString, int ......
ASP.NETÈý²ã½á¹¹ËµÃ÷
ÍêÉÆµÄÈý²ã½á¹¹µÄÒªÇóÊÇ:Ð޸ıíÏÖ²ã¶ø²»ÓÃÐÞ¸ÄÂß¼²ã,ÐÞ¸ÄÂß¼²ã¶ø²»ÓÃÐÞ¸ÄÊý¾Ý²ã¡£·ñÔòÄãµÄÓ¦ÓÃÊDz»ÊǶà²ã½á¹¹,»òÕß˵ÊDzã½á¹¹µÄ»®·ÖºÍ×éÖ¯ÉÏÊDz»ÊÇÓÐÎÊÌâ¾ÍºÜÄÑ˵.²»Í¬µÄÓ¦ÓÃÓв»Í¬µÄÀí½â£¬ÕâÖ»ÊÇÒ»¸ö¸ÅÄîµÄÎÊÌ⣮
Àí½âASP.NETÈý²ã½á¹¹——ΪʲôҪ·ÖÈý²ã£¿
ÎÒÃÇÓÃÈý²ã½á¹¹Ö÷ÒªÊÇÊ¹Ï ......
Asp.net ÖÐÔÚ¿Í»§¶Ë´¥·¢·þÎñÆ÷¶Ëʼþ·ÖΪÁ½ÖÖÇé¿ö£º
Ò». WebControlsÖеÄButton ºÍHtmlControlsÖеÄTypeΪsubmitµÄHtmlInputButton
ÕâÁ½ÖÖ°´Å¥×îÖÕµ½¿Í»§¶ËµÄ±íÏÖÐÎʽΪ£º<input type="submit" value="Submit">£¬ÕâÊÇForm±íµ¥µÄÌá½»°´Å¥£¬µã»÷ÒÔºó»á×÷Ϊ²ÎÊý·¢Ë͵½·þÎñ¶Ë£¬²ÎÊýÊÇÕâÑùµÄ£º
¿Ø¼ ......
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 ......