SQL Exception occured?

Question

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()


> **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 ( ' " & TextBox2.Text & " ' , ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ' , ' " & TextBox5.Text & " ' , ' " & TextBox6.Text & " ' , ' " & TextBox7.Text & " ' ,)"

        Executequery(Insertquery)

        MsgBox("Data Inserted")

    End Sub


End Class

The problem is there:

System.Data.SqlClient.SqlException: Incorrect syntax near 'Information'.

Anyone knows the solution I am Stuck with a problem in my project

Bradley Summers · Accepted Answer · 2018-05-11 04:12:43Z

1

Is your table name really “Patient Information” with a space?

If so try adding [ ] around it. Also, add these round “Patient ID”,”First Visit” and “Last Visit”

Failing that. Try running the query in SSMS and replace the textbox.texts with manually entered strings.

SSMS should tell you anything wrong with the query.

edited May 11, 2018 at 4:12

answered May 11, 2018 at 4:04

Bradley Summers

378 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marc_s · Accepted Answer · 2018-11-25 21:47:50Z

0

In "Insertquery" you use a comma (,) - remove that.

Try this

Dim cmd as new sqlcommand("INSERT INTO [Patient Information](F_Name ,L_Name, Patient ID, Disease, First Visit, Last Visit) VALUES ( ' " & TextBox2.Text & " ' , ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ' , ' " & TextBox5.Text & " ' , ' " & TextBox6.Text & " ' , ' " & TextBox7.Text & " ' ,con")

for executing the the command connection is required.

in your program, remove the comma in the sqlcommand.

edited Nov 25, 2018 at 21:47

marc_s

760k185 gold badges1.4k silver badges1.5k bronze badges

answered May 11, 2018 at 8:14

Shyju C R

115 bronze badges

1 Comment

Shyju C R Over a year ago

can you give the screen shot? for better understanding.

Collectives™ on Stack Overflow

SQL Exception occured?

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related