C# Asp.NET Éú³ÉGOOGLEµØÍ¼ºÍË÷Òý
£¨1£©Ê×ÏÈÒª¶ÔÄÚÈݵÄÌØÊâ×Ö·û½øÐйýÂÇ£º
C# ´úÂ룺
public string res(string partno)
{
partno = partno.Replace("&", "");
partno = partno.Replace("/", "");
partno = partno.Replace("&", "");
return partno;
}
£¨2£©´ÓÊý¾Ý¿âÖлñµÃÒªÉú³ÉµØÍ¼µÄÄÚÈÝ£º
C# ´úÂ룺
public void getXMLSitemapData(StreamWriter writerFile,int minid,int maxid)
{
SqlConnection mycon = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
string sqlstr = "Select id,name from table where id>'" + minid + "' and id <'" + maxid + "'";//Êý¾Ý¿âÄÚÈÝÓï¾ä
SqlCommand cmd = new SqlCommand(sqlstr, mycon);
mycon.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
writerFile.WriteLine("<url>");
writerFile.WriteLine("<loc>" + "http://www.uni888.com/" + res(rdr[1].ToString())+".html" + "</loc>");
writerFile.WriteLine("<lastmod>" +"2009-04-22"+ "</lastmod>");
writerFile.WriteLine("<changefreq>weekly</changefreq>");
writerFile.WriteLine("<priority>1.0</priority>");
writerFile.WriteLine("</url>");
}
}
rdr.Close();
mycon.Close();
}
(3)´´½¨²¢Ð´Èësitemaps.xml GOOGLEµØÍ¼
C# ´úÂ룺
public void createXMLSitemap(int minid,int maxid,int maps)
{
FileInfo XMLFile = null;
StreamWriter WriteXMLFile = null;
string FilePath = HttpContext.Current.Server.MapPath("sitemap"+maps+".xml");
XMLFile = new FileInfo(FilePath);
WriteXMLFile = XMLFile.CreateText();
//ÏÂÃæÁ½¾ä»°±ØÐëд£¬¶øÇÒ²»ÄÜ×öÈκÎÐÞ¸Ä
WriteXMLFile.WriteLine("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
WriteXMLFile.Wri
Ïà¹ØÎĵµ£º
ÕâÊÇÒ»¸öÓйطÖÒ³µÄʵÀý,½ö¹©²Î¿¼(´úÂëÀ´×ÔÍøÂç)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SQLite;
using System.Threading;
using System.Collections;
us ......
×î½üд³ÌÐòÒ»Ö±³öÎÊÌ⣬ÒÔǰһ¸öÕ¾Èý¼¸Ìì¾ÍÇáËɸ㶨£¬ÏÖÔÚÒ»¸öÄ£¿é¾³£¸ã°ëÌ죬NND
ÏÂÎ翪·¢¿áÒ×»¯×±Æ·É̳Ç(http://www.koyee.net)Ò»¸ö±íµ¥Ìá½»¹¦ÄÜÄ£¿é£¬±¾µØÈκÎÎÊÌⶼûÓÐÁË£¬´«µ½·þÎñÆ÷Éϱ¾ÒÔΪûÊÂÁË£¬ºóÀ´Ò»¼ì²éËùÓеÄÑéÖ¤¿Ø¼þ¶¼²»Æð×÷ÓÃÁË£¬Ö±½Ó¶¼Ìá½»¹ýÈ¥ÁË£¬ÓôÃÆ£¬ÔÒÔΪ³ÌÐò±»¸Ä´íÁË£¬¼ì²é±¾µØ»¹ÊÇûÈκÎÎÊÌ⣬¼ ......
SQL
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
--°¢»áéªsosuo8.com¸ù¾ÝÍøÂçÉϵĴúÂë½øÐÐÁËÐ޸쬰æÈ¨¹éÔ×÷ÕßËùÓÐ2009-4-5
--°¢»áéª×öÁËÒ»´ÎÉý¼¶£¬2009-9-27
--ÐÞ¸ÄÊä³ö×ܼǼÊý
ALTER PROCEDURE [dbo].[pagination]
@tblName nvarchar(1000), -- ±íÃû
......
OAÔ´ÂëΪÎÒ¹¤×÷ÊÒ¾«ÐÄ´òÔì,ÓÃÁËÈýÄêµÄʱ¼ä,²ÅÐÞÕýÍêÉÆµÄ´óÐͰ칫ϵͳ.
Ϊ¶ÀÁ¢¿ª·¢,²»´æÔÚ°æÈ¨¾À·×,²»»á¸øÄú´øÀ´Âé·³,´úÂëÍêÕû£¬Öø×÷ȨµÇ¼ÇºÅ£º2008SR14608.
OA×îÐÂÉý¼¶£¬¹¤×÷Á÷¸üÇ¿´ó£¬±íµ¥¶¨Òå¸üÎȶ¨
ÇëÈÏ×¼ÁªÏµ·½Ê½£¬½÷·À¼Ùð¡£
Ϊ½ÚÔ¼¿ª·¢³É±¾£¬OAÔ´Âë¿ÉÒÔ·ÖÄ£¿é½øÐÐÌṩ
ÓÀ¾Ãά»¤£¬Óг¥2´Î¿ª·¢
Èí¼þ¹¦ÄÜ·ÖΪרҵ° ......
ASP.NET»ñÈ¡¿Í»§¶ËÐÅÏ¢,ÔÝʱ¾ÍÕ⼸¸ö,ÓдýÌí¼Ó~~
1. ÔÚASP.NETÖÐרÓÃÊôÐÔ£º
»ñÈ¡·þÎñÆ÷µçÄÔÃû£ºPage.Server.ManchineName
»ñÈ¡Óû§ÐÅÏ¢£ºPage.User
»ñÈ¡¿Í»§¶ËµçÄÔÃû£ºPage.Request.UserHostName
»ñÈ¡¿Í»§¶ËµçÄÔIP£ºPage.Request.UserHostAddress
2. ÔÚÍøÂç±à³ÌÖеÄͨÓ÷½·¨£º
»ñÈ¡µ±Ç°µçÄÔÃû£ºstatic System. ......