Article Discussion: Creating A Windows Service in VB.NET

Creating A Windows Service in VB.NET If you have any comments or questions about this article then please post them here.

You can read the article here .

Is someone going around rating all the articles bad? I read the article, and it certainly deserved more than a 2!

Hello Jayesh Jain,

Thanks for the Article. It's really help me lots. I have couple questions if you don't might answering. First, could you please tell me where can I download the Windows Service Template? My VB .NET doesn't have it. Second, is it possible to build a windows service to interact with a web service? If it is, could you kindly give me some hints or direction?

Many Thanks
Tuoc

Thank you very much for all the information.
The article is just too good.....it works great for me.
I was wondering if there is a way to start a new process....start an executable on certain event.
If so can you help me with it.

Thank you very much for your time

Does anybody have an answer as to how can we open a new process from a windows service.??

Thanks for your time

Hi Jayesh,

Gone thro' ur article. It's very nice !!!

I need to use windows services in my module to poll the database. I'm using SQL server as backend & ASP.NET using vb.net. But i'm not getting how to use a connection string in it.

Will u plz help me in connecting services to the database.

Waiting for ur earliest reply .

The service created in .Net is to be running by installutil.

How can we automatically run the service when Windows is boot up ?

I also want to know how to create Service without .Net.

Microsoft seems keeping secret in "Service" and not giving us very easy way to create service (prior to .Net). Very strange !!! Not documented ..............

I am trying to create a windows service using Visual Studio.Net (2002) that will query one database and update another with the results.

My code works fine in a web app - but I need this repeated every 10-15 minutes - so I built a windows service around it.

The service does not show any build errors - and it writes to the log just fine - but it seems to just ignore the whole query/insert record section... Can windows services do that???

Thanks!
Kristina

Private Sub Timer1_Elapsed(ByVal sender As System.Object, ByVal e As System.Timers.ElapsedEventArgs) Handles Timer1.Elapsed


Dim MyLog As New EventLog() ' create a new event log
' Check if the the Event Log Exists
If Not MyLog.SourceExists("MyService") Then
MyLog.CreateEventSource("MyService", "Myservice Log") ' Create Log
End If
MyLog.Source = "MyService"
' Write to the Log
MyLog.WriteEntry("MyService Log", "Test 3 " & _
CStr(TimeOfDay), EventLogEntryType.Information)

Call UpdateData()

End Sub

Sub UpdateData()
Me.selectRsched.CommandText &= " WHERE entry_date = {d '" & DateTime.Now.ToString("yyyy\-MM\-dd") & "'} " & _
" AND entry_time > '" & DateTime.Now.AddMinutes(-15).ToString("HH:mm") & "'"
Me.qryRsched.Fill(Me.DsRsched)

Me.conSuperTED.Open()
Dim index As Integer = 0
While index < Me.DsRsched.Tables(0).Rows.Count
Me.insertEmailTransactions.Parameters("@trans_no").Value = Me.DsRsched.Tables(0).Rows(index).Item("trans_no")
Me.insertEmailTransactions.Parameters("@emailed").Value = 0
Me.insertEmailTransactions.Parameters("@reminded").Value = 0
Me.insertEmailTransactions.ExecuteNonQuery()
index = index + 1
End While
Me.conSuperTED.Close()
End Sub