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

ÔÚasp.netÖнÓÊÕsql serverÖд洢¹ý³ÌµÄ·µ»ØÖµ

´æ´¢¹ý³Ì´úÂ룺
create procedure proc_name
   @para1 nchar(20),    --ÊäÈë²ÎÊý
   @para2 int = null output¡¡--Êä³ö²ÎÊý£¬¹©³ÌÐòʹÓÃ
as
begin
   if (@para1='a')
   begin
       insert into employee(name) values(@para1)  
       select @para2=@@identity      --·µ»ØÌí¼Ó¼Ç¼µÄID
       return 1                                --·µ»ØÊÇ·ñ³É¹¦Ìí¼ÓÊý¾Ý
   end
   else
      return 0                               --·µ»ØÊ§°Ü
end
go
ÔÚ²éѯ·ÖÎöÆ÷ÖеIJâÊÔ£º
declare @id nchar(10)
exec dbo.proc_name 'a',@id output
print @id
ÔÚasp.netÖе÷Óãº
sqlcommand command;
command = new sqlcommand(proc_name,new sqlconnection(connectionstr));
command.paraments.add("@para1"),"name1");  //ÊäÈë²ÎÊý£¬Ö°Ô±ÐÕÃû
command.paraments.add(new sqlparament("@para2",   //Éú³ÉÒ»Êä³ö²ÎÊý
SqlDbType.Int;¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//²ÎÊýÊý¾ÝÀàÐÍ
ParamenterDirection.OutPut,¡¡¡¡¡¡¡¡¡¡¡¡//ÊäÈëÊä³öÀàÐÍ
0,
0,
string.Emplty,
DataRowVerstion.Default,
null)¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//²ÎÊýÖµ£¬ÊäÈë²ÎÊýʱÐèÌṩ
);
command.commandtype=commandtype.StoredProcedure;
command.connection.open();
command.executenonQuery();
int pkid=(int)command.Parameters["@para2"].value;  //µÃµ½Êä³ö²ÎÊýµÄÖµ
command.connection.close();
×¢ÒâºìÉ«±ê×¢µÄµØ·½£¬ÕâÔÚÉèÖòÎÊýʱºÜÖØÒª¡£


Ïà¹ØÎĵµ£º

ASP.net:Ö§¸¶±¦½Ó¿Ú


Ö§¸¶±¦µÄ½Ó¿Úµ÷Óúܲ»·½±ã£¬¸Õ×öºÃÒ»¸ö·â×°£¬ÊµÏÖÁËÐéÄâ½»Ò׺ÍʵÎï½»Òס£
½â¾ö·½°¸ÖÐÓÐÈý¸öÏîÄ¿ÒÔ¼°NDocÉú³ÉµÄÎĵµ£¬¼òµ¥µÄÐòÁÐͼ£ºCommonAliPay£¬·â×°µÄÖ§¸¶±¦½Ó¿Ú¡£
TestAli,asp.netµÄ²âÊÔÏîÄ¿
TestCommonAliPay£¬NunitµÄ²âÊÔÏîÄ¿¡£
µ÷Ó÷½·¨£º
1¡¢ÒýÈëCommonAliPay.dll
2¡¢ÊµÏÖÖ§¸¶±¦·þÎñ½Ó¿ÚµÄ·½·¨µ÷Ó÷½Ê½£º
......

asp.netÖÐcookieµÄ´¦Àí

Ô­ÎÄ£ºÁõÎä|asp.netÖÐcookieµÄ´¦Àí  
ʹÓÃÖз¢ÏÖÓÃRequest.Cookies.Remove()ÎÞ·¨É¾³ýcookie,googleÁËһϷ¢ÏÖÒ»°ãÊÇͨ¹ý½«¹ýÆÚʱ¼äÉèÖóɹýÈ¥µÄʱ¼äÀ´Íê³Éɾ³ýµÄ¡£Ë³±ãÕûÀíÏÂcookieµÄ²Ù×÷£º
Ò» ´´½¨
1 µ¥ÖµµÄ´´½¨
C#-Code:
HttpCookie hc = new HttpCookie("Value");
hc.Value = "value";
Response.Appe ......

jQuery Ajax ·½·¨µ÷Óà Asp.Net WebService µÄÏêϸÀý×Ó

http://www.cnblogs.com/TerryFeng/archive/2009/02/01/1382123.html
ÕâºÜ³£Óã¬ËÑË÷ÁËһϲ©¿ÍÔ°µÄ“ÕÒÕÒ¿´”ºÍ¹È¸è£¬¿´µ½´ó²¿·Ö¶¼ÊÇ×ªÔØÓÚÒ»Á½ÆªÎÄÕ£¨¶øÇÒÀ´Ô´»¹²»ÊDz©¿ÍÔ°£©£¬ÓеÄÊǼòµ¥µÄ˵һµãÎÞ·¨ÔËÐУ¬¸ø³õѧÕߵĵ÷ÊÔºÍѧϰ´øÀ´²»·½±ã£¬ÎÒÔÚÕâÀォjQuery Ajax µ÷ÓÃAspx.Net WebService µÄ¼¸¸ö³£Óõķ½·¨ ......

ASP.NET ³ÌÐòÔ±µÄÐÞÁ¶Ö®Â·

³õ¼¶µÄ³ÌÐòÔ±»ò¾­Ñé²»×ãµÄ³ÌÐòÔ±ÍùÍùÖ»Òâʶµ½×Ô¼ºµÄ³ÌÐòÊÇд¸ø¼ÆËã»úµÄ£¬¶ø²»»áÔÚÒâ³ÌÐòÆäʵҲÊÇд¸øÈ˵쬻òÔÚÒâµÃ²»¹»¡¢²»È«Ãæ¡£
д¸ø»úÆ÷µÄ³ÌÐò£¬ÍùÍù×·ÇóµÄÊÇÔËÐÐÕýÈ·¡¢Ö´ÐÐЧÂÊÄÜÂú×ãÒªÇó¡£µ«³ÌÐòÔ±µÄÈÎÎñ½ö½ö¾ÍÊǰÑÒµÎñÂß¼­×ª³É»úÆ÷ÄܱàÒëµÄ¼ÆËã»úÓïÑÔÂð?
Æäʵ£¬³ÌÐòÊ×ÏÈ(×¢Ò⣬ÊÇÊ×ÏÈ)ÊÇд¸øÈ˵ġ£µÚÒ»£¬³ÌÐòÊÇд¸ ......

ASP.net µ¯³ö´°Ìå

Respose.Write("<script     language='javascript'>window.open('"+     url     +"');</script>"); 
£¨´ò¿ª¼ò½à´°¿Ú£©£º
Respose.Write("<script     language='javascript'>window.open('"  &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ