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
Ïà¹ØÎĵµ£º
vs2008½¨ÍøÕ¾ÊÇǧÍò±ðÔÚ±£´æÂ·¾¶Öк¬ÓБ#’£¬±ÈÈçÔÚ‘C#’µÄÎļþ¼ÐÀïÃæÔÙ½¨ÍøÕ¾£¬Èç¹û·¾¶Öк¬ÓБ#’£¬½«Ê¹Ä¸°æ½¨Á¢ÊÇÓдíÎ󣬶øÇÒ×ÓÒ³½¨Á¢ºóÒ²ÎÞ·¨Ê¹ÓÃÉè¼ÆÒ³Ãæ£¬»¹»áÓÐÆäËû·¾¶ÎÊÌ⣨±ÈÈçCSSÎļþÎÞ·¨¼ÓÔØ£©¡£Õâ¸öÎÒ½ñÍí¸Õ¸Õ½â¾ö£¬À§ÈÅÎÒÁËÒ»ÏÂÎ磬¶àÐ»ÍøÉÏÖÚÈ˵ÄÖ¸µã£¬ÌØ´Ëд³ö£¬ÌáÐÑ×Ô¼ ......
1.¶ÔÏó³õʼ»¯£¨OnInit·½·¨£©
Ò³ÃæÖеĿؼþ(°üÀ¨Ò³Ãæ±¾Éí)¶¼ÊÇÔÚËüÃÇ×î³õµÄFORMÖб»Ê״γõʼ»¯µÄ¡£Í¨¹ýÔÚASPXÒ³ÃæµÄºǫ́´úÂëÎļþµÄ¹¹ÔìÆ÷ÖÐÉùÃ÷ÄãµÄ¶ÔÏó£¬Ò³Ã潫֪µÀ¶ÔÏóµÄÀàÐÍ£¬²¢ÖªµÀÐèÒª´´½¨¶àÉÙ¸öÕâÑùµÄ¶ÔÏó¡£Ò»µ©ÄãÔÚ¹¹ÔìÆ÷ÖÐÉùÃ÷ÁËÄãµÄ¿Ø¼þ£¬Äã¾Í¿ÉÒÔÔÚËüµÄÈκÎ×ÓÀ࣬·½·¨£¬Ê¼þ»òÕßÊôÐÔÖзÃÎʵ½Ë ......
ÕýÎIJ¿·Ö£º
×¢Ò⣺ÒÔϺìÉ«²¿·Ö×ÖÌå˵Ã÷¸ÃÄÚÈÝÒýÓÃÓÚ΢ÈíµÄÏà¹ØÍøÕ¾
ÒòΪҪ×öÒ»¸öÊÓÆµÍøÕ¾£¬ËùÒÔÐèÒªÌṩÓû§ÉÏ´«ÊÓÆµµÄ¹¦ÄÜ¡£¿ÉÊÇASP.Net×Ô´øµÄÉÏ´«¿Ø¼þÖ»ÄÜÓÃÓÚÉÏ´«Ð¡Îļþ,ÕâÏÔÈ»ÎÞ·¨Âú×ãÐèÒª¡£ÓÐЩÅóÓÑ¿ÉÄÜÒªÎÊÁË"ΪʲôÐèÒªÓ ......
ASP.NET µÄ»º´æ»úÖÆÏà±ÈASPÓкܴóµÄ¸Ä½ø£¬±¾Îĵµ³ý¶Ô³£ÓÃÓÅ»¯·½·¨½øÐÐ×ܽá½éÉÜÍ⣬ǿµ÷ÁËÈçºÎʹÓÃASP.NETµÄ»º´æÀ´»ñµÃ×î¼ÑÐÔÄÜ¡£
1£º²»ÒªÊ¹Óò»±ØÒªµÄsession
ºÍASPÖÐÒ»Ñù£¬ÔÚ²»±ØÒªµÄʱºò²»ÒªÊ¹ÓÃSession¡£
¿ÉÒÔÕë¶ÔÕû¸öÓ¦ÓóÌÐò»òÕßÒ³Ãæ½ûÓûỰ״̬£º
l ½ûÓÃÒ³ÃæµÄ ......
///·½·¨
public static List<FeesItemInfo> selectAll()
{
List<FeesItemInfo> list = new List<FeesItemInfo>();
& ......