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

asp.net Êý¾Ý¿â²Ù×÷

ASP.NET²Ù×÷Êý¾Ý¿â
ͨ¹ý¶ÔADO.NETµÄ»ù±¾½²½â£¬ÒÔ¼°½²½âÁËһЩÊý¾ÝÔ´¿Ø¼þµÄ»ù±¾Ó÷¨ºó£¬±¾Õ½«½éÉÜһЩASP.NET²Ù×÷Êý¾Ý¿âµÄ¸ß¼¶Ó÷¨£¬°üÀ¨Ê¹ÓÃSQLHelper£¬ÒÔ¼°Êý¾ÝÔ´¿Ø¼þ¶ÔÊý¾ÝµÄ²Ù×÷¡£±¾ÕÂÊǶÔÇ°ÃæµÄÊý¾Ý¿â֪ʶµÄÒ»ÖÖ²¹³äºÍÌáÉý¡£
9.1  ʹÓÃADO.NET²Ù×÷Êý¾Ý¿â
ÉÏÒ»ÕÂÖнéÉÜÁËADO.NETµÄ»ù±¾¸ÅÄî¡¢ADO.NETµÄ¶ÔÏó£¬ÒÔ¼°ÈçºÎʹÓÃADO.NET¡£Ê¹ÓÃADO.NETÄܹ»¼«´óµÄ·½±ã¿ª·¢ÈËÔ±¶ÔÊý¾Ý¿â½øÐвÙ×÷¶øÎÞÐè¹ØÐÄÊý¾Ý¿âµ×²ãÖ®¼äµÄÔËÐУ¬ADO.NET²»½ö°üÀ¨¶à¸ö¶ÔÏó£¬Í¬Ñù°üÀ¨¶àÖÖ·½·¨£¬ÕâЩ·½·¨¶¼¿ÉÒÔÓÃÀ´Ö´Ðпª·¢ÈËÔ±Ö¸¶¨µÄSQLÓï¾ä£¬µ«ÊÇÕâЩ·½·¨ÊµÏÖ¹ý³ÌÓÖ²»¾¡Ïàͬ£¬±¾½Ú½«½éÉÜADO.NETÖÐÊý¾ÝµÄ²Ù×÷·½·¨¡£
9.1.1  ʹÓÃExecuteReader()²Ù×÷Êý¾Ý¿â
ʹÓÃExecuteReader()²Ù×÷Êý¾Ý¿â£¬ExecuteReader()·½·¨·µ»ØµÄÊÇÒ»¸öSqlDataReader¶ÔÏó»òOleDbDataReader¶ÔÏó¡£µ±Ê¹ÓÃDataReader¶ÔÏóʱ£¬²»»áÏñDataSetÄÇÑùÌṩÎÞÁ¬½ÓµÄÊý¾Ý¿â¸±±¾£¬DataReaderÀà±»Éè¼ÆÎª²úÉúÖ»¶Á¡¢Ö»½øµÄÊý¾ÝÁ÷¡£ÕâЩÊý¾ÝÁ÷¶¼ÊÇ´ÓÊý¾Ý¿â·µ»ØµÄ¡£ËùÒÔ£¬Ã¿´ÎµÄ·ÃÎÊ»ò²Ù×÷Ö»ÓÐÒ»¸ö¼Ç¼±£´æÔÚ·þÎñÆ÷µÄÄÚ´æÖС£
Ïà±ÈÓëDataSet¶øÑÔ£¬DataReader¾ßÓнϿìµÄ·ÃÎÊÄÜÁ¦£¬²¢ÇÒÄܹ»Ê¹ÓýÏÉٵķþÎñÆ÷×ÊÔ´¡£DataReader¶ÔÏóÌṩÁË“Óαê”ÐÎʽµÄ¶ÁÈ¡·½·¨£¬µ±´Ó½á¹ûÖжÁÈ¡ÁËÒ»ÐУ¬Ôò“Óαꔻá¼ÌÐø¶ÁÈ¡µ½ÏÂÒ»ÐС£Í¨¹ýRead·½·¨¿ÉÒÔÅжÏÊý¾ÝÊÇ·ñ»¹ÓÐÏÂÒ»ÐУ¬Èç¹û´æÔÚÊý¾Ý£¬Ôò¼ÌÐøÔËÐв¢·µ»Øtrue£¬·ñÔò·µ»Øfalse¡£Ê¾Àý´úÂëÈçÏÂËùʾ¡£
            string str = "server='(local)';database='mytable';uid='sa';pwd='sa'";
            SqlConnection con = new SqlConnection(str);
            con.Open();                                                                              


Ïà¹ØÎĵµ£º

ÓÃasp.net»¹Ô­Óë»Ö¸´sqlserverÊý¾Ý¿â

  
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹Ô­ºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ­×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô­»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô­£¬»¹Ô­µÄʱºòÎÊÌ ......

ASP.NETµÄ´íÎó´¦Àí»úÖÆ

¶ÔWebÓ¦ÓóÌÐòÀ´Ëµ£¬·¢Éú²»¿ÉÔ¤ÖªµÄ´íÎóºÍÒì³£ÔÚËùÄÑÃ⣬ÎÒÃDZØÐëΪWeb³ÌÐòÌṩ´íÎó´¦Àí»úÖÆ¡£µ±´íÎó·¢Éúʱ£¬ÎÒÃDZØÐë×öºÃÁ½¼þÊÂÇ飺һÊǽ«´íÎóÐÅÏ¢¼Ç¼ÈÕÖ¾£¬·¢ÓʼþÍ¨ÖªÍøÕ¾Î¬»¤ÈËÔ±£¬·½±ã¼¼ÊõÈËÔ±¶Ô´íÎó½øÐиú×Ù´¦Àí£»
¶þÊÇÒÔÓѺõķ½Ê½Ìáʾ×îÖÕÓû§Ò³Ãæ·¢ÉúÁË´íÎ󣬶ø²»Äܽ«Î´´¦ÀíµÄ´íÎóÐÅÏ¢ÏÔʾ¸øÓû§¡£
 
&nbs ......

Asp.net Ò³Ãæ´«ÖµÖ® @ PreviousPageType Ö¸Áî¡£

¸ø³öÈçÏÂÀý×Ó ÎÒÖ»ÖªµÀÕâÑù×ö¿ÉÒÔµ÷ÓÃÉÏÒ»¸öÒ³Ãæ µÄÖµ»òÕß·½·¨ µ«ÊÇÎÒ²»ÖªµÀÔ­ÀíºÍËüµÄÓÅÂÔ
Çë¸ßÊÖ ¼ÓÒÔÖ¸µã ´ó¼Ò¹²Í¬Ñ§Ï° лл£¡
1.Default.aspx Ò³Ãæ
protected void but1_Click(object sender, EventArgs e)
    {
        Server.Transfer("Default2.aspx"); ......

ÔÚASP.NETÖзÃÎÊDataGridÖÐËùÓпؼþµÄÖµ

<%@ Page Language="C#" %>
<%@ import Namespace="System.Collections" %>
<script runat="server">
void Page_Load(Object sender, EventArgs e) {
if(!Page.IsPostBack){
ArrayList data = new ArrayList();
data.Add(new Person("Tom",33,true));
data.Add(new Person("Jhon",39,false));
da ......

asp.netÈý²ã½á¹¹Àý×Ó

ÕÒµ½Ò»±é½²½âÈý²ã½á¹¹±È½ÏÇå³þÒ×¶®µÄÎÄÕ£¬ÒýÓÃһϣ¬ÁôΪѧϰ¡£
Èý²ãʽ¿ª·¢ÖеIJã´Î»®·ÖÌÖÂÛ
ÏȾÙÒ»¸öÔø¾­ÔÚÄı¾ÊéÉÏ¿´µ½µÄÀý×Ó£ºÏÖÔÚÄãÏëÔÚ1Ã׿íµÄСϪÉϽ¨Ò»×ùÇÅ£¬Äã»áÔÚÉÏÃæ·Å¿éľ°å¾ÍÍêÁË¡£Èç¹ûÏëÔÚ¿íÒ»µãµÄСºÓÉϽ¨ÕâÇÅ£¬Äã¾ÍÐèÒª¼ÆËãľ²ÄÓÃÁÏ£¬¼Û¸ñµÈ£¬Èç¹ûÐèÒª±ðÈ˰ïæ£¬Ä㻹Ҫ¶àһЩͼֽʲôµÄÈñðÈËÀí½âÄãµÄÏë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ