ÔÚ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();
×¢ÒâºìÉ«±ê×¢µÄµØ·½£¬ÕâÔÚÉèÖòÎÊýʱºÜÖØÒª¡£
Ïà¹ØÎĵµ£º
Ö§¸¶±¦µÄ½Ó¿Úµ÷Óúܲ»·½±ã£¬¸Õ×öºÃÒ»¸ö·â×°£¬ÊµÏÖÁËÐéÄâ½»Ò׺ÍʵÎï½»Òס£
½â¾ö·½°¸ÖÐÓÐÈý¸öÏîÄ¿ÒÔ¼°NDocÉú³ÉµÄÎĵµ£¬¼òµ¥µÄÐòÁÐͼ£ºCommonAliPay£¬·â×°µÄÖ§¸¶±¦½Ó¿Ú¡£
TestAli,asp.netµÄ²âÊÔÏîÄ¿
TestCommonAliPay£¬NunitµÄ²âÊÔÏîÄ¿¡£
µ÷Ó÷½·¨£º
1¡¢ÒýÈëCommonAliPay.dll
2¡¢ÊµÏÖÖ§¸¶±¦·þÎñ½Ó¿ÚµÄ·½·¨µ÷Ó÷½Ê½£º
......
ÔÎÄ£ºÁõÎä|ÈçºÎÔÚASP.NETÒ³ÃæÖÐǶÈëWINFORM¿Ø¼þ¶þ
ÉÏһƪ½éÉÜÁËÔÚASP.NETÒ³ÃæÖÐǶÈëWINFORM¿Ø¼þµÄ»ù±¾·½·¨£¬±¾Æª»á¾Ù¸öÉÔ΢¸´ÔÓµÄÀý×ÓÀ´ËµÃ÷ÈçºÎÔÚÒ³ÃæÖе÷ÓÃWINFORM¿Ø¼þµÄÊôÐԺͷ½·¨¡£
Ò» н¨ÏîÄ¿ Liuw.Net.WindowsControlLibrary£¬²¢Ìí¼ÓWINDOWSÓû§¿Ø¼þ MyControl1
¶þ ¸ø¿Ø¼þ MyControl1 Ìí¼ÓÊôÐԺͷ½·¨£º
C#-Co ......
http://www.cnblogs.com/TerryFeng/archive/2009/02/01/1382123.html
ÕâºÜ³£Óã¬ËÑË÷ÁËһϲ©¿ÍÔ°µÄ“ÕÒÕÒ¿´”ºÍ¹È¸è£¬¿´µ½´ó²¿·Ö¶¼ÊÇ×ªÔØÓÚÒ»Á½ÆªÎÄÕ£¨¶øÇÒÀ´Ô´»¹²»ÊDz©¿ÍÔ°£©£¬ÓеÄÊǼòµ¥µÄ˵һµãÎÞ·¨ÔËÐУ¬¸ø³õѧÕߵĵ÷ÊÔºÍѧϰ´øÀ´²»·½±ã£¬ÎÒÔÚÕâÀォjQuery Ajax µ÷ÓÃAspx.Net WebService µÄ¼¸¸ö³£Óõķ½·¨ ......
ÔÎÄ http://www.886s.com/blog/?p=96
Ëæ×ÅAjaxµÄÊ¢ÐУ¬´ó¼Ò¶¼È¥´ÕÈÈÄÖ£¬ÎÒÃǵÄÏîĿҲ²»ÀýÍâ¡£
¿´ÁËÒ»ÏÂÏÖÓеĴúÂ룬¶ÔÓÚÒ»¸ö²Ù×÷³éȡһ¸öµÄÒ³Ãæ£¬°Ñ²ÎÊý½ÓÊÕ£¬µ÷ÓÃÂß¼²ãµÄÏà¹Øº¯Êý²¢·µ»ØÏàÓ¦µÄJson»òÕßXml£¬ËÑË÷ÁËһϣ¬¹¤³ÌÖо¹È»ÓÐÁË360+¸öÕâÖÖÒ³Ãæ£¬ÕâÕæÊÇÒ»ÖÖÀË·Ñ£¡Èç¹ûÓ÷´É䣬һ¸öÒ³Ãæ¾Í¿ÉÒԸ㶨£¡½ÚÊ¡Á˶àÉ ......
µÚÒ»:
Response.Write(<script></script>);
µÚ¶þ:
ÍÐÒ»¸öLiteral¿Ø¼þ
Literal(¿Ø¼þÃû).Text="<script></script>";
......