protected void Page_Load(object sender, EventArgs e) { db = new Database(); db.Init_database(); DataTable mytable = db.get_Table("ManagerList"); if (!this.IsPostBack) { this.GridView1.DataSource = db.get_DataSet("ManagerList"); this.GridView1.DataBind(); } for (int i = 0; i < GridView1.Rows.Count; i++) { TableCell cell = new TableCell(); LinkButton link = new LinkButton(); link.ID = GridView1.Rows[i].Cells[1].Text+"change"; link.Text = "编辑"; link.Click += new EventHandler(Button2_Click); Label lb = new Label(); lb.Text = " "; LinkButton link2 = new LinkButton(); link2.Text = "删除"; link2.ID = GridView1.Rows[i].Cells[1].Text+"del"; link2.Click += new EventHandler(Button3_Click); cell.Controls.Add(link); cell.Controls.Add(lb); cell.Controls.Add(link2); GridView1.Rows[i].Cells.Add(cell); } }
protected void Page_Load(object sender, EventArgs e) { db = new Database(); db.Init_database(); this.GridView1.DataSource = db.get_DataSet("ManagerList"); this.GridView1.DataBind(); this.GridView3.DataSource = db.get_DataSet("UserList"); this.GridView3.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { db = new Database(); db.Init_database(); mytable = new DataTable(); mytable = db.get_Table("VegetableList"); foreach (DataRow myRow in mytable.Rows) { if (myRow["FCATEGORY"].ToString().Trim() == "1") { Panel p1 = new Panel(); p1.Width = 250; p1.Height = 230; p1.Style.Value = "float:left"; ImageButton im = new ImageButton(); im.ImageUrl = myRow["VIMAGE"].ToString(); im.ID = myRow["VNO"].ToString(); im.Width = 250; im.Height = 200; im.Click += new ImageClickEventHandler(Button3_Click); Label la = new Label(); la.Text = "购买数量:"; TextBox tt = new TextBox(); tt.Width = 40; tt.ID = myRow["VNAME"].ToString(); Label la2 = new Label(); la2.Text = " "; Button bt = new Button(); bt.Height = 30; bt.ID = myRow["VNAME"].ToString() + "?" + myRow["VIMAGE"].ToString(); bt.Click += new EventHandler(Button2_Click); bt.Text = "加入购物车"; p1.Controls.Add(im); p1.Controls.Add(la); p1.Controls.Add(tt); p1.Controls.Add(la2); p1.Controls.Add(bt); Panel1.Controls.Add(p1); } } }
protected void Page_Load(object sender, EventArgs e) { db = new Database(); db.Init_database(); mytable = new DataTable(); mytable = db.get_Table("VegetableList"); string temp = Request.QueryString.Get("id").ToString(); Label2.Text = temp; foreach (DataRow myRow in mytable.Rows) { if (myRow["VNO"].ToString().Trim().Equals(Label2.Text.Trim())) { Label4.Text = myRow["VNAME"].ToString(); Image1.ImageUrl = myRow["VIMAGE"].ToString(); Label5.Text = myRow["VSOLD"].ToString(); } } mytable2 = db.get_Table("UserEvaluation"); DataTable table = new DataTable(); table.Columns.Add(new DataColumn("用户")); table.Columns.Add(new DataColumn("评论")); for (int i = 0; i < mytable2.Rows.Count; i++) { if (mytable2.Rows[i]["BNO"].ToString().Trim().Equals(Label2.Text)) { TableRow tr = new TableRow(); TableCell tc = new TableCell(); tc.Text = mytable2.Rows[i]["Evaluation"].ToString(); TableCell tc2 = new TableCell(); tc2.Text = " "; TableCell tc3 = new TableCell(); tc3.Text = getName(mytable2.Rows[i]["UNO"].ToString()); tc3.Attributes.Add("style", "text-align:right"); tr.Cells.Add(tc); tr.Cells.Add(tc2); tr.Cells.Add(tc3); Table1.Rows.Add(tr); } } }
protected void Page_Load(object sender, EventArgs e) { string temp = Request.QueryString.Get("id").ToString(); Label1.Text = temp; db = new Database(); db.Init_database(); mytable = db.get_Table("UserList"); xd = new XmlDocument(); xd.Load(Server.MapPath("gouwuche.xml")); root = xd.DocumentElement; items = root.ChildNodes; foreach (XmlNode item in items) { TableRow tr = new TableRow(); TableCell tc = new TableCell(); foreach (XmlNode p in item) { if (p.InnerText.StartsWith("~")) { Image im = new Image(); im.Width = 60; im.Height = 50; im.ImageUrl = p.InnerText; tc.Controls.Add(im); tr.Cells.Add(tc); tc = new TableCell(); } else { TableCell tc2 = new TableCell(); tc2.Text = p.InnerText; tr.Cells.Add(tc2); } Table1.Rows.Add(tr); } } }
protected void Page_Load(object sender, EventArgs e) { db = new Database(); db.Init_database(); mytable = new DataTable(); if (Request.QueryString.Get("id") != null) { string temp = Request.QueryString.Get("id").ToString(); Label5.Text = temp; mytable = db.get_Table("UserList"); foreach (DataRow myRow in mytable.Rows) { if (myRow["UNO"].ToString().Trim().Equals(temp)) { temp = myRow["UNAME"].ToString(); } } Label2.Text = temp; Label2.Visible = true; LinkButton1.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { db = new Database(); db.Init_database(); if (!this.IsPostBack) { this.GridView1.DataSource = db.get_DataSet("VegetableList"); this.GridView1.DataBind(); this.GridView2.DataSource = db.get_DataSet("MeatList"); this.GridView2.DataBind(); this.GridView3.DataSource = db.get_DataSet("FisheryList"); this.GridView3.DataBind(); this.GridView4.DataSource = db.get_DataSet("CondimentList"); this.GridView4.DataBind(); this.GridView5.DataSource = db.get_DataSet("FruitList"); this.GridView5.DataBind(); } this.GridView1.ID = "VegetableList"; this.GridView2.ID = "MeatList"; this.GridView3.ID = "FisheryList"; this.GridView4.ID = "CondimentList"; this.GridView5.ID = "FruitList"; set(GridView1); set(GridView2); set(GridView3); set(GridView4); set(GridView5); }
protected void Page_Load(object sender, EventArgs e) { db = new Database(); db.Init_database(); DataTable mytable = db.get_Table("UserList"); }
protected void Page_Load(object sender, EventArgs e) { string temp = Request.QueryString.Get("id").ToString(); Label1.Text = temp; db = new Database(); db.Init_database(); mytable = db.get_Table("OrderForm"); mytable2 = db.get_Table("UserList"); DataTable table = new DataTable(); table.Columns.Add(new DataColumn("ONO")); table.Columns.Add(new DataColumn("ID")); table.Columns.Add(new DataColumn("Name")); table.Columns.Add(new DataColumn("ADDRESS")); table.Columns.Add(new DataColumn("EMAIL")); table.Columns.Add(new DataColumn("COUNT")); if (!this.IsPostBack) { for(int i=0;i<mytable.Rows.Count;i++) { if (mytable.Rows[i]["UNO"].ToString().Trim().Equals(Label1.Text)) { DataRow sourseRow = table.NewRow(); sourseRow["ONO"] = mytable.Rows[i]["ONO"]; sourseRow["ID"] = mytable.Rows[i]["UNO"]; sourseRow["Name"] = mytable.Rows[i]["ONAME"]; sourseRow["ADDRESS"] = mytable.Rows[i]["OADDRESS"]; sourseRow["EMAIL"] = mytable.Rows[i]["OEMAIL"]; sourseRow["COUNT"] = mytable.Rows[i]["COUNT"]; table.Rows.Add(sourseRow); } } for (int i = 0; i < mytable2.Rows.Count; i++) { if (mytable2.Rows[i]["UNO"].ToString().Trim().Equals(Label1.Text)) { Label16.Text = mytable2.Rows[i]["UNAME"].ToString(); Label17.Text = mytable2.Rows[i]["UPASSWORD"].ToString(); Label18.Text = mytable2.Rows[i]["UADDRESS"].ToString(); Label19.Text = mytable2.Rows[i]["UEMAIL"].ToString(); } } GridView1.DataSource = table; GridView1.DataBind(); } for (int i = 0; i < GridView1.Rows.Count; i++) { TableCell cell = new TableCell(); LinkButton link = new LinkButton(); link.ID = GridView1.Rows[i].Cells[0].Text + "check"; link.Text = "查看"; link.Click += new EventHandler(Button2_Click); Label lb = new Label(); lb.Text = " "; LinkButton link2 = new LinkButton(); link2.Text = "删除"; link2.ID = GridView1.Rows[i].Cells[0].Text + "del"; link2.Click += new EventHandler(Button3_Click); Label lb2 = new Label(); lb2.Text = " "; LinkButton link3 = new LinkButton(); link3.Text = "评论"; link3.ID = GridView1.Rows[i].Cells[0].Text + "pinglun"; link3.Click += new EventHandler(Button6_Click); cell.Controls.Add(link); cell.Controls.Add(lb); cell.Controls.Add(link2); cell.Controls.Add(lb2); cell.Controls.Add(link3); GridView1.Rows[i].Cells.Add(cell); } }