Writing To SQL Database Manually (for Education Purposes)

I'm building an application that is intended to function off and online using the new Local Database Cache functionality included with Visual Studio 2008. My issue however does not pertain to that directly, as I have a pretty good understanding of how to use it and how it functions. My issue is with getting an understanding on how to directly write to a SQL database.

Most of the tutorials, videos and education available when it comes to databinding makes the assumption that I need my application to pull data and edit it, but in my case all I really need (in fact intentionally all I want) is for the application on Submit to write data that it pulls from the form as a new record in a SQL table.

Here is what the program looks like now.

Public Class StatCom
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

[Code].....

At the moment the program simply does a status check for connectivity and wether it can ping the server (in this case the SQL server) for the purpose of displaying a online or offline status in the form.

I follow it up by making the status checks.

Finally I declare all the various fields I want to capture and write to the database.

What I want to do now is have a SUBMIT button that on click takes all the data in the form and writes a new record to the database I have already setup and have data connection to.

I know that the code has to be written using the .recordset functionality, but I haven't found any could tutorials on the subject that have turned on the light upstairs.