asp.netÒ»Ò¹Ëٳɣº×ܽá&ÉîÈë
ÃüÃû¿Õ¼ä£º
Socut.Data
//##################### CData Àà #####################
ʵÏÖ¹¦ÄÜ£º¶ÁÈ¡(DataSet·½Ê½)£¬²åÈ룬¸üУ¬É¾³ý£¬Í³¼Æ
µ÷Ó÷½·¨£º
public CData myData=new CData();
ʵ¼Ê²Ù×÷£º
1,¶ÁÈ¡
public DataSet ds=new DataSet(); //´ËDataSetÀàÒѾÓÉ΢Èí·â×°Ìṩ
ds=myData.GetDataSet("SELECT * from ±í WHERE Ìõ¼þ",¿ªÊ¼ÐÐ,¶àÉÙÐÐ,"ÐéÄâ±íÃû");
2,²åÈë
myData.GetExecuteNonQuery("INSERT INTO ±í (ÁÐ1£¬ÁÐ2) VALUES (±äÁ¿1,±äÁ¿2)");
2,¸üÐÂ
myData.GetExecuteNonQuery("UPDATE ±í SET ÁÐ1=±äÁ¿A,ÁÐ2=±äÁ¿B WHERE Ìõ¼þ");
3,ɾ³ý
myData.GetExecuteNonQuery("DELETE ±í WHERE Ìõ¼þ");
5,ͳ¼Æ
myData.GetExecuteScalar("SELECT * from ±í WHERE Ìõ¼þ",ͳ¼ÆÀàÐÍ)
ͳ¼ÆÀàÐÍ·ÖÁ½ÖÖ£º
int ÕûÐÍ£º1
double ´øСÊýµã£º2 (¼ÇÒä·½·¨£ºÈç¹ûÄãÖªµÀdoubleÔÚÓ¢Îĵ¥´ÊÖÐÓГ˫±¶”µÄÒâ˼£¬ÄÇôÀàÐͶÔÓ¦Öµ×ÔÈ»¿ÉÒÔÁªÏëµ½“2”)
//##################### CReaderÀà #####################
ʵÏÖ¹¦ÄÜ£º¶ÁÈ¡(DataReaderÔĶÁÆ÷·½Ê½)
µ÷Ó÷½·¨£º
public CReader dr;
ʵ¼Ê²Ù×÷£º
dr=new CReader("SELECT * from ±í WHERE Ìõ¼þ");
//--------------------------------------------
if(dr.Read())
{
//Èç¹ûÌض¨Ìõ¼þµÄÖµ´æÔÚ£¬Á¢¼´ÖÕÖ¹ÏÂÒ»ÐеĶÁÈ¡
}//--------------------------------------------
while(dr.Read)
{
//Ñ»·¶ÁÈ¡·ûºÏÌõ¼þµÄÖµ
}//--------------------------------------------
µ÷ÓöÁÈ¡³öÀ´µÄÖµ£º
dr["ÁÐÃû"]
ʹÓÃÍêºó¹Ø±Õ£ºdr.Close();
//##################### ¸ü¶àÀ©Õ¹¹¦ÄÜ #####################
1£¬ÈçºÎʵÏÖËÑË÷¹¦ÄÜ£¿
´ð£ºÊ¹ÓÃGetDataSet£¬»òÊÇCreader¶¼¿ÉÒÔʵÏֵģ¬ÒòΪËü¸ù±¾¾ÍÊÇÒ»¸öÊý¾Ý¿âÄÚÈݵĶÁÈ¡¡£¹Ø¼üµÄÖ»ÊÇSQLÓï¾äµÄʹÓã¬Ó¦¸ÃΪSELECT * from ±íÃû1 WHERE ÁÐ1 LIKE ‘ÒªËÑË÷µÄ¹Ø¼ü×Ö’
2£¬ÈçºÎʵÏÖÎÄÕÂÔĶÁ×ÜÊýµÄͳ¼Æ£¿
´ð£ºÐèÒª½«ËùÓзûºÏÒªÇóµÄÁÐ×÷Ò»´Î¼Ó·¨ÔËË㣬ʹÓÃGetExecuteScalarµÄͳ¼Æ¹¦ÄܾͿÉÒÔʵÏÖÁË£¬Ê¾Àý£ºdouble d1=(double)GetExecuteScalar(“SELECT SUM(Ҫͳ¼ÆµÄÁÐÃû) from ±íÃû1 WHERE Ìõ¼þ”,2);
3£¬ÎÒÈçºÎ¿ª·¢ÂÛ̳£¬»òÊÇÉ̳ǣ¿
´ð£ºÂÛ̳µÄ¹¦Äܼ¸ºõ¸úÐÂÎÅϵͳһÑùµÄ£¬ÄãÖ»ÒªÔÙ¼ÓÒ»¸ö»Ø¸´¹¦ÄÜ¡£Ìáʾ£ºÔÚÔÐÂÎűíÖÐн¨Ò»ÁУ¬0´ú±íÖ÷Ìù£¬´óÓÚ0µÄÊý£¬Ôò´ú±í´ËÌùÊǸúÌù¡¢ËùÒª¸úÌùµÄÖ÷ÌùIDÊÇXX¡£É̳ǵĹºÎï³µ£¬ÊÂʵÉϾÍÊÇ
Ïà¹ØÎĵµ£º
1.ASP.NETÔËÐÐÔÀí¸ÅÊö
¡¡¡¡ÈçÉÏͼ£¬µ±Ò»¸öhttpÇëÇó·¢Ë͹ýÀ´²¢±»IIS»úÊÕµ½Ö®ºó,IISÊ×ÏÈͨ¹ýÄãÇëÇóµÄÒ³ÃæÀàÐÍΪÆä¼ÓÔØÏàÓ¦µÄdllÎļþ£¬È»ºóÔÚ´¦Àí¹ý³ÌÖн«ÕâÌõÇëÇó·¢Ë͸øÄܹ»´¦ÀíÕâÌõÇëÇóµÄÄ£¿é,¶øÔÚASP.NETÖÐÕâ¸öÄ£¿é¾Í½Ð×öHttpHandler,ΪʲôaspxÕâÑùµÄÎļþ¿ÉÒÔ±»·þÎñÆ÷´¦Àí,ÄÇÊÇÒòΪÔÚ·þÎñÆ÷¶ËÓÐĬÈϵÄHttpHandlerרÃÅ´ ......
asp.netʵÏÖα¾²Ì¬
Ò»¡¢Î±¾²Ì¬µÄÓô¦
ÓÐЩÓû§
¾õµÃ£¬Î±¾²Ì¬ºÍÕ澲̬ʵ¼Ê±»ÊÕ¼Á¿»áÏà²îºÜ´ó£¬Æäʵ²»È»£¬´ÓÄã¸öÈ˽Ƕȣ¬Äã
È¥ÅжÏÒ»ÏÂÒ»¸öÌû×Óµ½µ×ÊÇÕ澲̬»¹ÊÇα¾²Ì¬£¿¹À¼ÆºÜÄÑ¿´µÃ³ö£¬ÒòΪËùν¾²Ì¬µÄÒâ˼£¬¾ÍÊǵØÖ·Öв»´øÎʺţ¬²»´øÎʺŵľÍÊǾ²Ì¬£¬¹ÜËûÊÇÕæµÄ»¹ÊÇαµÄ£¿ËÑË÷Òý
Çæ¿´µÃ³öÂð£¿ËùÒÔ˵£¬Æäʵ² ......
Ò»¡¢Ê²Ã´ÊÇSQL×¢Èëʽ¹¥»÷?
¡¡¡¡ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°ÑSQLÃüÁî²åÈëµ½Web±íµ¥µÄÊäÈëÓò»òÒ³ÃæÇëÇóµÄ²éѯ×Ö·û´®£¬ÆÛÆ·þÎñÆ÷Ö´ÐжñÒâµÄSQLÃüÁî¡£ÔÚijЩ±í
µ¥ÖУ¬Óû§ÊäÈëµÄÄÚÈÝÖ±½ÓÓÃÀ´¹¹Ôì(»òÕßÓ°Ïì)¶¯Ì¬SQLÃüÁ»ò×÷Ϊ´æ´¢¹ý³ÌµÄÊäÈë²ÎÊý£¬ÕâÀà±íµ¥ÌرðÈÝÒ×Êܵ½SQL×¢Èëʽ¹¥»÷¡£³£¼ûµÄSQL×¢Èëʽ¹¥
»÷¹ý³ÌÀàÈ磺
......
֮ǰҲÊÇÔÚÍøÉÏÕÒµÄdotMsn¿ÉÒÔ»ñÈ¡ÁË£¬Ö®ºóÓÖÔÚÍøÉÏ¿´µ½ËµÊÇmsnÉý¼¶ÁËdotMsn»ñÈ¡²»µ½ÁË£¬Ôõô°ìÄÇ£¬ÎÒÏÖÔÚÔÚ×öÒ»¸öÉçÇøÍø£¬ÀïÃæÓÐÑûÇëºÃÓѼÓÈëµÄ¹¦ÄÜ£¬ÐèÒª»ñÈ¡µ½msnµÄÁªÏµÈË£¬Èç¹ûÓÐÄÄλ¸ßÊÖÖªµÀµÄ£¬Âé·³¸øÎÒ·¢Ò»·Ý£¬ÏÈллÁË£¡msn:gongchuanbo@live.cn ,qq:476759761 ......
µÚÒ»ÖÖ
ÊÇͨ¹ýµ÷ÓÃwindow media player½øÐв¥·ÅÖîÈ磺wmv,asfµÈ¸ñʽÎļþ:
<object align=center class=OBJECT classid=CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95 height=320 id=MediaPlayer width=356>
<param name="ShowStatusBar" value="-1">
<param name="Filename" value="µçÓ°µØÖ·">
& ......