Private Sub startserver() bstop = False Dim OrderForm, ddh, matnrh As String Dim MyLocalDataReader As SqlDataReader Dim MyprdDataReader As SqlDataReader Dim mykc As SqlDataReader Dim kcsl, prdsl, tempsl As Long Dim flag As Boolean = False Dim mat As String Dim vrm As Long While Not bstop Try SqlCMDtemp.CommandText = "delete from tb_ty_cctemp" SqlCMDtemp.Connection = SqlConnection_local SqlCMDtemp.ExecuteNonQuery() If SqlCMDtemp.ExecuteNonQuery() = 0 Then mythread.Sleep(180000) End If End While mythread.Sleep(180000) Catch ex As Exception bstop = True End Try End While End Sub Private Sub stopserver() Dim i As Integer = 0 bstop = True Try SqlConnection_local.Close() SCMlocal.CommandText = "insert into MyServiceLog(vc_status,dt_created) values('服务关闭',getdate())" SqlConnection_local.Open() SCMlocal.Connection = SqlConnection_local i = SCMlocal.ExecuteNonQuery Catch ex As Exception bstop = True End Try End Sub Protected Overrides Sub OnStart(ByVal args() As String) ' 在此处添加启动服务的代码。此方法应设置具体的操作 ' 以便服务可以执行它的工作。 Dim i As Integer Try SqlConnection_local.Close() SCMlocal.CommandText = "" SCMlocal.CommandText = "insert into MyServiceLog(vc_status,dt_created) values('服务启动',getdate())" SqlConnection_local.Open() SCMlocal.Connection = SqlConnection_local i = SCMlocal.ExecuteNonQuery Catch ex As Exception bstop = True End Try mythread = New Thread(AddressOf startserver) mythread.Start() End Sub Protected Overrides Sub OnPause() mythread.Suspend() End Sub Protected Overrides Sub OnContinue() mythread.Resume() End Sub Protected Overrides Sub OnStop() ' 在此处添加代码以执行停止服务所需的关闭操作。 Me.stopserver() End SubEnd Class假如需要把服务时间写入windows事件日志,以下的代码片断使用eventlog对象把一个项放入application日志中:dim log as new eventlog("application")log.source="program name"log.writeentry("message to place into the event log")log.close添加安装在设计视图右击,选择添加安装程序并进行相应的设置使用installutil程序进行安装