خطا در ExecuteNonQuery

[ninja_boy]

با سلام
تابع mycommand.ExecuteNonQuery(); پیغام خطا می دهد



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;

namespace proje
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
int query;
}

private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'database1DataSet.Table1' table. You can move, or remove it, as needed.

}

private void button2_Click(object sender, EventArgs e)
{
OleDbConnection myconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = .\\Database1.mdb");
string query = "('" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
DataSet mydataset = new DataSet();
myconnection.Open();
OleDbCommand mycommand = new OleDbCommand();
mycommand.CommandText = query;
mycommand.Connection = myconnection;
mycommand.ExecuteNonQuery();
mydataset.AcceptChanges();
myconnection.Close();
}

private void button1_Click(object sender, EventArgs e)
{
OleDbConnection objconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = .\\Database1.mdb");
string query = "select * from Table1";
DataSet mydataset = new DataSet();
OleDbDataAdapter myadap = new OleDbDataAdapter(query, objconnection);
myadap.Fill(mydataset);
foreach (DataTable table in mydataset.Tables)
{
foreach (DataRow row in table.Rows)
{
if (textBox1.Text == row["name"].ToString())
dgv.Rows.Add(row["name"].ToString(), row["Phone"].ToString(), row["Address"].ToString(), row["Email"].ToString());

}

}
}
}
}

[hsmfaridmehr]

private void button2_Click(object sender, EventArgs e)
{
OleDbConnection myconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = .\\Database1.mdb");
string query = "('" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
DataSet mydataset = new DataSet();
myconnection.Open();
OleDbCommand mycommand = new OleDbCommand();
mycommand.CommandText = query;
mycommand.Connection = myconnection;
mycommand.ExecuteNonQuery();
mydataset.AcceptChanges();
myconnection.Close();
}

باید هم بگیره

خوب این COMMAND شما نباید شامل یکی از چهار دستور باشه

اگه قصد INSERT کردن رو داری برای مثال باید این طور بنویسی


string query = "INSERT INTO TABLENAME (FirstName,LastName,Address,PhoneNumber) VALUES ('" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";