62,025
社区成员
发帖
与我相关
我的任务
分享
public bool ExistProduct(DataTable cart)
{
string sqlconnstr = ConfigurationManager.ConnectionStrings["ConnetionString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(sqlconnstr);
SqlCommand sqlcommand = new SqlCommand();
sqlcommand.Connection = sqlconn;
sqlconn.Open();
sqlcommand.CommandText = "select * from Product";
SqlDataReader sqldatareader = sqlcommand.ExecuteReader();
while (sqldatareader.Read())
{
foreach (DataRow dr in cart.Rows)
{
if (dr["ProductName"].ToString().Equals(sqldatareader.GetString(1)))
{//若购物车中存在用户要购买的商品,则商品数量+1
dr["Number"] = Convert.ToInt32(dr["Number"]) + 1;
//将购物车保存到Session["Cart"]中
Session["Cart"] = cart;
Response.Redirect("");
}
}
return true;
}
sqlcommand = null;
sqlconn.Close();
sqlconn = null;
//这里加一个return false;
return false;
}