How to do unit testing for a subroutine using Visual Studio 2010?

See more:

VB

ASP.NET

Visual-Studio

testing

, +

Hi,

I want to unit test a subroutine.
The code is like this.

Public Sub UpdateChat()

    'Getting the connection string
    Dim connectString As String = ConfigurationManager.ConnectionStrings("ShoutDb").ConnectionString

    'Creating connection object
    Dim connect As SqlConnection = New SqlConnection(connectString)

    'Declaring variable to store sqlcommand
    Dim command As New SqlCommand

    'Initialising the sql command to the varaible
    command.CommandText = "INSERT INTO [ShoutBox].[dbo].[CommonShout]([UserName],[Message],[SubmitTime]) VALUES('" & Session("UserName").ToString & "','" & smiley() & "',Convert(datetime,'" & DateTime.Now.ToString & "',120))"

    'Connecting to database
    connect.Open()

    'Connecting the sql command with the database.
    command.Connection = connect

    command.ExecuteNonQuery()
    LoadChatData()
    Me.TxtMessage.Text = String.Empty
End Sub

With the help of unit testing i want to test the above function for whether the subroutine has inserted the data into the database or not. How to accomplish this? Need help. I am new to testing.