摘要：
1 Private Function PageCalc(ByVal TotalIDs As String, ByVal PageNumber As Integer, ByVal PerPage As Integer, ByRef TotalAmount As Integer, ByRef TotalPage As Integer) As String 2 On Error Resume Next 3 4 'Split to arr 5 Dim IDsArr() As String = TotalIDs.Split(",") 6 ... 阅读全文
摘要：
1 Public Class MainForm 2 3 Dim t0 As System.Threading.Thread '监控 4 Dim t1 As System.Threading.Thread 'immediate 5 Dim t2 As System.Threading.Thread 'everyday 6 Dim t3 As System.Threading.Thread 'everyweek 7 8 Dim PermitNextTask As Boolean = True 9 Dim IsTaskRunni... 阅读全文
摘要：
1 Partial Class Test_MapTest 2 Inherits System.Web.UI.Page 3 4 5 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 6 7 Dim StartTime As DateTime = Now 8 9 Dim FABCStatus As New ABCStatus10 11 For I = 1 To 10012 ... 阅读全文
摘要：
在Sql Server中可以通过信息架构视图来获取数据： SELECT * FROM INFORMATION_SCHEMA.TABLES 获取表名的清单： SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' 获取视图名清单： SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'VIEW' 还有获取列，存储过程等，具体可以查看SQL SERVER 的联机帮助。 阅读全文
摘要：
数据库常用命令 向表中增加一个 varchar 列： ALTER TABLE distributors ADD COLUMN address varchar(30); 从表中删除一个字段： ALTER TABLE distributors DROP COLUMN address RESTRICT; 在一个操作中修改两个现有字段的类型： ALTER TABLE distributors ALTER COLUMN address TYPE varchar(80), ALTER COLUMN name TYPE varchar(100); 使用一个 USING 子句， 把一个包含 ... 阅读全文