大家好,我想问一下绑定前能不能再对数据进行一下筛选, DataSet ds = new DataSet();
string sqlstr = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(sqlstr);
SqlDataAdapter sqlad = new SqlDataAdapter("select * from Announcement", sqlconn);
sqlad.Fill(ds, "Ansort");
Repeater2.DataSource = ds.Tables["Ansort"];
Repeater2.DataBind();也就是说我不想让表中的数据全部显示出来,可以选项显示的那种,
string sqlstr = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(sqlstr);
SqlDataAdapter sqlad = new SqlDataAdapter("select * from Announcement", sqlconn);
sqlad.Fill(ds, "Ansort");
Repeater2.DataSource = ds.Tables["Ansort"];
Repeater2.DataBind();也就是说我不想让表中的数据全部显示出来,可以选项显示的那种,
可以通过sql重新筛选,也可以通过datatable的Select方法
Repeater2.DataSource = ds.Tables["Ansort"].Select("An_sort='公司公告'");