ÔÚ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();
×¢ÒâºìÉ«±ê×¢µÄµØ·½£¬ÕâÔÚÉèÖòÎÊýʱºÜÖØÒª¡£
Ïà¹ØÎĵµ£º
¹Ø¼üÔÚÉÏ´«µÄʹÓÃÓõ½ÁËupload.aspx,¶øÕâ¸öÒ³ÃæÄ¬ÈϵıàÂëͳһΪutf-8,ËùÒÔÎÒÃÇÒª¸øËü¸Ä±äһϡ£ÔÚÄãµÄweb.configÖÐÔö¼Ó´Ë×Ö¶Î
<location path="fckeditor/editor/filemanager/connectors/aspx/upload.aspx">
<system.web>
<globalization req ......
http://www.cnblogs.com/TerryFeng/archive/2009/02/01/1382123.html
ÕâºÜ³£Óã¬ËÑË÷ÁËһϲ©¿ÍÔ°µÄ“ÕÒÕÒ¿´”ºÍ¹È¸è£¬¿´µ½´ó²¿·Ö¶¼ÊÇ×ªÔØÓÚÒ»Á½ÆªÎÄÕ£¨¶øÇÒÀ´Ô´»¹²»ÊDz©¿ÍÔ°£©£¬ÓеÄÊǼòµ¥µÄ˵һµãÎÞ·¨ÔËÐУ¬¸ø³õѧÕߵĵ÷ÊÔºÍѧϰ´øÀ´²»·½±ã£¬ÎÒÔÚÕâÀォjQuery Ajax µ÷ÓÃAspx.Net WebService µÄ¼¸¸ö³£Óõķ½·¨ ......
ÓÉÓÚÏîÄ¿ÖжദÐèÒª¶ÔÅäÖÃÎļþ½øÐвÙ×÷£¬ÈçÅäÖÃÐÅÏ¢µÄ¶ÁÈ¡¡¢¸ü¸ÄºÍдÈ룬ÐèÒªÒ»¸öͨÓõÄÀàÀ´¶ÔÆä½øÐвÙ×÷ºÍ´¦Àí¡£Õâ´ÎµÄÈÎÎñ¾ÍÊÇÅäÖýڵÄһЩÓ÷¨¡£
Õâ´ÎÉý¼¶ºóµÄ¿ª·¢¹¤¾ßÊÇ»ùÓÚVS2005µÄ£¬·ÖÎöÁËVS2005 ÐÂÔöµÄһЩ¹¦ÄÜ£¬Ëü×Ô´øÁËÒ»Ì×ÅäÖÃÎļþÖнáµãµÈµÄÅäÖá£Ä¿Ç°µÄÏîÄ¿ÓõÄÅä ......
ASP.NETÉú³É¾²Ì¬Ò³ÃæµÄ·½·¨
ʹ
ÓÃASP.NETÉú³É¾²Ì¬Ò³ÃæµÄ·½·¨ÓÐÁ½ÖÖ£¬µÚÒ»ÖÖÊÇʹÓÃC#ÔÚºǫ́Ӳ±àÂ룬µÚ¶þÖÖÊǶÁȡģ°åÎļþ£¬Ê¹ÓÃ×Ö·û´®Ìæ»»µÄ·½·¨¡£µÚÒ»ÖÖ·½·¨±àÂëÁ¿´ó£¬¶øÇÒά»¤
±È½ÏÀ§ÄÑ¡£ÎÒÖØµã½²½âµÚ¶þÖÖ·½·¨¡£µÚ¶þÖÖ·½·¨µÄ»ù±¾Ë¼Â·ÊÇ£ºÊ¹ÓÃDWÖ®ÀàµÄ¹¤¾ßÉú³ÉÒ»¸ö¾²Ì¬Ò³ÃæÄ£°å¡£¶ÁÈ¡¸ÃÄ£°åÎļþ£¬È»ºó¶ÔÀïÃæµÄÌØÊ ......
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 ......