C#——µ÷Óô洢¹ý³Ì·½·¨
ÏÂÃæÊÇÎÒ×Ô¼º×ܽáµÄÒ»¸ö±È½Ï¼òµ¥µÄc#µ÷ÓÃSQL Server 2005´æ´¢¹ý³ÌµÄСÀý×Ó£¬Ö÷ÒªÊǽéÉÜÕû¸ö¹ý³Ì£¬ÓÐÎÊÌâµÄ»°Çë´óϺÃÇÖ¸µ¼£¬Ð»Ð»~
×÷Õߣºshinehoo
1£©´æ´¢¹ý³ÌÕâÑùдµÄ
ALTER PROCEDURE dbo.procShowLog
(
@StartTime datetime,
@EndTime datetime,
@LogSite varchar(20),
@UserName varchar(30)
)
AS
/* SET NOCOUNT ON
*/
BEGIN
IF(@UserName = ‘’)
BEGIN
select *
from tbLog where LogInTime
> @StartTime and LogInTime < @EndTime and LogSite = @LogSite;
END;
ELSE
BEGIN
select * from tbLog where LogInTime
> @StartTime and LogInTime < @EndTime and LogSite = @LogSite and UserName
= @UserName;
END;
RETURN
END;
2£©C#ÀïÃæÓи÷ÀàרÃŵ÷Óô洢¹ý³Ì
/// <summary>
/// Ö´Ðд洢¹ý³Ì·µ»ØÒ»¸ö±í¡£
/// </summary>
/// <param
name="proName">´æ´¢¹ý³ÌÃû</param>
/// <param
name="paraValues">²ÎÊýÖµÁбí</param>
/// <returns>DataTable¶ÔÏó</returns>
public static DataTable getDataTable(string proName, SqlParameter[]
paraValues)
{
SqlConnection
sqlcon = getConnection();
&nbs
Ïà¹ØÎĵµ£º
ed2k://|file|[ReadFree]_C#.¿ª·¢ÈËÔ±Ö¸ÄÏ——ASP_NET¡¢XML¡¢web·þÎñÓë.ADO_NET_11030729.rar|6563070|B1CBF4D0032C8D78FB10F5F2AE6C3882|/
ed2k://|file|[ReadFree]_C#ÍøÂçÓ¦Óñà³Ì_11041620.rar|8063056|7044A65903D86BF88BE8AF26D8E02B61|/
ed2k://|file|[ReadFree]_Java.P2P³ÌÐòÉè¼Æ_11052086.rar|8742852| ......
1 using System;
2 using System.Collections;
3 using System.Configuration;
4 using System.Data;
5 using System.Linq;
6 using System.Web;
7 using System.Web.Security;
8 using&nbs ......
ÔÚC#.netÖÐÈçºÎ²Ù×÷XML
ÔÚC#.netÖÐÈçºÎ²Ù×÷XML
¿ÉÄܺܶàÅóÓÑ»¹Ã»ÓнøÐйýXML²Ù×÷,Ï£ÍûÏÂÃæÕâÆªÎÄÕÂÄܶԴó¼ÒÓаïÖú.»òÕß×Ô¼º¸´ÖÆÒ»Ï´úÂëÊÔÒ»ÏÂ.ÕâÆªÎÄÕ²»ÊÇÎÒдµÄ.ÎÒÖ»ÊÇת¹ýÀ´.¾õµÃ²»´í.
ÐèÒªÌí¼ÓµÄÃüÃû¿Õ¼ä£º
using System.Xml;
¶¨Ò弸¸ö¹«¹²¶ÔÏó£º
XmlDocument xmldoc ;
XmlNode xmlnode ;
XmlElement xmlele ......
c#±à³Ì»ù´¡Ö®¶þ£ºÌØÐÔ ÕâÀïµÄÌØÐÔÇø±ðÓÚÊôÐÔ£¬ËäÈ»msdnÖÐËÆºõ²¢Ã»ÓÐÇø±ð¶þÕß¡£
ÊôÐÔ£ºÊÇÃæÏò¶ÔÏó±à³ÌµÄ»ù±¾¸ÅÄÌṩÁ˶Ô˽ÓÐ×ֶεķÃÎÊ·â×°£¬ÔÚC#ÖÐÒÔgetºÍset·ÃÎÊÆ÷·½·¨ÊµÏֶԿɶÁ¿ÉдÊôÐԵIJÙ×÷£¬ÌṩÁ˰²È«ºÍÁé»îµÄÊý¾Ý·ÃÎÊ·â×°¡£
ÌØÐÔ£º¹«¹²ÓïÑÔÔËÐÐʱÔÊÐíÌí¼ÓÀàËÆ¹Ø¼ü×ÖµÄÃèÊöÉùÃ÷£¬½Ð×öattributes, Ëü¶Ô³ÌÐòÖеÄÔ ......