protected void Page_Load(object sender, EventArgs e)
{ OleDbDataAdapter myoda = new OleDbDataAdapter("select top 8 [no],(chsname+[size]) as listname,([path]+[name]) as listlink from mp4 order by [no] desc", ss); myoda.Fill(dt); this.List1.DataSource = dt;
this.List1.DataTextField = "listname";
this.List1.DataValueField = "listlink";
this.List1.DataBind();
}如上在webform加载时给list邦定数据源,这个没有问题,但当select条件改变再次邦定list 时新的记录会接着源有的记录显示,而不是显示新查询的记录,代码如下,怎么让list在邦定新的数据源时只显示新的记录,不要接着源有的记录一起显示 protected void Command1_Click(object sender, EventArgs e)
{ OleDbDataAdapter oda = new OleDbDataAdapter("select top 8 [no],(chsname+[size]) as listname,([path]+[name]) as listlink from mp4 where [no]=5 order by [no] desc", ss); oda.Fill(dt); strno = (int)dt.Rows[0][0];
this.Command2.Visible = true; this.List1.DataSource = dt;
this.List1.DataTextField = "listname";
this.List1.DataValueField = "listlink";
this.List1.DataBind(); }
{ OleDbDataAdapter myoda = new OleDbDataAdapter("select top 8 [no],(chsname+[size]) as listname,([path]+[name]) as listlink from mp4 order by [no] desc", ss); myoda.Fill(dt); this.List1.DataSource = dt;
this.List1.DataTextField = "listname";
this.List1.DataValueField = "listlink";
this.List1.DataBind();
}如上在webform加载时给list邦定数据源,这个没有问题,但当select条件改变再次邦定list 时新的记录会接着源有的记录显示,而不是显示新查询的记录,代码如下,怎么让list在邦定新的数据源时只显示新的记录,不要接着源有的记录一起显示 protected void Command1_Click(object sender, EventArgs e)
{ OleDbDataAdapter oda = new OleDbDataAdapter("select top 8 [no],(chsname+[size]) as listname,([path]+[name]) as listlink from mp4 where [no]=5 order by [no] desc", ss); oda.Fill(dt); strno = (int)dt.Rows[0][0];
this.Command2.Visible = true; this.List1.DataSource = dt;
this.List1.DataTextField = "listname";
this.List1.DataValueField = "listlink";
this.List1.DataBind(); }
同意一搂