protected void Page_Load(object sender, EventArgs e)
{
string id = Request["goodsid"];
// string id = "1";
Session["liuyan"] = liuyanDl;
DataAccess MarketBase = new DataAccess();
SqlConnection conn = new SqlConnection(MarketBase.SqlBase);
conn.Open();
if (!IsPostBack)
{
int state = MarketBase.ModInfo("update goods set downcount=downcount+1 where goodsid='" + id + "'", conn);
}
DataTable MarketDt = new DataTable();
MarketDt = MarketBase.DisPlayList_Ds("select * from goods where goodsid='" + id + "'", conn);
MarketDetailDl.DataSource = MarketDt.DefaultView;
MarketDetailDl.DataBind();
DataSet ds = new DataSet();
SqlDataAdapter adpter = new SqlDataAdapter("select * from message where goodsid='" + id + "'", conn);
adpter.Fill(ds);
liuyanDl.DataSource = ds.Tables[0].DefaultView;
liuyanDl.DataBind();
}
public void load()
{
DataAccess data = new DataAccess();
data.Connection();
string sqlcom = "select goodsid,images,goodsname,goodsprice,goodssort,connectpeople,phone,datetime from [Goods] ";
SqlCommand cmd = data.excute(sqlcom);
DataSet ds = data.Fill(cmd);
MarketDetailDl.DataSource = ds.Tables[0].DefaultView;
MarketDetailDl.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request["NId"];
DataAccess MarketBase = new DataAccess();
SqlConnection conn = new SqlConnection(MarketBase.SqlBase);
conn.Open();
DataTable MarketDt = new DataTable();
MarketDt = MarketBase.DisPlayList_Ds("select * from tb_Notice where NId='" + id + "'", conn);
MarketDetailDl.DataSource = MarketDt.DefaultView;
MarketDetailDl.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string name = Session["UName"].ToString();
DataAccess MarketBase = new DataAccess();
SqlConnection conn = new SqlConnection(MarketBase.SqlBase);
conn.Open();
DataTable MarketDt = new DataTable();
MarketDt = MarketBase.DisPlayList_Ds("select * from tb_UserInfo where UName='" + name + "'", conn);
MarketDetailDl.DataSource = MarketDt.DefaultView;
MarketDetailDl.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request["GId"];
DataAccess MarketBase = new DataAccess();
SqlConnection conn = new SqlConnection(MarketBase.SqlBase);
conn.Open();
//if (!IsPostBack)
//{
// int state = MarketBase.ModInfo("update goods set downcount=downcount+1 where goodsid='" + id + "'", conn);
//}
DataTable MarketDt = new DataTable();
MarketDt = MarketBase.DisPlayList_Ds("select * from tb_Goods,tb_UserInfo,tb_GoodType where tb_Goods.UId=tb_UserInfo.UId and tb_Goods.GTypeId=tb_GoodType.GTypeId and tb_Goods.GId='" + id + "'", conn);
MarketDetailDl.DataSource = MarketDt.DefaultView;
MarketDetailDl.DataBind();
}
