ÏñASPÒ»ÑùÇáËÉʵÏÖ·ÖÒ³ÏÔʾÊý¾ÝC#
´úÂëÈçÏ£º
<%@ Page Language="C#" Debug="true" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<Script Language="C#" runat="server">
int Record_Per_Page;//¶¨ÒåÿҳÏÔʾ¼Ç¼Êý
int nPageCount;//¶¨Òå×ÜÒ³Êý
int nRecCount;//¶¨Òå×ܼǼÊý
int nPage;//¶¨Ò嵱ǰҳ
void Page_Load(Object src,EventArgs e){
//È¡µÃµ±Ç°Ò³ÊýÖµ£¬²¢ÅжÏ
if(Request["pagesize"]==null)
Record_Per_Page=9;
else
Record_Per_Page=Convert.ToInt32(Request["pagesize"]);
//Á¬½ÓÊý¾Ý¿â
SqlConnection conn;
conn =new SqlConnection(ConfigurationSettings.AppSettings["strconn"]);
conn.Open();
//Ö´ÐÐSQLÓï¾ä
string ConnStr="select id,name,demo,pic from download where classid=23 or classid=24 order by time desc";
SqlDataAdapter odAdapt = new SqlDataAdapter(ConnStr,conn);
DataSet DS = new DataSet();
odAdapt.Fill(DS);
DataTable DT = DS.Tables[0];
//»ñµÃ×ܼǼÊý
nRecCount = DT.Rows.Count;
//ÅжÏÊÇ·ñ´æÔÚÊý¾Ý¼Ç¼
if(nRecCount > 0){
//È·¶¨Êý¾Ý¼Ç¼ҪÏÔʾµÄÒ³ÃæÊý
nPageCount=nRecCount/Record_Per_Page;
if(nRecCount % Record_Per_Page > 0)
nPageCount ++;
if(nPage < 1)
nPage = 1;
if(nPage > nPageCount)
nPage = nPageCount;
//½«Ò³ÊýÏÔʾµ½ÆÁÄ»ÉÏ£¬²¢×÷Á´½Ó
for(i=1;i<=nPageCount;i++){
html=html+"<a href='mblist.aspx?page="+i+"&id="+classid+"&classname="+Request.Params["classname"]+"pagesize="+Record_Per_Page+"'>";
if(i==nPage)
html=html+"<b>"+i+"</b>";
else
html=html+i;
html=html+"</a> ";
}
pagelist.InnerHtml=html;
html="";
//È·Èϵ±Ç°Ò³ÃæµÄ¿ªÊ¼¼Ç¼ºÍÖÕÖ¹¼Ç¼
int nStart = Record_Per_Page * (nPage - 1);
int nEnd = nStart + Record_Per_Page - 1;
if(nEnd > nRecCount - 1)
nEnd = nRecCount - 1;
//ÔÚÆÁÄ»ÖÐÊä³ö¼Ç¼
html="<table border='0' cellpadding='0' cellspacing='0' style='border-collaps
Ïà¹ØÎĵµ£º
C#Á¬½ÓSQL ServerµÄSqlConnectionµÄ×Ö·û´®£¬Ðí¶à¶¼ÊDz»ÄÜÁ¬½ÓµÄ¡£ÏÖÔÚ¸øÒ»¸öÄÜÁ¬½ÓµÄ£º
using System.Data.SqlClient;
public class sqlServerConnection {
//
public static void Main() {
//ÏÂÃæ¾ÍÊDZê×¼µÄÁ¬½Ó£¬×¢ÒâSERVERÊÇÎҵļÆËã»úÃû¡£SQLEXPRESSÊÇÊý¾Ý¿âʵÀý¡£SSPI±íʾʹÓÃWindowsµÇ½µÄÕÊ»§¡£masterÊÇÒªÁ¬½Óµ ......
<%
Private Const BITS_TO_A_BYTE = 8
Private Const BYTES_TO_A_WORD = 4
Private Const BITS_TO_A_WORD = 32
Private m_lOnBits(30)
Private m_l2Power(30)
Private Function LShift(lValue, iShiftBits)
If iShiftBits = 0 Then
LShift = lValue
Exit Function
ElseIf iShiftBits = 31 Then
If lValue And ......
'ÏÔʾ"ÉÏÒ»Ò³ ÏÂÒ»Ò³":Á´½ÓµØÖ·,×ÜÊý,Ò³Êý,ÊÇ·ñÏÔʾ×ÜÊý,ÊÇ·ñÓÃÏÂÀÁбíÌø×ª,µ¥Î»
Public Function PageControl(iCount,pagecount,page,table_style,font_style,colspan)
'Éú³ÉÉÏÒ»Ò³ÏÂÒ»Ò³Á´½Ó
action = "http://" & Request.ServerVariables("HTTP_HOST") & Request. ......
ÒÔÏÂΪÒýÓõÄÄÚÈÝ£º
<!--ÕâÊÇÒ»¸öÖ÷Ò³Îļþ-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>»ÃµÆÆ¬ÐÂÎÅ</title>
</head>
<body>
<!--#Include file="diaoyong.asp"-->
</body>
</html>
& ......
ÕâÊÇÒ»¸öÓÃc#¿ØÖÆÌ¨³ÌÐòÏ£¬ ÓÃXmlDocument ½øÐÐXML²Ù×÷µÄµÄÀý×Ó£¬°üº¬Á˲éѯ¡¢Ôö¼Ó¡¢Ð޸ġ¢É¾³ý¡¢±£´æµÄ»ù±¾²Ù×÷¡£½ÏÍêÕûµÄÃèÊöÁËÒ»¸öXMLµÄÕû¸ö²Ù×÷Á÷³Ì¡£ÊʺϸÕÈëÃÅ.net XML²Ù×÷µÄÅóÓѲο¼ºÍѧϰ¡£
¼ÙÉèÓÐXMLÎļþ£ºbooks.xml
Xml´úÂ룺
<?xml version="1.0" encoding="UTF-8"?>
<books>
< ......