DataList的用法.docVIP

1 数据绑定,绑定的方式为 %# DataBinder.Eval(Container.DataItem,”name) % public partial class _Default : System.Web.UI.Page { SqlConnection sqlcon; string strCon = Data Source=(local);Database=db_04;Uid=sa;Pwd=why20080104019; protected void Page_Load(object sender, EventArgs e) { sqlcon = new SqlConnection(strCon); string sqlstr = select top 1* from tb_Member; SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open(); myda.Fill(myds, tb_Member); DataList1.DataSource = myds; DataList1.DataBind(); DataRowView mydrv = myds.Tables[tb_Member].DefaultView[0];//ds中缓存的表格“tb_Member” for (int i = 0; i = DataList1.Items.Count - 1; i++) { Label lab = (Label)DataList1.Items[i].FindControl(Label1); int money = Convert.ToInt32(mydrv[money]); lab.Text = money.ToString(￥#,###.00); } sqlcon.Close(); } } 2.分页功能 int curpage = Convert.ToInt32(this.Label2.Text.ToString().Trim()); PagedDataSource ps = new PagedDataSource(); sqlcon = new SqlConnection(strcon); SqlDataAdapter sda = new SqlDataAdapter(select * from tb_GoodsType, sqlcon); DataSet ds = new DataSet(); sda.Fill(ds, tb_GoodsType); ps.DataSource = ds.Tables[tb_GoodsType].DefaultView; ps.AllowPaging = true; ps.PageSize = 2;//实现分页 LinkButton1.Enabled = true; LinkButton2.Enabled = true; LinkButton3.Enabled = true; LinkButton4.Enabled = true; ps.CurrentPageIndex = cur1; if (curpage == 1) { this.LinkButton1.Enabled = false; this.LinkButton2.Enabled = false; } if (curpage == ps.PageCount) { this.LinkButton3.Enabled = false; this.LinkButton4.Enabled = false; } this.Label3.Text = Convert.ToString(ps.PageCount); DataList1.DataSource = ps;