Stored procedure help for VB .NET Win App

[poops2468]

I have a very simple Insert Stored Procedure. When I run it from the Server Explorer, it inserts the records just fine. However, when I try to call it from my form, it does not update the table. The weird thing is that it does return one row effected and if I try it again, I am told my primary key is not unique (meaning the first record is in there somewhere). When I exit my app, my table is just the same as it was before the inserts. Do I need to "save" or "update" the table before closing a connection? Thanks

CREATE PROCEDURE dbo.InsertNew
    (
    @A       nchar(10),
    @B      nvarchar(50),
    @C       nvarchar(50),
    @D     nvarchar(50),
    @E         nvarchar(50),
    @F           nvarchar(50),
    @G           nvarchar(50),
    @H       nvarchar(50)
    )
AS
INSERT INTO Users
    (
        A,
        B,
        C,
        D,
        E,
        F,
        G,
        H
    )
    VALUES
    (
    @A,
    @B,
    @C,
    @D,
    @E,
    @F,
    @G,
    @H
    )
    RETURN
 
 
 
 
 
Dim connection As SqlConnection
connection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True")
connection.Open()
Dim command As SqlCommand = New SqlCommand("InsertNew", connection)
command.CommandType = CommandType.StoredProcedure
 command.Parameters.AddWithValue("@A", "99")
 command.Parameters.AddWithValue("@B", "test")
 command.Parameters.AddWithValue("@C", "test")
 command.Parameters.AddWithValue("@D", "test")
 command.Parameters.AddWithValue("@E", "test")
 command.Parameters.AddWithValue("@F", "test")
 command.Parameters.AddWithValue("@G", "test")
 command.Parameters.AddWithValue("@H", "test")
Dim rows
rows = command.ExecuteNonQuery
connection.Close()
 
        If (rows = 1) Then
           MessageBox.Show("Create new user SUCCESS!")
        Else
            MessageBox.Show("Create new user FAILED!")
        End If
 
 

[poops2468]

Bumping for response

[Motoma]

This may have to do with some database settings, dealing with Transactions and Auto-commit settings.

I don't know much beyond that.