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
Ïà¹ØÎĵµ£º
Cookie ÌṩÁËÒ»ÖÖÔÚ Web Ó¦ÓóÌÐòÖд洢Óû§Ìض¨ÐÅÏ¢µÄ·½·¨¡£ÀýÈ磬µ±Óû§·ÃÎÊÄúµÄÕ¾µãʱ£¬Äú¿ÉÒÔʹÓà Cookie ´æ´¢Óû§Ê×Ñ¡Ïî»òÆäËûÐÅÏ¢¡£µ±¸ÃÓû§ÔٴηÃÎÊÄúµÄÍøÕ¾Ê±£¬Ó¦ÓóÌÐò±ã¿ÉÒÔ¼ìË÷ÒÔǰ´æ´¢µÄÐÅÏ¢¡£
ʲôÊÇ Cookie£¿
Cookie ÊÇһС¶ÎÎı¾ÐÅÏ¢£¬°éËæ×ÅÓû§ÇëÇóºÍÒ³ÃæÔÚ Web ·þÎñÆ÷ºÍä¯ÀÀÆ÷Ö®¼ä´«µÝ¡£Cookie °üº¬Ã¿ ......
ÉùÃ÷£º
Ö»Ìṩºǫ́.csÎļþ´úÂë
Ïêϸ½Ì³ÌµØÖ·£ºhttp://download.csdn.net/source/2289546
1.ÐèÒª ±àд¾²Ì¬Ä£°åÒ³ ÎÒʹÓõÄÊÇ template.htm
2.ÔÚÄ£°åÒ³Öж¨Òåhtmlyem±ê¼Ç£¬±ê¼Ç·Ç¹Ì¶¨ÄÚÈÝ£¬ÔÚºǫ́´úÂëÖÐΪ±ê¼Ç¸³Öµ
3.ºǫ́´úÂëÈçÏ£º
using System;
using System.Data;
using System.Configuration;
using Syst ......
ÎÒÕâÊÇÄÃÀ´±ðÈËÓõģ¬ÎªÁË·½±ãÒÔºó×Ô¼º¿´°É£¬¿´¶Ô´ó¼ÒÓаïæÂð
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.InteropServices;
namespace AppBLL
{
public class ShutDown
{
[StructLayout(LayoutKind.Sequential, Pack = 1)]
......
Web ÏîÄ¿Öо³£Óöµ½µÄÎÊÌâ¾ÍÊÇͬһÓû§Ãû¶à´ÎµÇ½µÄÎÊÌ⣬ÏàÓ¦µÄ½â¾ö°ì·¨Ò²ºÜ¶à£¬×ܽáÆðÀ´²»ÍâºõÕ⼸ÖÖ½â¾ö°ì·¨£º½«µÇ½ºóµÄÓû§Ãû·Åµ½Êý¾Ý¿â±íÖУ»µÇ½ºóµÄÓû§Ãû·Åµ½SessionÖУ»µÇ½ºóµÄÓû§Ãû·Åµ½ApplicationÖУ»µÇ½ºóµÄÓû§Ãû·Åµ½CacheÖС£Ò»°ãµÄÕ⼸ÖÖ·½·¨¶¼ÊǵǽÁËÖ®ºó£¬Èç¹ûûÓÐÕý³£Í˳ö£¬µÚ¶þ´ÎµÇ½½«²»±»ÔÊÐí¡£Õ ......
ASP.NET µÄ»º´æ»úÖÆÏà±ÈASPÓкܴóµÄ¸Ä½ø£¬±¾Îĵµ³ý¶Ô³£ÓÃÓÅ»¯·½·¨½øÐÐ×ܽá½éÉÜÍ⣬ǿµ÷ÁËÈçºÎʹÓÃASP.NETµÄ»º´æÀ´»ñµÃ×î¼ÑÐÔÄÜ¡£
1£º²»ÒªÊ¹Óò»±ØÒªµÄsession
ºÍASPÖÐÒ»Ñù£¬ÔÚ²»±ØÒªµÄʱºò²»ÒªÊ¹ÓÃSession¡£
¿ÉÒÔÕë¶ÔÕû¸öÓ¦ÓóÌÐò»òÕßÒ³Ãæ½ûÓûỰ״̬£º
l ½ûÓÃÒ³ÃæµÄ ......