急啊,购物多条数据记录如何插入数据库!!!
代码是这样:
for (int i=0; i<ShoppingCartList.Items.Count; i++)
{
try
{
productsModel= shoppingCart[(String) ShoppingCartList.DataKeys[i]].Name;
productsNum =shoppingCart[(String) ShoppingCartList.DataKeys[i]].Quantity;
price= shoppingCart[(String) ShoppingCartList.DataKeys[i]].Price;
productsId = shoppingCart[(String) ShoppingCartList.DataKeys[i]].ProductID;
strSQL="insert into shop_cart(orderId,productsId,productsModel,price,productsNum,userId) values('"+orderId+"','"+productsId+"','"+productsModel+"',"+price+",'"+productsNum+"','"+userId+"')";
Response.Write(strSQL+"<br>");
SqlCommand cm2=new SqlCommand(strSQL,cn);
cm2.ExecuteNonQuery();
}
catch (Exception)
{
}
}
但觉得有问题,请指教!!!