INSERT INTO 语句的语法错误。

Question

OleDbCommand cmd=new OleDbCommand("insert into liuyan(name,body,time) values(@name,@body,@time)",Conn);
OleDbParameter para=new OleDbParameter("@name",OleDbType.VarChar,10);
para.Value=TextBox1.Text;
cmd.Parameters.Add(para);
para=new OleDbParameter("@body",OleDbType.VarChar,500);
para.Value=TextBox2.Text;cmd.Parameters.Add(para);
para=new OleDbParameter("@time",OleDbType.Date,8 );
para.Value=System.DateTime.Now.ToShortTimeString().ToString();
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();本来想插入时间来着，结果出现：INSERT INTO 语句的语法错误。

Answer 1

change
OleDbCommand cmd=new OleDbCommand("insert into liuyan(name,body,time) values(@name,@body,@time)",Conn);with
OleDbCommand cmd=new OleDbCommand("insert into liuyan([name],[body],[time]) values(@name,@body,@time)",Conn);