ADO - Connection.Open

The Open method is used to open a connection to a database. Once the connection is open, you can then execute stored procedures or sql statements, or use sql statements to retrieve data from the database you connected to.

Read More

ADO - Command Object

The Command object is a logical wrapper around a stored procedure. The Properties collection contains a collection of Property objects which hold different pieces of information about the command object. The Parameters collection contains a collection of Parameter objects which represent arguments of a stored procedure or placeholders of a stored procedure.

Methods of the Command object

todo: Add useful methods here.

Properties of the Command object

todo: add useful properties here.

VB.Net - Service Advanced

Given this basic set of code

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Public Class SasdDirWatchService : Inherits System.ServiceProcess.ServiceBase

Public Shared Sub Main()
Dim ServicesToRun() As System.ServiceProcess.ServiceBase
ServicesToRun = New System.ServiceProcess.ServiceBase() {New SasdDirWatchService}
System.ServiceProcess.ServiceBase.Run(ServicesToRun)
End Sub

Protected Overrides Sub OnStart(ByVal args() As String)
' Add code here to start your service. This method should set things
' in motion so your service can do its work.
End Sub

Protected Overrides Sub OnStop()
' Add code here to perform any tear-down necessary to stop your service.
End Sub

End Class

I think it’s possible to expand this a bit so that when the service is being started or stopped you get messages
like ‘Starting’ and ‘Started’.

Read More

Hexo World

Hexo is a static source code generator specializing in blog type websites.

It’s open source so it’s free. But it’s like one piece to a bigger puzzle. You get hexo, then a layout (or a theme), then you get other add-in’s like Search and Disqus - each one from a different vendor. Each supported by different people, each documented differently. Good luck I say.

To develope sites in Hexo, you need:

  • A pretty good understanding how to use the dos prompt,
  • To install quite a few tools. Each of which you need to get familiar with.

Read More

JSON-2-SQL-DateTime

Topic, on examining a JSON input stream, Michelle found something like

1
<datebuilt>224121600000 </datebuilt>

In studying this a bit, it turns out 224121600000 is the number of milliseconds since the javascript
epoch date which is Jan 1, 1970 at midnight.

Read More