Question

在ASP.net中我出现插入值与表中定义不一致的问题。

SqlCommand insertCmd = new SqlCommand("insert into Book values(@BookName,@CategoryId,@Price,@Publisher,@PYear,@PMonth,@PDay,@Author,@PageNum,@PictureUrl,@Description)", conn);
就上面那样我要插入11个值。。可是却出现那个问题，不知道为什么？哪位大虾帮帮忙。。。。

Answer 1

SqlCommand insertCmd = new SqlCommand("insert into Book
（BookName,CategoryId,Price,Publisher,PYear,PMonth,PDay,Author,
PageNum,PictureUrl,Description
） values(@BookName,@CategoryId,@Price,@Publisher,@PYear,@PMonth,@PDay,@Author,@PageNum,@PictureUrl,@Description)", conn);

否则的话，我估计你那表里是有个叫ID的字段把？它会按顺序将BookName,CategoryId等插进去，也就是说，用BookName的值去插ID的值

Answer 2

我的记忆中SQL字符串并不是用@加变量名表示变量的,这种表示方法应该是用在存储过程,你试试这种形式:

SqlCommand insertCmd = new SqlCommand("insert into Book values("&BookName&","&CategoryId&","&Price&","&Publisher&","&PYear&","&PMonth&","&PDay&","&Author&","&PageNum&","&PictureUrl&","&Description&")", conn);

Answer 3

也许是你的参数类型搞的和表里的类型不一致

Answer 4

你表中是不是有12个列或者更多？？