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

ASP.NET Öе÷Óô洢¹ý³Ì

ÓÃASP.NETÓëSQL SERVER¿ÉÊÇÔµ·Ý×îºÃÁË£¬ÉÔ´óµÄ³ÌÐòÒ»°ãµÚÒ»ÏÈ¿¼ÂǵÄÊÇSQL SERVER£¬Ö»ÊÇһЩºÜ¿¼ÂǾ­¼ÃµÄ²ÅʹÓÃACCESSµÈÁË¡£ÓÃSQL SERVER£¬ÎªÁËʹÊý¾Ý¿âµÄЧÂʸüºÃ£¬Ò»°ã¶¼»á²ÅÈ¡´æ´¢¹ý³Ì£¬Òò´æ´¢¹ý³ÌÖ´ÐÐËٶȿ죬²¢ÇÒ¿ÉÒÔʵÏÖһЩ¸ß¼¶µÄ²éѯµÈ¹¦ÄÜ¡£±ÈÈç´«ÈëһЩÊý¾Ý²ÎÊý£¬µ«Ö´ÐеÄSQL¹ý³Ì¿ÉÄܲ»Í¬µÈ¡£
¡¡¡¡ÏÂÃæ¾ÍÀ´¸öÀý×Ó£¬½¨Á¢Ò»ÐµĽÇÉ«£¬ÒªÇó½ÇÉ«µÄÃû×Ö²»ÄÜÖظ´£¬ÒÔÏÂÊÇÒ»´æ´¢¹ý³Ì¡£
¡¡¡¡
CREATE PROCEDURE sp_AccountRole_Create@CategoryID int,
@RoleName nvarchar(10),
@Description nvarchar(50),
@RoleID int output
AS
DECLARE @Count int -- ²éÕÒÊÇ·ñÓÐÏàͬÃû³ÆµÄ¼Ç¼
SELECT @Count = Count(RoleID) from Account_Role WHERE
RoleName = @RoleName IF @Count = 0 INSERT INTO Account_Role
(CategoryID, RoleName, Description) valueS
(@CategoryID, @RoleName, @Description) SET @RoleID = @@IDENTITY RETURN 1
GO
¡¡¡¡
¡¡¡¡Ö´Ðд洢¹ý³ÌµÄC#¹ý³Ì£º
¡¡¡¡
SqlConnection DbConnection = new SqlConnection(mConnectionString);
SqlCommand command = new SqlCommand( "sp_AccountRole_Create", DbConnection );
DbConnection.Open(connectString);
// ·ÏÖÃSqlCommandµÄÊôÐÔΪ´æ´¢¹ý³Ì
command.CommandType = CommandType.StoredProcedure;command.Parameters.Add("@CategoryID", SqlDbType.Int, 4);
command.Parameters.Add("@RoleName", SqlDbType.NVarChar, 10);
command.Parameters.Add("@Description", SqlDbType.NVarChar, 50);
command.Parameters.Add("@RoleID", SqlDbType.Int, 4);
// ·µ»ØÖµ
command.Parameters.Add("Returnvalue",
SqlDbType.Int,
4, // Size
ParameterDirection.Returnvalue,
false, // is nullable
0, // byte precision
0, // byte scale
string.Empty,
DataRowVersion.Default,
null );command.parameters["@CategoryID"].value = permission.CategoryID;
command.parameters["@RoleName"].value = permission.PermissionName;
command.parameters["@Description"].value = permission.Description;
// ¿ÉÒÔ·µ»ØеÄIDÖµ
command.parameters["@Ro


Ïà¹ØÎĵµ£º

˼·ÇåÎúµØ¿ª·¢Ð¡µÄasp.net webÓ¦ÓóÌÐò

   ×÷Ϊ¸öÈËÍøÕ¾»òСÐÍÍøÕ¾µÄ±àдÕߣ¬Ê®°Ë°ãÎäÒÕ¶¼µÃͨÏþÒ»µã£¬±ÈÈç˵ javascript¡¢CSS/DIV¡¢HTML¡¢±à³ÌÓïÑÔ¡¢Êý¾Ý¿â֪ʶµÈ¡£µ±ÎÒÃDZàдһ¸öСÐÍÓ¦ÓóÌÐòʱ£¬ÈçºÎ×öµ½¸ßЧ¡¢Ë¼Â·ÇåÎúÄØ£¿ÒÔÏÂÊÇÎÒµÄÒ»µã¾­Ñé×ܽᡣÓ×ÖÉÓë²»×ãÖ®´¦»¹ÍûµÃµ½Í¬ÐеÄÖ¸µã¡£
Ò»Ìõ×ܵÄ˼Ï룺ÔÚÓ¦ÓóÌÐò±àÒë·¢²¼ºó£¬aspxÎļþ¡¢dllÎļ ......

ASP.NET Mischellous II

@import url(¡°layout.css¡±)
CSS Selectors: *, p, div span, div > span, *[href], li+li, .title, #container, #title p:first-child, a:link, a:hover, a:visited, p:before, p:after
p:after{content:¡¯url(images/quote.gif)¡¯}
!important State Mode: Off, InProc, StateServer, SQLServer, C ......

Asp.NetÖÐWord,ExcelµÈoffice com×é¼þ²Ù×÷ȨÏÞµÄÎÊÌâ

½üÈÕÔÚ´ò¿ªÔ­À´Ð´µÄÒ»¸öÍøÒ³³ÌÐòÔËÐÐʱ£¬³öÏÖÁËExcel²Ù×÷ȨÏÞµÄÎÊÌ⣬¾ßÌåµÄ˵¾ÍÊÇÔÚ´úÂëÖе÷ÓÃÏÂÃæÕâ¶ÎÓëExcel²Ù×÷ÓйصÄÓï¾äʱ£¬
¡¡¡¡Application curExcelApp = new ApplicationClass();
¡¡¡¡ÌáʾȨÏÞ²»×㣬¾ßÌåµÄÌáʾÄÚÈÝÈçÏ£º
¡¡¡¡¼ìË÷ COM À๤³§ÖÐ CLSID Ϊ {00024500-0000-0000-C000-000000000046} µÄ×é¼þʱ ......

Asp.netÒ¹»°Ö®Ò»£ºasp.net½éÉÜ


ÌâÍâ»°£ºÈ¥ÄêÖÁ½ñÄêÒÔÀ´£¬Â½Ðøд¹ýһЩԭ´´µÄÎÄÕÂÁË£¬ºÜ¶àÊǶÔÔ­À´Ëù×öÏîÄ¿µÄ×ܽᡣËùÒÔ²¢²»ÊǺÜϵͳºÜÈ«Ã棬¶¼ÊÇÕë¶Ôij¸ö֪ʶµã»òÕßij¸ö¾ßÌåÓ¦ÓÃдµÄ£¬ÓÐЩÅóÓѽ¨ÒéÎÒ°Ñ×Ô¼ºµÄÌå»áд³ÉÒ»¸öϵͳµÄ£¬Õâ´ÎËãÊÇÒ»¸ö³¢ÊÔ°É£¬Ð´µÃ²»ºÃµÄµØ·½Çë´ó¼Ò¾¡Á¿Å×Î÷ºìÊÁ²»Òª¶ª×©Í·¡£
Ö®ËùÒÔ°ÑÕâ¸öϵÁнÐ×ö¡¶asp.netÒ¹»°¡·£¬ÊÇÓÐÒ»Ð©Ô­Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ