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

ASP.NETÖ´Ðд洢¹ý³Ì£¬²¢»ñÈ¡´æ´¢¹ý³ÌµÄ·µ»ØÖµ


ASP.NETÖ´Ðд洢¹ý³Ì£¬²¢»ñÈ¡´æ´¢¹ý³ÌµÄ·µ»ØÖµ

    Ò»¸ö¼òµ¥Àý×ÓÈçÏ£º
      1¡¢´´½¨´æ´¢¹ý³Ì£¨ÓÃÓÚÓû§Éí·ÝÑéÖ¤£©£º
      Create Procedure CheckUser
    (
     @userid char(20),
     @userpsw char(20)
     )
    as
     if exists(select * from tb_UserInfo where rtrim(UserID)=@userid and rtrim(UserPsw)=@userpsw)
      return 1
     else
      return 0
     2¡¢Asp.netÖ´ÐдúÂ룺
        //Á¬½ÓÊý¾Ý¿â
        string myStr = ConfigurationManager.AppSettings["connectionstring"].ToString();
        SqlConnection myConn = new SqlConnection(myStr);
        myConn.Open();
        //´´½¨SqlCommand¶ÔÏó
        SqlCommand cmd = new SqlCommand("CheckUser
",myConn);
        cmd.CommandType = CommandType.StoredProcedure;
       
        //Ìí¼Ó²ÎÊý
        SqlParameter Userid = cmd.Parameters.Add("@Userid", SqlDbType.Char);
        SqlParameter Userpsw= cmd.Parameters.Add("@Userpsw", SqlDbType.Char);
        SqlParameter returnvalue = cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
        
        //Ö¸¶¨²ÎÊýÊÇÖ»¿ÉÊäÈë(Input)¡¢Êä³ö(Output)»¹ÊÇ·µ»ØÖµ(ReturnValue)
        Userid.Direction = Param


Ïà¹ØÎĵµ£º

ASP.NETÒ³ÃæÖ´ÐÐ˳Ðò

1.¶ÔÏó³õʼ»¯£¨OnInit·½·¨£©
    Ò³ÃæÖеĿؼþ(°üÀ¨Ò³Ãæ±¾Éí)¶¼ÊÇÔÚËüÃÇ×î³õµÄFORMÖб»Ê״γõʼ»¯µÄ¡£Í¨¹ýÔÚASPXÒ³ÃæµÄºǫ́´úÂëÎļþµÄ¹¹ÔìÆ÷ÖÐÉùÃ÷ÄãµÄ¶ÔÏó£¬Ò³Ã潫֪µÀ¶ÔÏóµÄÀàÐÍ£¬²¢ÖªµÀÐèÒª´´½¨¶àÉÙ¸öÕâÑùµÄ¶ÔÏó¡£Ò»µ©ÄãÔÚ¹¹ÔìÆ÷ÖÐÉùÃ÷ÁËÄãµÄ¿Ø¼þ£¬Äã¾Í¿ÉÒÔÔÚËüµÄÈκÎ×ÓÀ࣬·½·¨£¬Ê¼þ»òÕßÊôÐÔÖзÃÎʵ½Ë ......

Asp.Net ÉÏ´«´óÎļþרÌâ(1) ¸ÅÊö£ºÉÏ´«´óÎļþµÄÄѵã

ÕýÎIJ¿·Ö£º
        ×¢Ò⣺ÒÔϺìÉ«²¿·Ö×ÖÌå˵Ã÷¸ÃÄÚÈÝÒýÓÃÓÚ΢ÈíµÄÏà¹ØÍøÕ¾
        ÒòΪҪ×öÒ»¸öÊÓÆµÍøÕ¾£¬ËùÒÔÐèÒªÌṩÓû§ÉÏ´«ÊÓÆµµÄ¹¦ÄÜ¡£¿ÉÊÇASP.Net×Ô´øµÄÉÏ´«¿Ø¼þÖ»ÄÜÓÃÓÚÉÏ´«Ð¡Îļþ,ÕâÏÔÈ»ÎÞ·¨Âú×ãÐèÒª¡£ÓÐЩÅóÓÑ¿ÉÄÜÒªÎÊÁË"ΪʲôÐèÒªÓ ......

ASP.NET¿çÒ³Ãæ´«Öµ¼¼ÇÉ×ܽá

1.ʹÓÃQueryString±äÁ¿
QueryStringÊÇÒ»Öַdz£¼òµ¥µÄ´«Öµ·½Ê½£¬Ëû¿ÉÒÔ½«´«Ë͵ÄÖµÏÔʾÔÚä¯ÀÀÆ÷µÄµØÖ·À¸ÖС£Èç¹ûÊÇ´«µÝÒ»¸ö»ò¶à¸ö°²È«ÐÔÒªÇ󲻸߻òÊǽṹ¼òµ¥µÄÊýֵʱ£¬¿ÉÒÔʹÓÃÕâ¸ö·½·¨¡£µ«ÊǶÔÓÚ´«µÝÊý×é»ò¶ÔÏóµÄ»°£¬¾Í²»ÄÜÓÃÕâ¸ö·½·¨ÁË¡£ÏÂÃæÊÇÒ»¸öÀý×Ó£º
a.aspxµÄC#´úÂë
private void Button1_Click(object sender, Sy ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ