title: SQL Exception occured?
body: <pre><code>Imports System.Data.SqlClient
  
  Public Class Form_sign_in_
  
      Dim connection As New SqlConnection("Server=TAYYAB-PC\SQLEXPRESS;Database=Hospital Management;Integrated Security=True;Trusted_Connection=True;User=sa;Pwd=Password1;")
      Dim SQL As New SQL_Control
  
  
      Private Sub Form_sign_in__Load(sender As Object, e As EventArgs) Handles MyBase.Load
  
  
          If SQL.HasConnection = True Then
              MsgBox("Succesfully connected! ")
          End If
  
      End Sub
  
  
      Public Sub Executequery(query As String)
  
          Dim command As New SqlCommand(query, connection)
  
          connection.Open()
  
  
  &gt; **command.ExecuteNonQuery()**// the problem part
  
          connection.Close()
  
      End Sub
  
      Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
  
          Dim Insertquery As String = "INSERT INTO Patient Information
  
             (F_Name , L_Name, Patient ID, Disease, First Visit, Last Visit) VALUES ( ' " &amp; TextBox2.Text &amp; " ' , ' " &amp; TextBox3.Text &amp; " ' , ' " &amp; TextBox4.Text &amp; " ' , ' " &amp; TextBox5.Text &amp; " ' , ' " &amp; TextBox6.Text &amp; " ' , ' " &amp; TextBox7.Text &amp; " ' ,)"
  
          Executequery(Insertquery)
  
          MsgBox("Data Inserted")
  
      End Sub
  
  
  End Class
  </code></pre>
  
  <p>The problem is there:</p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlException: Incorrect syntax near
    'Information'.</p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/E4KN9.jpg" alt="https://i.stack.imgur.com/E4KN9.jpg"></p>
  
  <p>Anyone knows the solution I am Stuck with a problem in my project </p>