Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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С¼¼ÇÉ

×î½ü·ÃÎÊÁ˽¨ÐÐÍøÕ¾Ê± https://ibsbjstar.ccb.com.cn/V5/index.html#£¬£¨ÆäʵÔÚoblog,http://www.oblog.cnÒ²²ÉÓÃÁËÀàËÆµÄ¼¼ÇÉ£¬²»¹ý·½·¨²»Í¬°ÕÁË£©
¡¡¡¡¿ÉÒÔ·¢ÏÖ£¬µ±Ñ¡Ôñ²»Í¬µÄÎı¾¿ò£¬¿ÉÒÔ³öÏÖ²»Í¬µÄÑÕÉ«£¬ÒªÍê³ÉÕâ¸ö¹¦Äܼܺòµ¥£¬µ«ÊÇÈç¹ûÓкܶàÀàËÆµÄ¹¦ÄÜ£¬Èç¹ûÒ»¸ö¸öÉèÖÿؼþÑùʽÏÔÈ»ºÜÀÛ£¬Ò»¸ö¼òµ¥µÄ´¦Àí·½·¨Ð´Ò»¸ö·½· ......

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 ......

ÈçºÎÔÚASP.NETÒ³ÃæÖÐǶÈëWINFORM¿Ø¼þ¶þ

Ô­ÎÄ£ºÁõÎä|ÈçºÎÔÚASP.NETÒ³ÃæÖÐǶÈëWINFORM¿Ø¼þ¶þ
ÉÏһƪ½éÉÜÁËÔÚASP.NETÒ³ÃæÖÐǶÈëWINFORM¿Ø¼þµÄ»ù±¾·½·¨£¬±¾Æª»á¾Ù¸öÉÔ΢¸´ÔÓµÄÀý×ÓÀ´ËµÃ÷ÈçºÎÔÚÒ³ÃæÖе÷ÓÃWINFORM¿Ø¼þµÄÊôÐԺͷ½·¨¡£
Ò» н¨ÏîÄ¿ Liuw.Net.WindowsControlLibrary£¬²¢Ìí¼ÓWINDOWSÓû§¿Ø¼þ MyControl1
¶þ ¸ø¿Ø¼þ MyControl1 Ìí¼ÓÊôÐԺͷ½·¨£º
C#-Co ......

¿ª·¢ÊÓÆµÍøÕ¾£¬asp.netÊÓÆµÎļþת»».flv¸ñʽ

×î½ü¹«Ë¾ÓÐÒ»¸öСÏîÄ¿ÐèÒª°ÑÊÓÆµ×ª»»³ÉFLASHÎļþ£¬Ð§¹û¾ÍÊÇÏñÓû§×¢²áyoukuÍøÒ»Ñù£¬×Ô¼º¿ÉÒÔÊÓÆµÉÏ´«£¬×ª»»³Éflash¸ñʽ²¥·Å¡£
¿àÓÚÒÔǰûÓÐ×ö¹ý£¬ÓÚÊÇÂíÉÏËÑË÷ÁËÏà¹ØµÄÎÄÕ£¬¿´ÁËhttp://www.cnblogs.com/xiucai/ ºÍ http://www.cnblogs.com/seebook/¹ØÓÚÕâ·½ÃæµÄÎÄÕ£¬¶ÔÎÒ°ïÖúºÜ´ó¡£½ñÌìµÚÒ»Ì쿪²©£¬ÎҾͼǼÏÂËüÃÇ¡£
ÏÖ ......

asp.netʱ¼ä¸ñʽ

DateTime dt = DateTime.Now;
//    Label1.Text = dt.ToString();//2005-11-5 13:21:25
//    Label2.Text = dt.ToFileTime().ToString();//127756416859912816
//    Label3.Text = dt.ToFileTimeUtc().ToString();//127756704859912816
//    Labe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ