insert into xx(xx,xx,xx,xx,...)values(@xx,@xx,@xx,...)
SqlParameter[] parameters = {
new SqlParameter("@ProductName", SqlDbType.NVarChar,250),
new SqlParameter("@CategoryID", SqlDbType.Int,4),
new SqlParameter("@Pictures", SqlDbType.NVarChar,500),
new SqlParameter("@Description", SqlDbType.Text),
new SqlParameter("@Price", SqlDbType.Decimal,9),
new SqlParameter("@Stock", SqlDbType.Int),
new SqlParameter("@Warrant", SqlDbType.SmallInt),
new SqlParameter("@AvailabilityDate", SqlDbType.DateTime),
new SqlParameter("@SaleItem", SqlDbType.Bit),
new SqlParameter("@SalePrice", SqlDbType.Decimal),
new SqlParameter("@GiftWrapping", SqlDbType.Bit),
new SqlParameter("@GiftPrice", SqlDbType.Decimal,9),
new SqlParameter("@Materials", SqlDbType.NVarChar,250),
new SqlParameter("@Color", SqlDbType.NVarChar,250),
new SqlParameter("@Weight", SqlDbType.NVarChar,250),
new SqlParameter("@Dimensions", SqlDbType.NVarChar,250),
new SqlParameter("@AlsoPurchased", SqlDbType.NVarChar,250),
new SqlParameter("@Keywords", SqlDbType.NVarChar,200),
new SqlParameter("@IsPerItem", SqlDbType.Bit),
new SqlParameter("@StandardPrice", SqlDbType.Decimal),
new SqlParameter("@StandardDays", SqlDbType.SmallInt),
new SqlParameter("@ExpressPrice", SqlDbType.Decimal),
new SqlParameter("@ExpressDays", SqlDbType.SmallInt),
new SqlParameter("@NextDayPrice", SqlDbType.Decimal),
new SqlParameter("@NextDayDays", SqlDbType.SmallInt),
new SqlParameter("@StoreID",SqlDbType.Int,4)
};
parameters[0].Value = model.ProductName;
parameters[1].Value = model.CategoryID;
parameters[2].Value = model.Pictures;
parameters[3].Value = model.Description;
parameters[4].Value = model.Price;
parameters[5].Value = model.Stock;
parameters[6].Value = model.Warrant;
parameters[7].Value = model.AvailabilityDate;
parameters[8].Value = model.SaleItem;
parameters[9].Value = model.SalePrice;
parameters[10].Value = model.GiftWrapping;
parameters[11].Value = model.GiftPrice;
parameters[12].Value = model.Materials;
parameters[13].Value = model.Color;
parameters[14].Value = model.Weight;
parameters[15].Value = model.Dimensions;
parameters[16].Value = model.AlsoPurchased;
parameters[17].Value = model.Keywords;
parameters[18].Value = model.IsPerItem;
parameters[19].Value = model.StandardPrice;
parameters[20].Value = model.StandardDays;
parameters[21].Value = model.ExpressPrice;
parameters[22].Value = model.ExpressDays;
parameters[23].Value = model.NextDayPrice;
parameters[24].Value = model.NextDayDays;
parameters[25].Value = model.StoreID;
给datetime,SmallInt,Decimal包含这三类型的参数赋空值,添加都会报错。DB 字段为可空model对属性的类型声明也是对应的。public int? Warrant错误提示:Parameterized Query '(@ProductName nvarchar(250),@CategoryID int,@Pictures nvarchar(5' expects parameter @Warrant, which was not supplied.挺急的,麻烦了解的哥们指点指点。thks
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货