Question

Here is my code to insert data into a database.

code:

private void button2_Click(object sender, EventArgs e)
{
//Insert Button
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source = C:\project\patientDB.accdb";
OleDbConnection connection = new OleDbConnection(connString);
OleDbCommand cmd = connection.CreateCommand();

cmd.CommandText = "insert into Medical ([PatientID],[GeneralMedicalHistoryID],[Education] values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "' )";

connection.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Record Inserted");
connection.Close();
}

However it says syntax error in INSERT statement when I try to add. What am I doing wrong.

Here is a screenshot of the fields in the table.

Modica ntID -Maritaistatu:-Education ". GrowthAndC Pregnancies ㅜ BehavioralHi- Tobacco -TobaccoHRF-TobaccoQ TobaccoHRF Tobaccoa New

Answer 1

You are missing to open connection before insert query .

you are calling "connection.Open();" after insert query. Remove from that place and place that code before insert query in same code.