您好，我用了您这种方法，不错，测试也挺好，不过正式用，对用户统计不准呀，有的人都下一天了，还显示在线，有什么好的解决办法吗？

<script runat="tempate">
public enum CollectionTypeEnum
{
Vector,
HashTable,
SortedList
}
</script>

tempate-》template

不好意思 没看太明白 您能给我一个Demo吗？？

我也正好用到

按你的改44

我用SYSTEM.TIMER一直失效 郁闷呀

这个方法不错，谢谢

@jirong
不错
在看你的网站之前我不太清楚游标的具体用法
现在我已经会使用游标查询数据了
谢谢你

附上ORACLE的游标的用法以示感谢
DECLARE CURSOR CUR_M_SHOHINHOTEL IS
SELECT
H.SEQ, H.USEDATE,
TO_CHAR(TO_DATE('2006/12/12') + H.USEDATE - 1, 'YYYYMMDD') AS USEDAY,
H.HOTELCD, H.MEALTYPECD, H.ROOMCATEGORYCD, H.OUTPUTFLAG,
H.TKTCD, H.TKTREMARKSCD, H.SUPPLIERCD, H.SORTORDER,
R.NAME AS TKTREMARKSNAME, L.NAME, L.TEL,
H.REMARKSCD,H.SEQREMARKS, L.DISPLAYFLAG
From

_SHOHINHOTEL H,
M_HOTEL L,
M_TKTREMARKS R WHERE
H.TKTREMARKSCD = R.CODE(+) AND
H.HOTELCD = L.CODE(+) AND
H.CODE1 = '00' AND "
H.CODE2 = '0000' AND "
H.CODE3 = '00'
ORDER BY H.USEDATE,H.SEQ;

TYPE_M_SHOHINHOTEL CUR_M_SHOHINHOTEL%ROWTYPE;

BEGIN
PEN CUR_M_SHOHINHOTEL;
Loop
FETCH CUR_M_SHOHINHOTEL INTO TYPE_M_SHOHINHOTEL;
EXIT WHEN CUR_M_SHOHINHOTEL%NOTFOUND;

INSERT INTO Y_HOTEL(
BRANCHCD, BOOKINGNO, REV, SEQ,
STDATE, USEDATE, HOTELCD, MEALTYPECD,
FIRSTFLAG, ROOMCATEGORYCD, TKTCD, TKTREMARKSCD,
TKTREMARKSDETAIL,REGDATE, REGTIME, UPDCHARGER,
DISPLAYFLAG, SUPPLIERCD, SORTORDER, HISTORYDATE,
PAXMALE, PAXFEMALE, PAXCHILD, PAXINFANT,
STATUS, TEHAISTATUS,OUTPUTFLAG, UPDCHARGERCD,
HOTELNAME, HOTELTEL, REMARKSCD, SEQREMARKS
) VALUES (
'SZ',
'123456',
'00',
TYPE_M_SHOHINHOTEL.SEQ,
TYPE_M_SHOHINHOTEL.USEDATE,
YPE_M_SHOHINHOTEL.USEDAY ,
TYPE_M_SHOHINHOTEL.HOTELCD,
TYPE_M_SHOHINHOTEL.MEALTYPECD,

'1',
TYPE_M_SHOHINHOTEL.ROOMCATEGORYCD,
TYPE_M_SHOHINHOTEL.TKTCD,
TYPE_M_SHOHINHOTEL.TKTREMARKSCD,"
TYPE_M_SHOHINHOTEL.TKTREMARKSNAME,

TO_CHAR(SYSDATE,'YYYYMMDD'),"
TO_CHAR(SYSDATE,'HH24MISS'),"
'ZHUIMENGKE',

TYPE_M_SHOHINHOTEL.DISPLAYFLAG,
'1',
TYPE_M_SHOHINHOTEL.SUPPLIERCD,
TYPE_M_SHOHINHOTEL.SORTORDER,
TO_CHAR(SYSDATE,'YYYYMMDD'),
1,
2,
3,
4,
'0', '0',
TYPE_M_SHOHINHOTEL.OUTPUTFLAG,
'ZHUIMENGKE',
TYPE_M_SHOHINHOTEL.NAME,
TYPE_M_SHOHINHOTEL.TEL,
TYPE_M_SHOHINHOTEL.REMARKSCD,
TYPE_M_SHOHINHOTEL.SEQREMARKS);
END LOOP;
CLOSE CUR_M_SHOHINHOTEL;
END;

谢谢你的文章，我刚好用到！！

分页控件

好文!

wertwer

werwer

　不错不错

以后有用的上的时候我就过来参考下，　现在感觉你已经挺行的了是吗，好好努力你是有前途的．

在 MS的cache ， 做xml传输 或者webservice等等都要用上，得要注意哪些类不能被序列化

USE pubs
DECLARE tnames_cursor CURSOR
FOR
SELECT state ,au_id
FROM authors
open tnames_cursor
declare @state varchar(50)
declare @au_id varchar(50)
Fetch tnames_cursor into @state,@au_id

while (@@fetch_status=0)
begin
if(@state='CA')
begin
print @au_id
end
FETCH NEXT FROM tnames_cursor INTO @state,@au_id
end
CLOSE tnames_cursor
DEALLOCATE tnames_cursor

public static DataSet RunProcedure1(string storedProcName, IDataParameter[] parameters)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet dataSet = new DataSet();
connection.Open();
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters );
sqlDA.Fill( dataSet);
connection.Close();
return dataSet;
}
}

/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere,string strTableName,string strPKID)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = strTableName;
parameters[1].Value = strPKID;
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 1;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure1("UP_GetRecordByPage",parameters);
}