using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient; public partial class ShopCar : System.Web.UI.Page
{
DataSet ds = new DataSet();
DataOperator db = new DataOperator();
public void DataListBind()
{
string sqlstr;
sqlstr = "select * from 购物车视图 where 会员名='" + Session["username"] + "'";
ds = db.GetDTbysql(sqlstr);
try
{
DataList1.DataSource = ds;
DataList1.DataBind();
}
catch
{
Response.Write("<script>alert('没有得到数据，请重试！')</script>");
} }
protected void Page_Load(object sender, EventArgs e)
{
Session["username"] = "aaa";
//SqlConnection con = new SqlConnection();
//SqlCommand com = new SqlCommand();
//SqlDataAdapter da = new SqlDataAdapter();
//con.ConnectionString = "server=(local);database=网上书店;uid=sa;pwd=123456";
//com.Connection = con;
//com.CommandText = "insert into 购物车表 values ('" + Session["username"]+ "',"+ Session["book_id"] + ",1)";
string sqlstr;
sqlstr = "insert into 购物车表 values ('" + Session["username"] + "'," + Session["book_id"] + ",1)";
/*try
{
con.Open();
com.ExecuteNonQuery();
}
catch
{
Response.Write("数据无法操作");
}
finally
{ con.Close(); }
*/
Boolean insert_bool;
insert_bool = db.UpDataBySql();
if (insert_bool = true)
{
DataList1.DataBind();
}
else
{
Response.Write("购物车无数据");
}
}
}