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
Ïà¹ØÎĵµ£º
ÎÒÕâÊÇÄÃÀ´±ðÈËÓõģ¬ÎªÁË·½±ãÒÔºó×Ô¼º¿´°É£¬¿´¶Ô´ó¼ÒÓаïæÂð
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)]
......
ÕýÎIJ¿·Ö£º
×¢Ò⣺ÒÔϺìÉ«²¿·Ö×ÖÌå˵Ã÷¸ÃÄÚÈÝÒýÓÃÓÚ΢ÈíµÄÏà¹ØÍøÕ¾
ÒòΪҪ×öÒ»¸öÊÓÆµÍøÕ¾£¬ËùÒÔÐèÒªÌṩÓû§ÉÏ´«ÊÓÆµµÄ¹¦ÄÜ¡£¿ÉÊÇASP.Net×Ô´øµÄÉÏ´«¿Ø¼þÖ»ÄÜÓÃÓÚÉÏ´«Ð¡Îļþ,ÕâÏÔÈ»ÎÞ·¨Âú×ãÐèÒª¡£ÓÐЩÅóÓÑ¿ÉÄÜÒªÎÊÁË"ΪʲôÐèÒªÓ ......
ASP.NETÖнøÐÐÏûÏ¢´¦Àí(MSMQ) Ò»
MSMQÊÇ΢ÈíÏûÏ¢¶ÓÁеÄÓ¢ÎÄËõд¡£ÄÇôʲôÊÇÏûÏ¢¶ÓÁУ¿ÕâЩ½éÉÜÍøÉÏÒ»´óƬÕâÀï¾Í²»¶à˵ÁË¡£±¾ÎĶÔÓÚ´óϺ¼¶µÄÈËÎïÀ´ËµÕâÖ»ÊÇÐ¡ÍæÒâ¶øÒÑ£¬¶ÔÓÚ³õѧÕßÀ´ËµÕâÎÄÕ»¹ÊÇÓÐÒ»¶¨µÄ°ïÖú£¬Ï£Íû·¹ýµÄ´óϺÃDZðЦ»°ÎÒ°àÃÅŪ¸«¡£
Ò»¡¢MSMQ½éÉܺͰ²×°ÏûÏ¢¶ÓÁÐ
&nb ......
http://www.cnblogs.com/wyforumid/archive/2008/05/14/1196155.html
Ê×ÏȶÔÒÔÉϵÄÔ´´Õß˵¶Ô²»ÆðÏ£¬Î´¾Í¬Òâ¾Í¸ÄÁËËûµÄÔ´Â룬»¹°Ñ¸ÄºóµÄÔ´Âë·¢³öÀ´¡£
Ö÷Òª¸ÄµÄµØ·½¾ÍÊǵØÖ·À¸ÀïµÄ¶«¶«ÁË£¬ÔÎÄ¿ÉÒÔ¿´ÒÔÉϵģ¬ÎÒÌùÉÏ×Ô¼º¸ÄºóµÄÔ´Âë°É
Default.aspxÎļþ
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="D ......