Question

asp.net access 总显示insert into语法错误 经过查询器运行这句没有出错 请教高手

string sql = "insert into Image(ImTime,ImSize,ImData,ImContentType,ImDiscription,ImTitle,ImType) values(@Imtime,@size,@data,@ContentType,@discription,@title,@type)";//"INSERT INTO Image(ImageTime,ImageSize,ImageData,ImageContentType,ImageDiscription,ImageTitle,ImageType)VALUES(@time,@size,@data,@ContentType,@discription,@title,@type)";
OleDbCommand comm = new OleDbCommand(sql, conn); //建立SQL Server链接
/*System.Data.OleDb.OleDbParameter paramData = new OleDbParameter("@data", System.Data.OleDb.OleDbType.Binary);
paramData.Value = FileByteArray;
comm.Parameters.Add(paramData); */
comm.Parameters.Add("@data", OleDbType.Binary, FileByteArray.Length).Value = FileByteArray;

comm.Parameters.Add("@title", TextBox1.Text);
comm.Parameters.Add("@Imtime", DateTime.Now.ToString());

comm.Parameters.Add("@ContentType", UpFile.ContentType); //记录文件类型
comm.Parameters.Add("@type",tp);
comm.Parameters.Add("@discription", TextBox3.Text);
comm.Parameters.Add("@size",FileLength);
comm.ExecuteNonQuery();
conn.Close();
Response.Write("<script>alert('添加成功')</script>");//提示上传成功

Answer 1

(ImageTime,ImageSize,ImageData,ImageContentType,ImageDiscription,ImageTitle,ImageType)VALUES(@time,@size,@data,@ContentType,@discription,@title,@type)";
写多一行了。

Answer 2

(@Imtime,@size,@data,@ContentType,@discription,@title,@type)";//"INSERT INTO Image

这里的 ";//"怎么回事？多个//干什么