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

asp.netµÄsql·À×¢Èë


/// <summary>
    /// ¹ýÂ˱ê¼Ç
    /// </summary>
    /// <param name="NoHTML">°üÀ¨HTML£¬½Å±¾£¬Êý¾Ý¿â¹Ø¼ü×Ö£¬ÌØÊâ×Ö·ûµÄÔ´Âë </param>
    /// <returns>ÒѾ­È¥³ý±ê¼ÇºóµÄÎÄ×Ö</returns>
    public static string NoHTML(string Htmlstring)
    {
        if (Htmlstring == null)
        {
            return "";
        }
        else
        {
            //ɾ³ý½Å±¾
            Htmlstring = Regex.Replace(Htmlstring, @"<script[^>]*?>.*?</script>", "", RegexOptions.IgnoreCase);
            //ɾ³ýHTML
            Htmlstring = Regex.Replace(Htmlstring, @"<(.[^>]*)>", "", RegexOptions.IgnoreCase);
            Htmlstring = Regex.Replace(Htmlstring, @"([\r\n])[\s]+", "", RegexOptions.IgnoreCase);
            Htmlstring = Regex.Replace(Htmlstring, @"-->", "", RegexOptions.IgnoreCase);
            Htmlstring = Regex.Replace(Htmlstring, @"<!--.*", "", RegexOptions.IgnoreCase);
            Htmlstring = Regex.Replace(Htmlstring, @"&(quot|#34);", "\"", RegexOptions.IgnoreCase);
            Htmlstring = Regex.Replace(Htmlstring, @"&(amp|#38);", "&", RegexOptions.IgnoreCase);
  &nb


Ïà¹ØÎĵµ£º

Excelµ¼ÈëSQL SERVERÖÐ

--Excelµ¼ÈëSQL SERVERÖÐ
--±í½á¹¹²»´æÔÚ¿ÉÒÔʹÓÃ
--ÆôÓÃAd Hoc Distributed Queries£º
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
select * into serv_user_bak1 from
OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;HDR=yes;dat ......

SQLÃæÊÔÌ⣨תÔØ£©

SQLÃæÊÔÌ⣨1£©
create table testtable1
(
id int IDENTITY,
department varchar(12)
)
select * from testtable1
insert into testtable1 values('Éè¼Æ')
insert into testtable1 values('Êг¡')
insert into testtable1 values('ÊÛºó')
/*
½á¹û
id department
1   Éè¼Æ
2   Êг¡
3& ......

win7 Ï ÅäÖà SQL Server 2005 ÔÊÐíÔ¶³Ì·ÃÎÊ

win7 Ï ÅäÖà SQL Server 2005 ÔÊÐíÔ¶³Ì·ÃÎÊ
2010Äê2ÔÂ2ÈÕ bibiQ
±¾À´Ò»Ö±²»Ô¸ÒâÅäÖÃÔ¶³Ì·ÃÎÊSQL server£¬µ«½ñÌìÒ»ºÝÐÄ°ÑËüÅäºÃÁË¡£
²Î¿¼ÁËÍøÉϵÄÌû×Óhttp://www.cnblogs.com/sukiwqy/archive/2009/11/11/1601381.html
step1£º ÅäÖÃSQL Server ÍâΧӦÓÃÅäÖÃÆ÷£¨Îª SQL Server 2005 ÆôÓÃÔ¶³ÌÁ¬½Ó¡¢ÆôÓà SQL Server Brow ......

Asp.net Ajax webserviceʱ¼ä´Á

  ÔÚʹÓÃAJAX½øÐгÌÐò¿ª·¢µÄʱºò£¬Ò»Ö±¶¼»áÃæ¶ÔÒ»¸ö»º´æµÄÎÊÌ⣡£¡
¼´ÊÇ£¬ÉÏ´ÎÇëÇóµÄʱºò£¬ÒòΪÄãµÄSQLÓï¾ä»òÕßÆäËûÔ­Òò£¬webserviceÖзµ»ØֵΪ¿Õ£¬²»ÊÇÄãÏëÒªµÄ½á¹û¼¯£¬ÔÚÄã·¢ÏÖwebserviceÖÐÓï¾äÌå³ö´íºó£¬½øÐÐÐ޸ģ¬ÖØвâÊÔ£¬ÈÔÈ»ÊÇÉϴεķµ»Ø½á¹û£¡¸Ð¾õ¾ÍÏñÄãµÄÐÞ¸ÄÍêÈ«ÎÞЧ¡£¡£
   Æäʵ£¬ÕâÊÇÔÚAJAXµ ......

Asp.net ×Ô¶¯·¢ËÍÓʼþµÄ·½·¨


Asp.net ×Ô¶¯·¢ËÍÓʼþµÄ·½·¨ 
½ñÌìÓÐÒ»¸öÄ£¿éÐèÒª×Ô¶¯·¢ËÍÓʼþµÄ¹¦ÄÜ£¬¾ÍËæ±ãдÁËÒ»¸ö£¬¼Ç¼һÏÂ×÷Ϊ»ýÀÛ¡£
Ò»¡¢Ê×ÏÈÐèÒªÅäÖÃweb.configÎļþ£º
<system.net>
  <mailSettings>
    <smtp from="Emailname">
        <network ho ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ