VB ExecuteNonQuery() Working But Data Not Saved Into Sql Server DB?

I am having a hard time figuring this out. It's about ExecuteNonQuery() method and sql server database. I done several testing and still getting the desired result which is data captured from application window and saved into sql server database table.

Some results i gotten from my testing:Query - Senario 1:From application window, data was captured into variable memory but didnt save into database and end up with blank database. (Tested many rounds still end up in this senario)Senario 2:Used the command console in the data explorer frame, with the insert query along with required value, an entry was made. (Test a couple of rounds and i know it worked)

ExecuteNonQuery() - Tested using if/else method as shown below and the result was pass that show the method is working. This testing method was found from this link: [URL]Below is my create Method(sentence with ' are comments):

Dim DatabaseConnection As String = My.Settings.QuotationDatabase [color="#00FF00"]'Connection to Database[/color]
Dim SqlConnection As New System.Data.SqlClient.SqlConnection(DatabaseConnection) [color="#00FF00"]'Linking Database Connection via SqlClient to Application[/color]
Dim Query As String = "Insert Into Clients2 (Title, Name, Email, Designation, ResidentialNumber, MobileNumber, CompanyName,

[code]....